Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing a report from SQL Server
Message
From
16/07/2014 10:56:29
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01603727
Message ID:
01603810
Views:
39
>I see - from your note - that will need to learn how to create datasets. And since most of the stuff I do is in stored procedures, I will have to learn how to do in in Stored Procedure.
>
>Thank you.

Well, it's actually quite easy. If you have a stored proc that is bringing back the result set you want....and you just want the SSRS report to bind to it. it's quite easy.

In a nutshell

- you define a new dataset in the SSRS report
- you can tell it whether you want it to be a query or a proc....if you choose proc, you get a dropdown and can pick the proc name
- that will populate the dataset definition with the columns from the report.

So it's pretty straightforward.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform