Combining Report Pages between two Cognos Reports (Relational)

[HelloCognos]

Hi, :) :)

We have two reports that we need to combine. The easiest seems to be taking one Page at a time from one report and pasting it to the other Report. Unfortunately, some of the Queries and/or Query.Items are missing. So when I copy and paste from Report 1 to Report 2, of course, I get errors of the Query or Query.Item not found.

I'm hoping that we don't need to develop the same functionality from Report 1 to Report 2 but if we can't copy/paste the pages, we may have the redevelop.

I have whole bunch of ideas but I wanted to open a question to see if anyone has any ideas that I haven't think of?

Thanks for your time in advance!! Cheers!!

[Lynn]

Hi, :) :)

We have two reports that we need to combine. The easiest seems to be taking one Page at a time from one report and pasting it to the other Report. Unfortunately, some of the Queries and/or Query.Items are missing. So when I copy and paste from Report 1 to Report 2, of course, I get errors of the Query or Query.Item not found.

I'm hoping that we don't need to develop the same functionality from Report 1 to Report 2 but if we can't copy/paste the pages, we may have the redevelop.

I have whole bunch of ideas but I wanted to open a question to see if anyone has any ideas that I haven't think of?

Thanks for your time in advance!! Cheers!!

There is report booklet functionality that lets you create a single output from multiple reports:
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

If you want to create a single report specification then you should copy the queries from report 1 into report 2, and then copy the pages. This will avoid the errors you are describing. You'd need to ensure the queries are distinctly named before you do this though. For example, Report 1 has Query1 and Report 2 also has Query1. Change the query name in Report 1, then copy it into Report 2 followed by the page.

[HelloCognos]

Interesting thought Lynn, :) :)
This report has 200 some queries but I may try wiping them all out from report 2 AND copy/paste all from report 1 to report 2. Not sure what occurs but I have multiple copies and even working on my folder.

I'll check the link as well!!

Thanks a lot!

[bdbits]

Just a thought, but 200 queries? Ummm... ok, maybe it is justifiable, but I would take a pretty hard look at why there are so many queries. It could be a deficient data warehouse design or perhaps the report author was not familiar enough with how to build queries for a report. A rebuild might be a better option.

[cognostechie]

other way[/quote]

Absolutely correct ! Exactly what I was going to say !

By the way, another way of copying one report to another is to save the report with a different name and start deleting/modifying the pages/queries of the new report to achieve what you want in the 2nd report.