CODEWITHSUNDEEP
sqlsql-serverreporting-services
Nickz
Nickz

Reputation: 1880

SQL Server Report Parameter

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.

Upvotes: 0

Views: 331

Answers (2)

Dan R
Dan R

Reputation: 88

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.

Upvotes: 2

beakersoft
beakersoft

Reputation: 2356

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

Upvotes: 3

Related Questions