Home > IT Answers > SQL Server > Using stored Procedure in SSRS
Rohitd23
5 pts.
 Using stored Procedure in SSRS
SQL Server 2005, SQL Server Stored Procedure Migration, SSRS, Stored Procedures
Hi....

I am trying to create a Report using Report wizard in MSSRS 2005, I am trying to use Stored Procedure.

The steps which I am following are below....

Solution Explorer--> Add New Report--> Next(as DB is already shared one)--> Query Builder (But when going into query builder the command text is disabled and I am unable to select strode procedure there).

The second way I am trying is just adding a report and then in Dataset I am selecting new dataset then a small pop up is coming where i am giving the name of my data set, name of the data source, command string as Stored Procedure, In query string i am giving the name of my stored procedure, once i am clicking ok, I am getting a grid view with a message as Using stored procedure with my SP name. But when i am executing this using the exclamation mark no data is coming and i am not able to design my report as the field are not visible.

Request you to please help me out in this... I am un able to figure this out since long.



Software/Hardware used:
SQL Server 2005
ASKED: June 1, 2010  8:24 PM
UPDATED: June 3, 2010  8:31 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Fire up SQL Profiler and see if the stored procedure is actually being run against the SQL Server.

Denny Cherry
 64,505 pts.