COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: avik1986 on 22 Jun 2017 02:17:48 AM

Title: Pie chart not getting exported to excel 2007
Post by: avik1986 on 22 Jun 2017 02:17:48 AM
I created a cognos report in cognos 10.2 where 1 pie chart is there. I modified the pdf setup.now it is working fine but not at all getting exported to excel. Please help
Title: Re: Pie chart not getting exported to excel 2007
Post by: avik1986 on 22 Jun 2017 02:18:51 AM
Please find screenshot herewith as earlier I had attached the xml of the report.
Title: Re: Pie chart not getting exported to excel 2007
Post by: MFGF on 22 Jun 2017 02:37:19 AM
Quote from: avik1986 on 22 Jun 2017 02:17:48 AM
I created a cognos report in cognos 10.2 where 1 pie chart is there. I modified the pdf setup.now it is working fine but not at all getting exported to excel. Please help

Hi,

What does "not all getting exported to excel" actually mean? What is missing? Can you give details?

Did you look at the limitations of excel exports in the Report Studio User Guide?

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_excel_limitations.html#excel_limitations

MF.
Title: Re: Pie chart not getting exported to excel 2007
Post by: avik1986 on 22 Jun 2017 02:38:37 AM
list is getting exported but graph is completely blank.
Title: Re: Pie chart not getting exported to excel 2007
Post by: MFGF on 22 Jun 2017 02:45:44 AM
Quote from: avik1986 on 22 Jun 2017 02:38:37 AM
list is getting exported but graph is completely blank.

Looks like you have multiple (plus nested) tables in your report. Take a look at the section in the docs I linked to above on Table and Column Widths. My guess is the bottom table is getting truncated in the process of merging all tables into one? What happens if the pie is in the same cell as the list?

MF.