Home Forums SQL Server 2008 SQL Server Newbies SSRS report and multiple datasets RE: SSRS report and multiple datasets

  • January 24, 2014 at 2:55 pm

    #1683278

    jignesh209 (1/24/2014)

    SSRS is not blocking,but is it a good practice to create 6 different Datasets and tying it up with 6 different stored procedures.

    There is nothing wrong with that at all; this is the standard practice. I have had a few jobs that included writing SSRS reports and it is not uncommon to see multiple datasets each with their own stored procedure.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001