August 2, 2012 at 1:37 am
When building the query for a reporting datasource how do you prefer to do it?
examples might be, a stored proceedure, a view in the database, a table valued function and the query directly in the datasource query editor
what are the benefits and disadvantages?
thanks in advance
August 3, 2012 at 6:15 am
We try to stick with stored procedures. All the logic is contained within the stored procedure, plus IMHO, it's much easier to edit the script in SSMS then in Reporting Services.
We also try to use Reporting Services for formatting only. We've had a few reports designed by consultants (before my time) where half the logic is in the stored procedure and half the logic is within the report. It makes it very difficult debug when we need to follow the source data completely through the calculations.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply