Hi,
I need to make a summary sheet based on a detail report:
The detail report is generated by two different stored procedures:
for eg: detail report is giving two figures A and B
in summary sheet i have to show figure C which is the sum of A and B (C=A+B)
how can i accomplish this in COGNOS 8.2 version.
Is there a way to store the values in COGNOS to use later?
The way to do that is to make sure the filters in C are equivalent of A+B. Basically, make a copy of the detailed query, apply the totals, then hide everything else except the totals.
Without looking at your detailed queries and layout, I can only give you a guideline, not exact steps.