INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

Combine 9 SSRS reports into one report

Combine 9 SSRS reports into one report

(OP)
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.

RE: Combine 9 SSRS reports into one report

I don't know if you ever got this accomplished but I have done the same thing, 6 reports total, not 9 though.

I made a master report with the main header and footer of the report to be shared by all of report including the subreports. The header contains my companies dynamic logos and the selected clients logo (also dynamic). They all look clean although you might need someone or some tool to manipulate the logos/image sizing.

There are charts on all pages and they look good.

On the main page below the master report and above the report footer, I added a rectangle for each subreport - one of my rqmt was to each report had to have it's own page(s), so I conditionally set pagination for breaks on that and added page breaks in groups of each subreport.

All of my report parameters are named consistently and are passed as needed to the applicable subreport(s).

My reports prints cleanly, in the order requested and each page is a separate report.

Hope this helps.

RE: Combine 9 SSRS reports into one report

(OP)
Jacque,

That is what I did also, but I did not put rectangle in my report it comes out nice. I had to have the user be content without the subreports name. Thanks for taking the time in replying. At least I know I am not the only one doing that.

Cheers

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close