Odd drill though date problem

Question

Odd drill though date problem

daniel gibbs

SSC Journeyman

Points: 82
More actions
June 12, 2007 at 3:50 am

#174080

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 report peramiters to limit the data shown, this includes 2 dates.
When accessing the first report I pass a uk date in (dd/mm/yyyy) but RS reformates 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, but passes a us date to the drilldown 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.
edit: I've updated this to make mose sense (hopefully)
Thanks
Dan

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

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

Piers-378326 SSC Enthusiast Points: 121 More actions · Answer 1

I have had problems with dates too. Make sure the default language for the report is UK. To do this, in the properties panel use the drop down above the properties themselves and select Report (or just click on the background of the design area not the grid). Now scroll down to the Language property itself and change this to "English (United Kingdom)"

I have found you also need to have your browser configured for UK too. I only use IE and in there go in Tools menu and language change this to English (United Kingdom) too.

This should stop the date formats being changed for you...

jvElecenter SSCarpal Tunnel Points: 4502 More actions · Answer 2

You can do this indeed with the default language.

You can also use the set dateformat in T-qsl, I guess

JV

daniel gibbs SSC Journeyman Points: 82 More actions · Answer 3

Hi, Changing the language of the report doent make a diffrence.

I've tryed setting it to english uk which doesnt make a diffrence, setting to english us it still wants a uk date passing in.

Dan

jvElecenter SSCarpal Tunnel Points: 4502 More actions · Answer 4

DAn,

And using the set dateformat function ?

set dateformat dmy

JV

daniel gibbs SSC Journeyman Points: 82 More actions · Answer 5

Can set dateformat be used within reportingservices?

How do you use it ?I currently use = Parameters!startdate.Value

Or can you set it to be report level?

thanks

dan

jvElecenter SSCarpal Tunnel Points: 4502 More actions · Answer 6

Dan

Do you use stored procedures or do u use t-sql within yr dataset ?

In both u can mention on top set dateformat.

It solved a date issue of mine.

If u use dates within a stored procedure we had to use converts (twice), see example :

where PWSL.[Shipment Date] between

convert(datetime,''' + convert(varchar(10),@dtStart,103) + ''',103) and convert(datetime,''' + convert(varchar(10),@dtEnd,103) + ''',103)

JV

daniel gibbs SSC Journeyman Points: 82 More actions · Answer 7

Arr, I havnt explained this very well.

By peramiters I mean report peramiters not sp peramiters.

We have a web app that asks the users what date range they want to see, which is passed into the report url.