Odd drill though date problem

Hi, i'm quite new to Reporting Services and am having some problems with a drill through I've sert up.

I have about 10 reports that link to each other passing all the required peramiters to limit the data shown, this includes 2 dates.

When accessing the first report I put a uk date in (dd/mm/yyyy) but RS decides to change it to a us date (mm/dd/yyyy) which the second report doesnt like as It's expecting a uk date.

I cannot pass the first report a us date as it doent like it.
If i pass it a iso date (yyyy-mm-dd) RS converts it into a uk date and passes that into the report.

I dont beleve I should have to manually format the date for the linkthoughs, but cant find a way around this.
I've tryed the reports on 2 diffrent RS 2000 servers with the same results.
Thanks

Dan

Hi Dan,

In the properties of report all the components can be listed on the top select Report in it and then in Language select English(United Kingdom). This should change the default format to dd/mm/yyyy

Hope this Helps.

|||It is better practice to set Language to "=User!Language".

This picks up the locale from IE.

You can still override formatting on individual items.

Read more:
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

scroll down to #93|||Hi, I've tryed setting the report manguage to 'Default', English(United kingdom), =User!Language none worked .
I even decided that the date format isnt really important and set the second level report language to English United states, but the report still wanted a uk date!

ag: There is no #93, I assume you mean #33

cheers
|||There is a 93, but you have to scroll down - they have not updated the contents at the top.

I think it might be case sensitive.

In the "language" box in report properies, click on 'expression'.

Then use the boxes at the bottom of the editor to select 'user ! lang...'

Think it is in constants or globals, whatever. Double click it to select.

If it still is not working with user!language, it means your IE settings are not set to UK

Can someone else post how to change IE regional settings, I can't be arsed.|||Hi, I've used = User!Language via the expression editor with no luck.
I've written = User!Language to a text box which prints en-GB so IE must be set to english (uk).

I've found no 93, IE doent show anything above no 38, Firefox however does.

|||You haven't overridden the settings in Start - control panel - regional.. - reg. options.

have you?

I remember a box once having short date as UK and long date as US.

I am using FF, well spotted.

Also check IE - options - general - languages...

and check the lang pref order.

The textbox doesn't have an overriding format ?|||No will be right, will check again in the morning.
I had another guy try the report with the same problem.
I've tryed creating 2 new reports one links to the second, this still has the same problem.

I'm really baffled with this.
|||

Are you having the problem in the Visual Studio IDE, or in the report server when you have deployed the report? I find that in the IDE it ignores UK date formatting...but when deployed to the report server it works fine.

Regards

Jof

|||

The ide requires the date to be passed as a us date so doesnt have this porblem.

The deployed rpeorts however expect the dates to be passed as uk.

dan