SSRS - date-time parameter transposition

0
votes

This is a problem in DEV with the following configuration:

  1. SSRS 2012
  2. Reports configured to the language en-gb

I have recently noticed that all of my date time parameters are getting transposed when i click "View Report". So for example a GB date 08/01/2015 gets transposed to 01/08/2015 on clicking "View Report". This results in having to click the button twice for the report to show me the correct data. I have used SSRS on and off for many years and I have never noticed this before. Can anyone shed some light on this?

Obviously the parameter is switching between en-gb and en-us but why and how do i stop it?

I found a post where some one is suffering from the same problem as me but their solution seems a little overkill issue with DateTime datatype in SQL Server Reporting Services. They recomend changing your regional settings and IIS settings which may fix and or break all sorts.

1
reporting-servicesssrs-2012
I've tried to replicate your issue; however, the date is displayed as expected depending on en-gb or en-us - BI Dude

1 Answers

1
votes

I believe that the problem can be how do you set up the default value in the parameter definition. If instead of a fixed date, you use a dataset with a date time funtcion (something like " Select dateadd(month,-1,current_timestamp) as [Default Date]") and a default value based on that dataset, your problem could be solved, because you're not specifying any date format in the dataset's field and it should contain the right value. Hope this helps.