Post reply

Combine 9 SSRS reports into one report

  • July 25, 2016 at 1:32 pm

    #312017

    Hello,

    I am using SSRS - 2014 my IT manager challenge me to combine 9 reports into 1 report. In another words have the user just enter the dates of the report and press View Report all 9 reports will be printed. I am not sure how to go about it. Here is my idea:

    Create a SSRS report with date parameters not all reports will use the same date parameters, fortunately all of the reports have same parameter names. Add the nine reports as sub reports. Here is my concerns:

    •How would it print out? Do I have to size the sub reports?

    •Would the sub reports look good (I have some graphics on some reports)

    •Would all the 9 reports pick up the parameters from the main report?

    Anybody who had similar issues, please let me know and what approach you have created. I appreciate the help. Thank you in advance.

  • July 25, 2016 at 2:13 pm

    #1891922

    not all reports will use the same date parameters, fortunately all of the reports have same parameter names.

    First, can you clarify what you mean here?

    •Would all the 9 reports pick up the parameters from the main report?

    On the "parent" report you would have the users fill in the date parameters required for all the sub reports. In the parameter source for each sub report you would reference the appropriate parameter from the parent.

    Add the nine reports as sub reports. Here is my concerns:

    •How would it print out?

    Using the out-of-the-box SSRS functionality you can't print a report without user interaction. I'm sure there's some custom SSRS code or .NET code you can use to get it to print but I'm not the person to say how that would be done. I'm sure a simple google search could help you there.

    Do I have to size the sub reports?

    This is super easy to figure out by just playing around with the placement of your sub report - you just have to try and see for yourself.

    •Would the sub reports look good (I have some graphics on some reports)

    They wont look any different than when they are not sub reports unless you nest the sub report inside of another SSRS object like a text box or tablix (so don't do that).

    "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

  • July 25, 2016 at 3:37 pm

    #1891933

    Alan,

    Thanks for the tip I will give it a try.

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

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