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.
SQL Server 2005
June 1, 2010 8:24 PM
June 3, 2010 8:31 AM