Culture Issues With Reporting Services

  • Hi,

    I have my reporting server installed on my server that has Regional Settings set to en-US and my report uses a stored procedure to retrieve the data for rendering, the problem is when I change language in Browser setting to something like en-CA from en-US, the date format changes and the input parameters to report throws an typemismatch error. Like if I pass 01/13/2004 as a fromdate it throws an exception that the fromdate is not valid saying rsReportParameterTypeMismatch Error.

    Any help would be highly appreciated.

     

    Thanks in Advance.

     

    Prasad Bhogadi
    www.inforaise.com

  • This was removed by the editor as SPAM

  • When I have a hard coded date,  I use convert  with the appropiate datestyle to convert the string to a date.  That makes it independent of the environment.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply