want sp output parameter to be displayed

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 2005 Forums

Analysis Server and Reporting Services (2005)

want sp output parameter to be displayed

Author

Topic

Babli
Yak Posting Veteran

53 Posts

Posted - 2007-10-04 : 09:05:02

Hi,
I have a sp like this:

Create PROCEDURE sp_child2 @inp int, @out int output
AS
SELECT @out = @inp * 10
GO

In the report screen i want the following:

A text box which will take the @inp(this will come automatically)
When i click the "view report" the output value should be displayed in the textbox i have in the report.

But the problem i am facing is with the above sp is its creating two text boxes automatically asking for @inp and @out.If i dont give anything in @out text box and press the view report an error is thrown asing me to fill the output box.

Isnt it supposed to be a output value?Am i doing something wrong?

please help...

tm
Posting Yak Master

160 Posts

Posted - 2007-10-18 : 16:56:03

You can try ..

Create PROCEDURE sp_SSRS @inp int
AS
SELECT @inp * 10
GO

This will return @inp * 10 as a column and you can display in the body of the report. Not sure if you can display at top with the input though.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources