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

sql server reporting services : Non-existing parameter in the report parameters collection



Vaibhav
12/29/2004 2:15:39 PM
try this
Parameters!INVNO.Value

[quoted text, click to view]

Jason DeWeeese via SQLMonster.com
12/29/2004 5:50:22 PM
I have the following code in my report:

Protected Overrides Sub OnInit()
Dim strTemp as String
strTemp = Report.Parameters("PersonNameParam").Value
End Sub

For now I am just trying to get the value of the parameter, but when I try to preview the report I get the following error.

"Failed to load expression host assembly. Details: The expression referenced a non-existing parameter in the report parameters collection. (rsProcessingError)"

I have also tried accessing the parameter as:
Report.Parameters!PersonNameParam.Value
but I got the same error.

Thanks in advance for any help.

--
Jason DeWeeese via SQLMonster.com
12/29/2004 8:56:09 PM
Thanks, but unfortunately that did not work. I am still getting the same error. Any other suggestions?

--
Jeff A. Stucker
12/30/2004 4:28:37 PM
If you right-click on report background, and select Report Parameters, that
should show you the valid parameters for the report. Perhaps you need to
add one.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

AddThis Social Bookmark Button