July 4, 2011 at 9:44 am
I'm fairly new to SSRS, so far I've been creating reports just copy/pasting code from Management Studio directly into the query section of the Report Wizard, this works well.
Having all the code centralised via stored procedures makes a lot more sense in terms of maintaining the code and searching for changes in code.
I built a report via a stored procedure the other day but it was a most convoluted process, I essentially just created a report using a simple query then edited the query behind the data set and changed it to SP then put in the SP. Then I had to delete the existing columns, refresh the fields and pull the SPs fields in etc. All in it was quite a faf!
I tried t 'blank' report rather than a wizard but I didn't know where to start.
So, if you create reports and use SPs what's your workflow?
Thanks!
July 4, 2011 at 9:47 am
I build using the wizard and the base query.
Once the report is done-ish. I change the datasource to a sp.
I just hit refresh so that the "new" set of columns is "downloaded" from the server.
From there on out there's nothing left to change and I can just deploy the report.
And yes this is really annoying and no there's no other way I'm aware of.
July 4, 2011 at 9:51 am
Ahh so essentially use the query behind the stored procedure and then change code from query with text to SP? - Theoretically the columns should be the same too.
I typically just used a select * from a really small table with a couple of columns and only a few rows...
Hmm, I guess that's one way. Thanks!
July 4, 2011 at 10:02 am
Rob-350472 (7/4/2011)
Ahh so essentially use the query behind the stored procedure and then change code from query with text to SP? - Theoretically the columns should be the same too.I typically just used a select * from a really small table with a couple of columns and only a few rows...
Hmm, I guess that's one way. Thanks!
I've tried a lot of variations. That's the path of least resistance... even if annoying! 😉
July 4, 2011 at 10:13 am
Well, it's good that I'm not going mental, but it's a bit crap that that bodge is the best way to do it! - Gah!
Can't believe I have a Sams SSRS 2008 book here and it doesn't even have Stored Procedure in the index?!
July 4, 2011 at 10:18 am
Rob-350472 (7/4/2011)
Well, it's good that I'm not going mental, but it's a bit crap that that bodge is the best way to do it! - Gah!Can't believe I have a Sams SSRS 2008 book here and it doesn't even have Stored Procedure in the index?!
Maybe that says it all! :w00t:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply