?
Solved

SSRS combine multiple reports for rendering

Posted on 2011-05-06
9
Medium Priority
?
1,391 Views
Last Modified: 2012-05-11
Is there anything in SSRS 2008 that will help in combining multiple reports into one file when rendered via email subscription? If so, how would you do this?
thanks,
0
Comment
Question by:TSG954
  • 5
  • 4
9 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 2000 total points
ID: 35708753
have you tried adding them as sub-reports?
0
 

Author Comment

by:TSG954
ID: 35708772
How would a sub report work? Would it matter that the reports have nothing to do with each other. Please explain..
0
 
LVL 27

Expert Comment

by:planocz
ID: 35710054
Yes a sub report is just a standlone report just like your main report is.
But when you add a subreport to the bottom of your main report it will just print right along with the main report. You can set conditions on when to hide or see and print.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:TSG954
ID: 35719881
Will this work if i'm tyring to render via Excel format thru email?
0
 
LVL 27

Expert Comment

by:planocz
ID: 35720099
I have not tried that myself.
0
 

Author Comment

by:TSG954
ID: 35720152
Do you know of a good, to the point example of a subreport?
0
 

Author Comment

by:TSG954
ID: 35721190
Or is there a way to simply attach 4 different reports thru subscriptions? witin the same email?
0
 
LVL 27

Expert Comment

by:planocz
ID: 35721512
I think you can thru subscriptions, but I have not worked with subscriptions or SSIS.
0
 

Author Comment

by:TSG954
ID: 35748656
There is no way to add multiple reports thru the subscriptions, they also suggest the subreport.
Thanks for your help!
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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