all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

Regional settings problem between server and client


Regional settings problem between server and client Harry
3/30/2005 10:51:08 PM
sql server reporting services:
I have posted this before as well and seems like no one has any solution for
this problem (even microsoft). Posting it again please help me, see below.

I have two reports(lets say Report1 and Report2) and both have filter
parameters as start date and end date.

Report1 has drilldown ability and opens up Report2 using date parameters
from Report1. Upto here it works fine no problems with date format because
when I pass dates from Report1 to Report2, I format them into "dd-MMM-yyyy"
format.

Now, problem happens when I open Report2 from Report1 and then hit refresh
on Report2 , its changes the date parameter format on report2 as
"MM/dd/yyyy". Which results in wrong data on report2 or gives an error(if day
is greater than 12 in the month).

Keep in mind that I am running these report in IE from a client machine
which has Australian Regional Settings and the server where both reports are
installed has US Regional Settings. (NOTE: if I change both server and client
to same regional settings then it works fine)

I hope, this is enough information for this problem.
Please help me as soon as possible, I need this fixed as early as possible.

Thanks,
Harry
Re: Regional settings problem between server and client ** Spirits **
4/1/2005 12:25:10 AM
well dear though its not a best solution but i hope it ll at least
resolve ur problem y dont u change datatype of ur parameter from
datetime to string and then pass the parameter as string it ll simply
resolve the problem
i wish it ll help u out
AddThis Social Bookmark Button