|
I have gotten this error a few times and could not figure out why or how to fix.
Thanks to many hours of internet research and asking questions all over the internet, I found the answer.
It is so simple it pisses me off that it took so long to figure out.
The problem
When you create a report with a query that has a parameter in the WHERE clause, Microsoft SQL Reporting Services does not always recognize the parameter in the query as a report parameter.
Usually, when you do put the parameter in and then look at the Report Parameters, The parameter appears automatically.
The Solution
Put the parameter in your query. Then, open up the Report Parameters dialog box and create the Parameter there. Now open the properties for the data set and click on the Parameters tab.
This is where you can marry the 2 together. On the left side put your parameter from the query. On the right side you should see the report parameter. It should look like this:
:Parametername | Parameters!Parametername.Value
That's it.
I told you it was simple.
Keywords: Microsoft, MS, SQL Server, Reporting Services, SSRS, ORA-01008, Parameter
|
