Microsoft Reporting Services - Error - Expects Parameter - Stored Procedure -- sql server reporting services

petejk NO[at]SPAM gmail.com
12/20/2005 4:27:33 PM

Solution:

This happens to me quite a bit...its because the designer removes the
code that defines what
values are passed to your stored procedure.

You have to select the report you're working on > Right-Click 'Code' >
Locate the <Query> XML tag...and you'll have to re-define the
<QueryParameters>.

<Query>
<DataSourceName>GPS</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>spLRGetLeadRotationSummary</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@RegionID">
<Value>=Parameters!RegionID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>

Bruce L-C [MVP]
12/21/2005 8:54:41 AM

You can also do this by clicking on the ..., parameters tab. Modifying the
xml is dangerous. Although if you have a lot of query parameters and RS
keeps losing it then I have sometimes saved the section off so I could copy
it back in.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

sql server reporting services : Microsoft Reporting Services - Error - Expects Parameter - Stored Procedure