Report Model and Stored Procedures

Hi Guys,
I have been searching all the newsgroups, MSDN forums and every
possible place to find a solution for this problem.
I want to use the stored procedures in the database to create my
Report Model (Ad-Hoc model) for Report Builder. I am talking about
Report Builder and NOT "Report Designer", I very well know how to
grab stored procs inside Report Designer to build a report.
One MSDN forum post suggests using the OPENROWSET command to grab the
stored procs but I dont know where to do this inside BIDS when I am in
the "Report Model" project.
Did anyone try this before.
We have a week left before we go to the implementation phase, so we
are kinda desperate to get this solution.You can use openrowset in "Named Query" click on the empty space on the DSV
and select new named query which is some what your query builder there you
can give a select with openrowset.
Amarnath, MCTS
"sqlhiker" wrote:
> Hi Guys,
> I have been searching all the newsgroups, MSDN forums and every
> possible place to find a solution for this problem.
> I want to use the stored procedures in the database to create my
> Report Model (Ad-Hoc model) for Report Builder. I am talking about
> Report Builder and NOT "Report Designer", I very well know how to
> grab stored procs inside Report Designer to build a report.
> One MSDN forum post suggests using the OPENROWSET command to grab the
> stored procs but I dont know where to do this inside BIDS when I am in
> the "Report Model" project.
> Did anyone try this before.
> We have a week left before we go to the implementation phase, so we
> are kinda desperate to get this solution.
>