Creating a report from a Stored Procedure

Hi

I'm not sure if this is possible, i want to create a report from a stored procedure, all the stored procedure does is select data from my database, however, the code is 1800+ lines of code, it executes in about 1 minute, which is fine. My problem is that i can't paste 1800+ lines of code into the dataset in Reporting Services, so is it possible to get the values from my stored procedure into reporting services so that i can use them to design and execute my report?

Or musst i find an alternative way to do this?

Any help or suggestions will be greatly appreaciated and welcome.

Thanks in advance

Kind Regards

Carel Greaves

If you have a data source pinting to your database, go to Visual Studio and create a dataset for your rdl and in the Query String type exec SProc_Name @.Param1, @.Param2 .. etc. Make sure the command type is text.

That should do it.
|||

Thanks, strangely enough it was on text, and i set it to stored procedure, and then changed it back, now it works.

Thanks Gatharia