COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: siemenkarts on 20 Nov 2012 03:28:44 AM

Title: VERY EMERGENCY
Post by: siemenkarts on 20 Nov 2012 03:28:44 AM
Dear Friends

I have TWO reports. A and B.. both belong to same Package.

Now Report C is created.. which is A and B. C=A+B

Now I want to combine them both

So that in the end.. I must get 2 pdfs as output from that C report.

Contents of Report A must come to PDF 1 and contents of REPORT B must come in PDF 2

Is it possible..?

One more

Is it possible to bring them in a single output.

That is PDF page no.1-5(REPORT A) and page no.6-10 (REPORT B)

How to achieve this....

Dead line is nearing.... please help
Title: Re: VERY EMERGENCY
Post by: blom0344 on 20 Nov 2012 04:01:10 AM
Combine the report pages, queries etc and build a new common prompt page to service the combined report. This is all standard stuff.. and a matter of copying elements in the right order:

1. use unique query names.
2. copy queries to new report
3. copy report pages
4. copy variables
Title: Re: VERY EMERGENCY
Post by: pricter on 20 Nov 2012 04:10:58 AM
If you want just to send by email the two reports you can create a task to event studio.

Title: Re: VERY EMERGENCY
Post by: RubenvdLinden on 28 Nov 2012 06:46:45 AM
In report C, create a multiselect valueprompt called 'rpt' with static values A and B.

Next, create boolean variables for both section A and section B:

RenderA:
ParamValue('rpt') contains 'A'

RenderB:
ParamValue('rpt') contains 'B'

Select the page which contains section A and assign 'RenderA' as a Render variable.
Select the page which contains section B and assign 'RenderB' as a Render variable.

If you run this report, you can specify if you want section A, section B or both.