sql server reporting services: Problem with Stored Procedures and Preview Tab -- sql server reporting services

Re: Problem with Stored Procedures and Preview Tab

Bruce L-C [MVP]
9/7/2005 12:46:23 PM

sql server reporting services: RS normally automatically creates report parameters for you. You could add
the report parameter (call it FromDate, leave off the @ sign when creating
it. Match case). Then in dataset click on the ..., parameters tab and on map
each query parameter to the report parameter.

OR,

I bet you have done something like this:
exec mysp @FromDate, @ToDate

What you should do is click on the ..., change the command type from text to
store procedure and put in mysp, RS automatically detects your query
parameters and will create the report parameters automatically for you.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Problem with Stored Procedures and Preview Tab

C a r l o s - A n t o n i o
9/7/2005 1:36:08 PM

Hi ya'll

I've created a report based on SP with 2 DateTime parameters: @FromDate and
@ToDate. With the Basic Query Designer I created the dataset, set its name
to MyDataSet and the Command Type drop down is set to StoredProcedure.

If I test the DataSet, It works fine. The problem is when i try to preview
the report. Here's the error message:

An error has ocurred during report processing.
Query execution failed for dataset 'MyDataset'.
Procedure 'MyProcedure' expects parameter '@FromDate', which was not
supplied.

Any Help will be really appreciated.

Thanks,

Carlos Antonio