| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2008-07-29 : 08:47:58
|
| Hi,I have a reporting services report. A user can run it normally, the others are getting the following error:"The value provided for the report parameter 'ToDate' is not valid for its type. (rsReportParameterTypeMismatch)"They are only able to run the report when they choose date where the day value is under or equal to 12, otherwise they get the error.Does anybody know the solution to my problem?It's urgent.Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-29 : 11:29:32
|
| yup. its because they are having a regional setting of pc different from language setting of report. either change the language of setting of your report which is easiest thing to do or ask them to change their regional setting of pc.The reason for this error is because as per regional setting browser puts the date value which will be wrongly interpreted by report according to its language setting and will error when day is over 12 (it interprets it as month and anything over 12 for month value is invalid) |
 |
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-07-30 : 03:03:32
|
| I don't think it's a regional settings issue because even when i open the report from the same pc for all users, one user can open it and the others get the error.So how can i fix the error? |
|
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-07-31 : 09:45:37
|
| How can i set the ReportServer date format settings? |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-04 : 03:33:52
|
| Regional settings can be user-specific, based on the user profile. Are your users in different countries? Or have they manually customised them? This may be a limit to internationalisation within SSRS. I know there are date issues within VS. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-04 : 13:52:15
|
quote:
Originally posted by 1sabine8
I don't think it's a regional settings issue because even when i open the report from the same pc for all users, one user can open it and the others get the error.So how can i fix the error?
Are you sure your report language setting is same as that of your pc? |
|
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-08-05 : 08:49:37
|
| Yes it is.Still can't find a solution |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-05 : 13:34:20
|
quote:
Originally posted by 1sabine8
Yes it is.Still can't find a solution
Is this problem happening in both report manager and also in report viewer? |
|
|
|
xxprince
Starting Member
1 Post |
Posted - 2008-08-19 : 00:55:22
|
| I had the same problem and I fixed it by changing the date format in the registional settings to American (mm/dd/yyyy) this solved the problem me. Hope this is useful. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-19 : 01:13:47
|
quote:
Originally posted by xxprince
I had the same problem and I fixed it by changing the date format in the registional settings to American (mm/dd/yyyy) this solved the problem me. Hope this is useful.
Thats what i suggested. But OP had replied the setings were correct for PC & report and problem still persist. may be the below is causehttp://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=271099 |
|
|
|
|
Reporting Services Date Parameter Error