Passing Stored procedure to dataset in ssrs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Carolyn Richardson » Passing Stored procedure to dataset in ssrs

Passing Stored procedure to dataset in ssrs

Rate Topic

Display Mode

Topic Options

Author

Message

saurabhnil

Posted Friday, August 01, 2008 1:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 18, 2010 5:25 AM
Points: 5, Visits: 46

Hi all

I have created a SSRS report and defined dataset for the same. In this one can give stored procedure name or query for that dataset.

I want to pass stored procedure name to a data set in SSRS through .NET code

- Anyone has any solutiong for this ?

Post #544889

saurabhnil

Posted Tuesday, September 02, 2008 7:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 18, 2010 5:25 AM
Points: 5, Visits: 46

Solution for this problem I was thinking will be so different. But its just the common way.

Instead of giving stored procedures name - i have given

"= Parameters!Stored_Proc_Name.Value"

So one can pass stored procedure name as a parameter.

This is working for me.

Post #562366

« Prev Topic | Next Topic »

Permissions