Using stored Procedure in SSRS

5 pts.
Tags:
SQL Server 2005
SQL Server stored procedures
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Fire up SQL Profiler and see if the stored procedure is actually being run against the SQL Server.
    66,200 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following