Expect Parameters which was not supplied when hit the preview tab

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.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
"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.|||BIG THANKS to Bruce for the help. It worked when I mapped the report
parameter to query parameters.
"Bruce L-C [MVP]" wrote:
> 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
> "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.
>
>