Multiple Reports output in single file

[cielo]

I have 7 existing individual reports with multiple sections (List, Crosstab, etc.) because they belong to the same category and are intended for the same audience. User is expecting all the reports information in on file(probably excel)..
What is the best way to address this requirement? Dashboard/Hyperlink/Cubes? Please assist me.Ty

[Cognos_Jan2017]

Relational?

Data source(s) one Package, multiple Packages, Data Module?

We "combine" Reports into one Report w/ multiple Pages.  Can also
stack Reports on one Page.

[Lynn]

Try using report references to create a report booklet.

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/t_rpt_studio_create_rpt_booklet.html

[Boksberger]

You can migrate the reports into a single report, each with a separate page and set the Page to Excel tab property for the report to yes.

[cielo]

Thank you for your inputs. I have used Page reference option everything is fine though I have some simple issues
1) Table of contents starting from No.2 instead No.1
2)Prompt (common prompt for all reports) is consuming time to load

Please share your inputs