Groups | Blog | Home
all groups > sql server reporting services > march 2006 >

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


Ralph Watermann
3/14/2006 3:59:04 PM
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,
Ralph

toolman
3/15/2006 8:55:49 AM
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).
Ralph Watermann
3/16/2006 11:50:19 AM
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...
[quoted text, click to view]

AddThis Social Bookmark Button