Error with Sub Report - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Error with Sub Report

Author

Topic

kathyc
Starting Member

9 Posts

Posted - 2009-03-15 : 08:22:11

I have a main report that has the following parameters:
@Region (int)
@UserName (varchar)
@CurrentDate (datetime)

On my sub report, I have added these parameters,

Parameter Name Parameter Value
Region @Region
UserName @UserName
CurrentDate @CurrentDate

but when I run the report, I get the following error:

[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport1’:
The value provided for the report parameter 'CurrentDate' is not valid for its type.

What have I done wrong?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-16 : 14:16:45

make sure your parent report and subreport language properties are same.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources