Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting source which way do you prefer it Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 1:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 6:36 AM
Points: 286, Visits: 572
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
Post #1338983
Posted Friday, August 3, 2012 6:15 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 10:56 AM
Points: 760, Visits: 2,211
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.




The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.
Post #1339761
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse