Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pjnovak007
Starting Member
19 Posts |
 Posted - 2010-06-29 : 12:44:13
|
| Does anyone know of a good online article on how to call a stored procedure from a sql database and be able to use the data in report services. I can get the data and run it but i cant create the report. Basically i am attached to the data but cant do anything with it.Patrick |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-06-29 : 16:51:14
|
| Patrick,you have to do two things in Stored procedure in order for report services to be able to read your stored procedure.1. define in your dataset (within report) that your data is not in form of text but in form of stored procedure2. prepare your t-sql stored procedure that at the end, your procedure returns data with a simple select.Reporting service is not a stranger to get data from stored procedure. your procedure must have this defined. |
 |
|
|
|
|
|
Reporting Server and calling a SQL stored procedur