Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 822
  • Last Modified:

Merging 2 SSRS reports

hi

I have 2 SSRS reports , which i want to combine in one report , and generate one output , I know i can do that , by calling each of them as SubReport in one SSRS Report , but if i do that , it will hide the header of the reports , and it will be totally wrong.
0
BeyondBGCM
Asked:
BeyondBGCM
  • 3
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
Headers and footers are indeed ignored when using subreports.  The reasoning behind that is that the header/footer of the main report is rendered and there can be only one header/footer.  So you'd have to recreate the header in the main report for it to be rendered in combination with the subreports.

If the above won't work for your case then only on option remains: create a new report that contains the content of both reports.  You'll have to ensure that the same datasets exist, that's a manual step.  Once you've got that, you can copy/paste most of the stuff.  A tablix for instance can be moved to another report by using copy/paste.  The only requirement for this to work is to have the same dataset (with the same name) as in the old report.

Let me know if you have any question about this.
0
 
BeyondBGCMAuthor Commented:
some how , this is not very clear to me , with above message, can you please elaborate little more.
0
 
ValentinoVBI ConsultantCommented:
Please explain what part is not clear...

The main message is: you cannot use headers or footers in subreports, they will not be rendered.
0
 
BeyondBGCMAuthor Commented:
If the above won't work for your case then only on option remains: create a new report that contains the content of both reports.  You'll have to ensure that the same datasets exist, that's a manual step.  Once you've got that, you can copy/paste most of the stuff.  A tablix for instance can be moved to another report by using copy/paste.  The only requirement for this to work is to have the same dataset (with the same name) as in the old report.

do you mean , that we should use , 2 tablix for one report, and both will contain different data....?
0
 
ValentinoVBI ConsultantCommented:
Well, indeed!  A report can have several different data sources, datasets and tablixes.  So you don't necessarily need to split that up into different subreports.  Subreports have the advantage that they can be used in more than one report though...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now