Calling Stored Procedures in Report Studio

[vsudaya]

Hi,

How can i call a stored procedure(take a example, i have created stored procedure for employee no,name,job,sal etc). how can i map it my list, or any object in report studio.

thanks in advance
vsudaya

[MFGF]

Hi vsudaya,

You would need to set this up in Framework Manager, not directly from Report Studio.Ã,  In Framework Manager you can add a Stored Procedure Query Subject to call the stored procedure, add any required relationships between this and other query subjects, then include this query subject as part of the package before you publish it.

In Report Studio (or Query Studio for that matter) any items returned by the stored procedure (employee no, name, job, sal etc) will be available within the query subject - just drag them into your list.

Hope that helps,

MF.