Post reply

Reporting Services Date Paramater Format Problem

  • October 30, 2007 at 5:31 am

    #178901

    HI

    I have a developer that has a SSRS2005 report that uses a date parameter, when displayed through the Reports Manager URL the date picker is in UK format and the report runs fine, but when it runs through the report server the date picker uses US format and the report errors. I have set everything i can find to en-gb but still no luck.

    Has anyone else come across this or has a solution, the only one i can now think of is to use seperate picklists for the Day, Month and Year!

    Cheers,

    Paul :w00t:

  • November 2, 2007 at 12:52 pm

    #747918

    You mean this problem? I am not satisfied with the answer on the thread, but it does pretty much confirm the need to have separate year, month, and day drop downs.

  • December 31, 2007 at 5:15 am

    #763668

    Hi,

    You can change date format by writing following expression.

    DatePart("d",Parameters!startdate.Value) & "/" & DatePart("m",Parameters!startdate.Value) & "/" & DatePart("yyyy",Parameters!startdate.Value) & " and " & DatePart("d",Parameters!enddate.Value) & "/" & DatePart("m",Parameters!enddate.Value) & "/" & DatePart("yyyy",Parameters!enddate.Value)

    Pleaes change parameters!startdate.value to your appropriate field. If it is parameter then you need to change startdate field. If it is particular fields then you can change it accordingly.

    Hope this helps.

    Vijay

  • June 26, 2008 at 2:43 am

    #834468

    I'm having the same issue.

    Can you explain where i would have to put that code?

    The calendar is displaying dates in american format i want it in Asutralia format.

    I have set the Report language property to en-AU.

    The regionla setting on my pC is also in Australia..

    Please elaborate

    Thanks

  • June 27, 2008 at 1:33 am

    #835186

    Fixed it and blogged it here:

    http://geekswithblogs.net/naijacoder/archive/2008/06/26/123422.aspx

  • June 8, 2009 at 3:06 pm

    #1006322

    Vijay

    Thank you I was able to use part of your code to fix a problem I was having 🙂

  • June 8, 2009 at 6:18 pm

    #1006372

    Goo to know that

  • June 9, 2009 at 1:47 pm

    #1007027

    glad you are sorted.

Viewing 8 posts - 1 through 7 (of 7 total)

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