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.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2013-04-04 : 12:31:06
|
| Hi,My ssrs report has several datasets.One of them uses a stored procedure (sp) which takes two parameters.When I try to run the report, the error is:The report parameter 'MyCode' has a defaultvalue or a validvalue that depends on the report parameter 'TableName'The parameter 'TableName' is refering to the dataset as mentioned above which uses spAny thoughts please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-04 : 14:24:57
|
| the reason for error is you've either set an expression or a dataset for default value of MyCode parameter which is having a reference to parameter TableName and it seems you've not set any default for latter------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2013-04-05 : 02:57:33
|
quote:
Originally posted by visakh16
the reason for error is you've either set an expression or a dataset for default value of MyCode parameter which is having a reference to parameter TableName and it seems you've not set any default for latter------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
I have set a default for TableName though. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-09 : 01:16:57
|
| is tablename defined before or after MyCode?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
parameter dependency