Multiple report generation in single report

[kambekar]

I am working on Cognos impromptu 6 administrator edition
Following is the scenario for which I have to build a report.
1. Get data directly from the Oracle table and display whole data in a 'summary report'
2. Check for data in Summary Report/table for value of particular column
3. If column value 'A' is available then Print 'Report A'
4. If column value 'B' is available then Print 'Report B'
5. If column value 'A' and 'B' both available then Print 'Report C'
6. If column value is 'D' then ONLY print 'Report D'
7. All this should be dynamic. User will run only one report/macro for this.
8. Report will be run on the Web Reports

How can I achieve this? Do I need to have impromptu client on each user's machine

Any suggestions/ideas

 

[CognosProfessional]

1. Create Catalog using Impromptu Admin
2. Create Report with all table data
3. Research "Query" Dialog box and apply your filters there.
4. Research results until you see your reports as needed.
5. Dynamic? - Publish report to IWR, and set up schedule for auto-run times.
6. No, do not need impromptu client oneach user's machine. Users will access IWR reports you have created on the web.

7. Read Impromptu Documentation.

Good LUck,
CP

CP

 

[griffindm]

kambekar,

You can do this in a macro using the GetDataValue function. While the first summary report is open, use this function to return the contents of columns 'A', 'B', and 'D'. Within the macro run the additional report appropriate for each condition based on the values returned.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com

 

[kambekar]

Can I have a report footer in impromptu?