Print Page - Multiple Reports output in single file

Title: Multiple Reports output in single file
Post by: cielo on 25 Jan 2019 11:29:41 AM

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

Title: Re: Multiple Reports output in single file
Post by: Cognos_Jan2017 on 25 Jan 2019 12:38:42 PM

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.

Title: Re: Multiple Reports output in single file
Post by: Lynn on 13 Feb 2019 02:39:33 PM

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

Title: Re: Multiple Reports output in single file
Post by: Boksberger on 16 Feb 2019 11:57:17 AM

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.

Title: Re: Multiple Reports output in single file
Post by: cielo on 25 Feb 2019 11:39:45 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cielo on 25 Jan 2019 11:29:41 AM