SQL Server Report Parameter

0
votes

I'm create a SQL Server Report using Business Intelligence tool (visual studio shell 2005) for SQL Server 2008.

I'm calling a stored procedure with 2 parameters. I've tried - Report-> Report Parameter, Added two parameters name them Days and Count.

In the Data panel "command type:text"

exec dbo.DataReport @Days, @Count

error: Must delcare the scalar variable "@Days"

Does anyone know how do get this too work.

2
sqlsql-serverreporting-services

2 Answers

3
votes

Try changing the command type to Stored Procedure, i'm sure its worked for me in the past

2
votes

If changing the command type to Stored Procedure like was suggested didn't work, try opening the Dataset dialog box and going to "Parameters" tab. Make sure that both parameters ("@Days" and "@Count") are in the list and that each one has a value.