COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: krishnaneni on 02 Jun 2011 02:35:47 AM

Title: Merging 69 reports into single n having the same 4 querys in all reports
Post by: krishnaneni on 02 Jun 2011 02:35:47 AM
Hi Gurus,

I have a requirement...

We are having 69 reports with the same following features..

every report got  4 Querys with same data items

But filters are different in each query in single report and other all reports..

There are no prompts and varilables...
All 69 reports are running morethan 25 min....so becaue of this we want to merge all the reports in signle else some 4 reports in single....

Can any one tell me the easiest way with step by step process to merge the reports in single report...
there are no limits to do this.....

ThanKs In Advance!


Regards
Krish
Title: Re: Merging 69 reports into single n having the same 4 querys in all reports
Post by: MFGF on 02 Jun 2011 04:59:40 AM
Is this Impromptu?  Cognos 8?
Title: Re: Merging 69 reports into single n having the same 4 querys in all reports
Post by: krishnaneni on 02 Jun 2011 06:25:39 AM
Cognos 8.4

another request...

We want to show the all 4 queries in single Excel page with proper page break or anything to avoid the mixup of 4 queries...

instead of seeing 4 tabs in single excel sheet after running the report...

and can anyone help me out the with the query need in expression and in detail step by step...


Regards
Krish