Date Format problem for drill down

Please help me.
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,
HarryJust format the date when you pass it as a parameter, the way the new report
wants it..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Harry" <Harry@.discussions.microsoft.com> wrote in message
news:294301DB-F414-4C9C-B29B-3538FFDD32FA@.microsoft.com...
> Please help me.
> 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|||How do I format date, I cannot find the place. I think its all happening
inside Reporting Services Service.
Or I think you did not understand the problem properly.
I am not passing any dates, all I am doing is on Report2 (when opened
through Report1 as drill down it works fine) as you hit refresh it gives
error "The value provided for the report parameter 'dtToDate' is not valid
for its type".
for ref please read the previous post by me
Thanks,
Harry
"Wayne Snyder" wrote:
> Just format the date when you pass it as a parameter, the way the new report
> wants it..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Harry" <Harry@.discussions.microsoft.com> wrote in message
> news:294301DB-F414-4C9C-B29B-3538FFDD32FA@.microsoft.com...
> > Please help me.
> >
> > 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
>
>