support for stored procedures in report builder 1.0

• cpinky01

  Ten Centuries

  Points: 1084

  More actions

  August 3, 2010 at 2:11 pm

  #238433

  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

• Alejandro Alberini

  Valued Member

  Points: 60

  More actions

  January 17, 2011 at 5:36 am

  #1274202

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

  thanks.