If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Page set plus assign page to query plus chart

Started by Mpotla, 07 Jun 2009 02:40:03 PM

Previous topic - Next topic

Mpotla

HI All,

I'm using Cognos 8.1

   I have a report which has three parts:
i table is inserted and data items from query1 are dropped in the cells (query1 is assigned to page)
i have a list report with query2  in the same page

I have a page set defined on one data item (engine number) from query1. Also i have defined a master-detailed relationship (on engine number) between query1 and query2 (table and list queires).

So far when i run the report and select multiple engine numbers, i get properly data in table and list report and page break by engine number.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Now i have also to add a combination chart in the same page with query3.
Note: I cannot have same queries for table, list and cahrt, they are differnet queries and somewhat complex.

I did a master detail relationship to table query1 and query3. Now when i run the report everything is fine but chart is blank.

I took the same chart query in a new report and it renders fine :-(. but not able to do the same in the main report.

Any inupts please pour in ....................

Thanks in Advance,
Mohan