Link to home
Start Free TrialLog in
Avatar of TSG954
TSG954Flag for United States of America

asked on

SSRS combine multiple reports for rendering

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,
ASKER CERTIFIED SOLUTION
Avatar of Howard Cantrell
Howard Cantrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TSG954

ASKER

How would a sub report work? Would it matter that the reports have nothing to do with each other. Please explain..
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.
Avatar of TSG954

ASKER

Will this work if i'm tyring to render via Excel format thru email?
I have not tried that myself.
Avatar of TSG954

ASKER

Do you know of a good, to the point example of a subreport?
Avatar of TSG954

ASKER

Or is there a way to simply attach 4 different reports thru subscriptions? witin the same email?
I think you can thru subscriptions, but I have not worked with subscriptions or SSIS.
Avatar of TSG954

ASKER

There is no way to add multiple reports thru the subscriptions, they also suggest the subreport.
Thanks for your help!