Solved

Merging 2 SSRS reports

Posted on 2014-03-06
6
671 Views
Last Modified: 2014-04-03
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
Comment
Question by:BeyondBGCM
  • 3
  • 2
6 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39911699
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
 

Author Comment

by:BeyondBGCM
ID: 39941530
some how , this is not very clear to me , with above message, can you please elaborate little more.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39941597
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
 

Author Comment

by:BeyondBGCM
ID: 39944807
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
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39952739
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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now