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.
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.