Merging 69 reports into single n having the same 4 querys in all reports

[krishnaneni]

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

[MFGF]

Is this Impromptu?  Cognos 8?

[krishnaneni]

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