Many reports connected to one main report

[cognosmanager]

Hi All,

I have 2 reports named A and B, which have many data items along with two date prompts. In each report there is different condition. For eg in report A condition is [Retirement Date] between ?Start Date? and ?End Date? and in report B condition is [Status date] between ?Start Date? and ?End Date?. I have two columns for which total has been done in each of the reports. Column x is in report A and column Y is in report B. The requirement is that I need each of the totals from both the reports into third report C i.e. if total of x column is 102 and for y is 104 after running respective reports then it should appear in the main report. Please help me out with this.

[wyconian]

Hi

I don't think you can do this by somehow joining the reports together.  You can create views off a master report but only off one report.

Instead of having 3 reports (report a, report b and the new report) you could try having mulitple pages in a single report. That way you could have the queries for your report A used to generate page A, the queries for report B used to generate page B then pass the values you need for the calculation to another page.  You can use page render variables and prompts to allow the users to choose which pages they want to see.

Good luck