Post reply

Reporting source which way do you prefer it

  • August 2, 2012 at 1:37 am

    #264562

    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

    #1521334

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply