How to use a stored procedure with parameters to create the datasource view for report model bui

I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?

Please refer to the following post in this forum:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=533787&SiteID=1

Shyam

|||

Hi Troy and Shyam,

I looked at the post it simply says use OPENROWSET. But I dont know where I should use OPENROWSET in the Report Model Project to get my stored procedures as datasource views.

Can one of you please provide some direction on this or a simple example.

Appreciate your help guys!