Friday, March 23, 2012

RS2005: Datetime-Parameter-Problem, only(!) on server

Hello,
we are facing a datetime-parameter-problem, that does not occur during
preview but when the report is deployed to the server:
We have the following situation:
Report A:
Parameter: Date (Datetime with picker), some other string parameters
Report B:
Parameter: Date (Datetime with picker), some other string parameters
Now wie navigate from some table field from ReportA to ReportB with the
following parameter-mapping:
Date=Parameters!Date.Value
In the preview and the local debug, everything works fine, but as soon as
the reports are executed on the server, day and month are swapped!
On the client there is a german WindowsXP and on the server an english
WindowsXP. What is the problem and what can we do?
Regards,
RalphCan you change the client from German to English? It sure sounds like
that's your problem. If you can't, then you'll need to find a way to
format your date in the English-US (mmddyyy) instead of (ddmmyyyy).|||Hi tool man,
many thanks for your reply.
The problem is that I can't tell in advance if the server system, the sql
server 2005 on the system are german or english, and we have definitely
clients with different language settings and different browsers in different
languages...
Any ideas? Many thanks in advance,
Ralph
"toolman" <timd@.infocision.com> schrieb im Newsbeitrag
news:1142441749.516338.297680@.u72g2000cwu.googlegroups.com...
> Can you change the client from German to English? It sure sounds like
> that's your problem. If you can't, then you'll need to find a way to
> format your date in the English-US (mmddyyy) instead of (ddmmyyyy).
>

No comments:

Post a Comment