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 |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2009-07-31 : 17:37:18
|
| I am really lost in this reporting services program. I have too many learning gaps and just go from one obstacle to the next instead of actually producing something. Any good, thorough tutorial ideas would be appreciated.Anyway, the most recent issue is that I created a stored procedure that has no parameters, just a simple output. I wanted to create a report from it and thought it would be easy, but I can't even figure out how to get the raw data out. I tried creating a new project, a new model, a new report, and finally I somehow got a stored porcedure behind a blank report. I don't even know how I did it and probably can't do it again at this point. Furthermore, though the query ran in the query grid, I just had a blank layout tab where I had to drop randomly every field, resulting only in a report that had only one line even though there are hundreds in the query grid.Can you point me to a way to build this. Once I learn, then I could build thers, too. I would like to know how to do it with parameters as well. Thank you for your time.Duane |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-08-01 : 06:26:12
|
| That's straight forward. In the data set change the command type from text to stored procedure. You can also define parameters in the parameter tab though you don't have any.Hope that helps. |
 |
|
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
Posted - 2009-08-03 : 08:59:43
|
| Thank you for your response - I actually did this. I just have that generic query designer open and I typed the name of the stored procedure in there. I don't see a place to select a stored procedure even though I have the command type set at "StoredProcedure". I did discover I can edit parameters, etc. if I click the edit dataset button.I am still getting only 1 line in the report itself, even though when I click the execute query button, I get them all. All I want is the data itself. I am going to ultimatedly export it to excel with column headers. I am pretty new at this so if someone can help me get this report done, it will help. Thanks again.Duane |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-03 : 09:55:02
|
| In the dataset, you can execute the SP to see what data is there.So first I would see if you are getting all the data you expect. |
|
|
|
|
|
|
|
|
How to create a report from a stored procedure