Report parameter working with Stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Report parameter working with Stored procedure

Author

Topic

chinlax
Starting Member

30 Posts

Posted - 2011-11-24 : 23:24:57

Hi All,

I have created one stored procedure.

CREATE PROC usp_AddTwoInteger11 @FirstNumber int ,
@SecondNumber int, @Answer int OUTPUT as

Set @Answer = @FirstNumber + @SecondNumber

Return

and in the Report Designer
in the dataset properties i have selected stored procedure.
and in the 'Define Query Parameters'window
It has Parameter name as @FirstNumber, @SecondNumber, @Answer
What should i enter into the Parameter value

and the Report parameters are automatically created as Firstnumber,Second Number and Answer

The Preview i can see three Report parameter ,
If i enter values into those , its not giving me any output, its the same.....what should i need to do in order to get output

Is this is the correct approach.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-25 : 08:50:57

you can return parameter values within report like this. Just return it as a resultset and you will get the value

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources