support for stored procedures in report builder 1.0

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » support for stored procedures in report...

support for stored procedures in report builder 1.0

Rate Topic

Display Mode

Topic Options

Author

Message

cpinky01

Posted Tuesday, August 03, 2010 2:11 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, January 02, 2013 6:36 PM
Points: 52, Visits: 120

Hi,
I have created many stored procedures in sql. now i need to create report models in report builder 1.0. i am confused whether it supports stored procedures or not. i hae used rowset fuunctioality to make use of stored proc. but is not working.

SELECT *
FROM OPENROWSET('SQLOLEDB', 'server=gtlsqltst;Trusted_Connection=yes',
'EXECUTE dbo.usp_rpt_paidDetails') AS a
it is urgent. can any one say how to use stored procedures in report builder 1.0.
I know in 2.0 it works.
Thnaks you
Pinky

Post #963110

Alejandro Alberini

Posted Monday, January 17, 2011 5:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 23, 2011 11:42 AM
Points: 4, Visits: 14

Hi. Anybody respond your question? I have the same problem and I can't find a solution.

thanks.

Post #1048705

« Prev Topic | Next Topic »

Permissions