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 |
|
winDows
Starting Member
9 Posts |
 Posted - 2008-07-24 : 10:29:03
|
| Hi , could anybody explain or give a link how i can create a report by using stored procedures instead of sql statements . i know how to create report and procedure, but not working both together for me , could anyone please explain the steps. Thanks a lot. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-24 : 10:30:42
|
| There is text and SP in dataset. You can put your Stored proc name. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-24 : 10:50:37
|
quote:
Originally posted by sodeep
There is text and SP in dataset. You can put your Stored proc name.
you can even use text mode itself for sp. just give command asEXEC SPName param1value,param2value,.... |
|
|
|
shilpaa
Starting Member
6 Posts |
Posted - 2008-07-25 : 02:10:29
|
| Hello,In the Data Tab of Reporting services, Create a New Dataset. In that You have Command Type as 'Text' and 'Stored Procedure'. Then you can see the List of Stored Procedures in that Database which you are pointing. Select the Store Procedure and execute it. It asks for you to enter the parameters, (If have). Give the parameters, Then the Result of sproc is dislayed. Hope this helpsShilpa Reddy |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-25 : 11:04:57
|
quote:
Originally posted by shilpaa
Hello,In the Data Tab of Reporting services, Create a New Dataset. In that You have Command Type as 'Text' and 'Stored Procedure'. Then you can see the List of Stored Procedures in that Database which you are pointing. Select the Store Procedure and execute it. It asks for you to enter the parameters, (If have). Give the parameters, Then the Result of sproc is dislayed. Hope this helpsShilpa Reddy
which is rs version you're using? i havent seen the stored procedure dropdown in visual studio. are you using vs 2008? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-25 : 12:58:23
|
quote:
Originally posted by visakh16
quote:
Originally posted by shilpaa
Hello,In the Data Tab of Reporting services, Create a New Dataset. In that You have Command Type as 'Text' and 'Stored Procedure'. Then you can see the List of Stored Procedures in that Database which you are pointing. Select the Store Procedure and execute it. It asks for you to enter the parameters, (If have). Give the parameters, Then the Result of sproc is dislayed. Hope this helpsShilpa Reddy
which is rs version you're using? i havent seen the stored procedure dropdown in visual studio. are you using vs 2008?
She is right that's why i mentioned SP before. |
|
|
|
|
|
|
|
|
connect procedure to report