COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Niels1982 on 30 Jan 2015 08:10:09 AM

Title: Repeating Pie Chart is not properly displayed in Excel
Post by: Niels1982 on 30 Jan 2015 08:10:09 AM
A report has been created with a repeating Pie Chart (based on dates).
I always need to show 3 dates (e.g. Jan-2015, Feb-2015 and Mar-2015) with information.

In HTML the report works pretty fine, but when I extract the report to Excel, the lay out got messed up and the repeating pie charts are visible below each other instead of next to each other. Now the repeating pie charts cover other tables and that is wrong.

How can this be fixed?
Title: Re: Repeating Pie Chart is not properly displayed in Excel
Post by: MFGF on 30 Jan 2015 09:18:32 AM
Quote from: Niels1982 on 30 Jan 2015 08:10:09 AM
A report has been created with a repeating Pie Chart (based on dates).
I always need to show 3 dates (e.g. Jan-2015, Feb-2015 and Mar-2015) with information.

In HTML the report works pretty fine, but when I extract the report to Excel, the lay out got messed up and the repeating pie charts are visible below each other instead of next to each other. Now the repeating pie charts cover other tables and that is wrong.

How can this be fixed?

How did you achieve the repeating of the pies? Are you using table cells? A value in the Categories(pies) field? A Repeater table? Something else?

I'd suspect you're doing something Excel doesn't support - which can be quite a long list! Take a look at Appendix E of the Report Studio User Guide:

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1.1/ug_cr_rptstd.pdf

MF.