User getting error The vlaue provided for the report parameter is not valid for it's type

• megan_c99

  SSC Rookie

  Points: 28

  More actions

  June 27, 2012 at 9:34 am

  #258056

  Hi,

  I have a very puzzling issue. I have a report which takes a date parameter, works for me and another colleague but does not work for two other users.

  User gets error - The value provided for the report parameter 'dtFromDate' is not valid for it's type.

  Created report using MS Visual Studio 2008, SQL Server 2008. Accessing the reports using IE.

  This is the url

  http://myservername/Reportserver?/SAiD/NewHireDeparturesTempLeaveIT&iViewMode=3&dtFromDate=25/6/2012

  The weird thing is if I change the date format to 6/25/2012 I get the same error but otherwise the above works for me but not for the 2 other users.

  Any help will be greatly appreciated.

  Thank you.

  Megan

• Spiff

  SSCertifiable

  Points: 7826

  More actions

  June 28, 2012 at 6:44 am

  #1506570

  Have you tried setting the ParameterLanguage in the URL?

  This forces it to accept the paramter in the desired format.

  e.g. rs:ParameterLanguage=en-GB

• Spiff

  SSCertifiable

  Points: 7826

  More actions

  June 28, 2012 at 6:58 am

  #1506582

  The users probably have their default browser language settings as en-US and yours is en-GB so it messes up the date conversion.