Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : Localization problem


Lev Semenets [MSFT]
9/15/2004 5:51:03 PM
this could happend because of session/caching of the subreport.
Click "Refresh" button on the toolbar when viewing the subreport.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Mauricio Cadima
9/15/2004 6:10:04 PM
Hi
I have a report with a "Jump to report" navigation field to a second report
, some of the parameters to the second report are DateTime values, when my
Local Settings are setted to English (United States) the link works fine,
but when I change my Local Settings to Spanish I get a Type Mismatch
message for this DateTime parameters. The "Language" property of both
reports are "Default", and when I execute by my self the second report
specifying each parameter with the correct locale datetime format it works
fine.
Any idea?
Thanks

Mauricio Cadima
9/16/2004 12:54:52 PM
Thanks for your answer, but I think that is not the problem.



Let me explain the problem again, I have a first report with two parameters,
"Start Date" and "End Date" that are used when the report is executed to get
some information from some DB for this time range, this information is
showed in a table where the first column values are links to other report
(not a subrerport), this second report also uses date range parameters and
its values should be the same of the first report parameters, this means
that also should be specified in the link.



So when I click the link to open the second report and I have Spanish or
other locale selected for my system regional options a type mismatch message
is showed instead of the second report:



"The value provided for the report parameter 'EndDate' is not valid for its
type. (rsReportParameterTypeMismatch)"



My intuition is that the problem is with the date format, the date format
for Spanish locales is 'dd/mm/yyyy' and for english locale 'mm/dd/yyyy' I
think that the second report is trying to build its date time parameters
with the English locale and here is where the exception is raised. E.g. set
a value greater than 12 as month.



When I execute the second report specifying the parameters values manually
with the correct locale date format the report is showed without problems.
When I see the "Language" property of both reports in design mode is set to
default, I suppose that means that the report should works with the system
locale settings and use the correct date formats.



Thanks

Mauricio



[quoted text, click to view]

Lev Semenets [MSFT]
9/16/2004 7:28:12 PM
What are parameters values that you pass to second report? What do you put
into Parameter Value cell of Parameters dialog?

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Mauricio Cadima
9/17/2004 4:37:02 PM
The same values of the first report parameters:
Parameter Name Parameter Value
StartDate =Parameters!StartDate.Value
EndDate =Parameters!EndDate.Value

[quoted text, click to view]

Gearoid
12/7/2004 2:51:46 AM
I have having the very same problem. Did you ever solve this? And how
if you did?!

Thanks
AdamB
12/14/2004 10:33:03 PM
I have this problem as well, even though my report language is set to English
(United Kingdom), my Asp.Net app that calls the reporting service web service
is using en-GB as culture. It still thinks that my parameter End Date should
be in mm/dd/yyyy format and pukes when it sees something like 14/12/2004
(December 14, 2004) come over.

[quoted text, click to view]
Joe
1/11/2005 2:07:02 AM
Adam,

Check the "Language Settings" for your browser.

Open IE, goto Tools->Internet Options->Click 'Languages...' button on the
General tab. Check that your language is English (United Kingdom)

I have got MSRS to work fine with UK English format dates.... apart from
when reports are linked using 'Jump to' action.

Joe


[quoted text, click to view]
Harry
2/21/2005 11:05:03 PM
Try this and see if it works
Parameter Name Parameter Value
StartDate =Format(Parameters!StartDate.Value,
"dd-MMMM-yyyy")
EndDate =Format(Parameters!EndDate.Value,
"dd-MMMM-yyyy")

Cheers,
Harry

[quoted text, click to view]
AddThis Social Bookmark Button