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
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 non-existing report parameter

Author  Topic 

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-07-21 : 01:02:30
Hi,

I'd set a parameter for my report and then removed it but when I build the report now it says:
Error 1 [rsParameterReference] The Hidden expression for the table ‘table1’ refers to a non-existing report parameter ‘Report_Parameter_0’. e:\sql-investigation\seprjreport\seprjreport\Requests.rdl 0 0
Could u tell me why?

dexter.knudson
Constraint Violating Yak Guru

260 Posts

Posted - 2008-07-21 : 01:07:21
Yes. This is frustrating. It can also ocur when the param name is changed to a different case. Try going to the relevant data set & click the edit button & then the parameters tab & delete it from there. If it's not there, you may need to delete it from the xml file.
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-07-21 : 01:13:28
It's resolved
Thank you dexter
I removed it from xml file
Go to Top of Page
   

- Advertisement -