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] "MissQti" <MissQti@discussions.microsoft.com> wrote in message
news:2F93E890-EB2E-4346-A9CF-6A8DA5E49AF3@microsoft.com...
> 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
> so...how do I pass the parameters? Help would much appreciate.