March 27, 2009 at 1:57 pm
It has been many months since I've worked with SQL Server Reporting Services, and in looking around I cannot find what I'm trying to find, so I'm asking here. Please forgive what has to be a beginner's question.
I want to write a couple of .rdlc files which will use two stored procedures to present data to the user. I've created a new project in SSRS 2005, and have added my connection. Next I went to the Query Builder, and there I'm stuck. There appears to be no way at all of using a stored procedure in SSRS 2005's Query Builder. I've tried writing in the SP by hand, but when I go to run it SSRS complains.
So, how do I use a SP with SSRS 2005?
Kindest Regards, Rod Connect with me on LinkedIn.
March 30, 2009 at 10:35 pm
Hi,
Onces you have created the procedure in database, at report end in the Query Builder you just need to put the following:
EXEC YourProcedureName
Thanks,
Richa
March 31, 2009 at 7:26 am
When you create your dataset, you select Command Type - Stored Procedure. This will get the parameters for you and use the correct ADO.NET command type with parameters.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply