Groups | Blog | Home
all groups > sql server reporting services > may 2005 >

sql server reporting services : Expect Parameters which was not supplied when hit the preview tab



MissQti
5/18/2005 12:30:01 PM
I'm creating my reports and connect to the stored procedure. The results of
data returned when I'm on Data Tab. However when I hit the Preview Tab I got
the error said "An error has occured during report processing. Query
execution failed for data set "TheNameOfMyData". Procedure
"MyWebProcedureName" expect parameters "@Blah_1" which was not supplied".

What was wrong with the errors? Do I have to pass the parameters. If
MissQti
5/18/2005 1:59:04 PM
BIG THANKS to Bruce for the help. It worked when I mapped the report
parameter to query parameters.


[quoted text, click to view]
Bruce L-C [MVP]
5/18/2005 3:04:44 PM
One of two things has happened. Either you do not have report parameters or
you have report parameters and the query parameters are not mapped to the
report parameter. Usually, but not always, RS creates the report parameter
automatically for you.

In the data tab click on the ..., go to parameters tab. It should like all
your query parameters and what report parameter it maps to. If empty then go
to layout, click somewhere on blank part of the report. go to the menu
report->parameters. You need to have a report parameter per query parameter
(or rather you should have the report parameters you want to map to the
query parameters to be listed). If not there then add them. Then go back to
the data tab, click on the ... and map the query parameters to the report
parameters.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button