Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

support for stored procedures in report builder 1.0 Expand / Collapse
Author
Message
Posted Tuesday, August 3, 2010 2:11 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 2, 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
Posted Monday, January 17, 2011 5:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse