COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: skdeep9 on 28 Sep 2011 06:35:35 PM

Title: Report studio output in excel in cognos 10
Post by: skdeep9 on 28 Sep 2011 06:35:35 PM
I am getting problem to get the output of a dashboard in excel. The dashboard contains a gauge chart and a bar chart , below has a crosstab.

Outpurt is drill through to The excel and PDF.So that the user can select on HTML output whther they want excel or PDF output

1) Because of gauge chart , the crosstab output gets distorted.It does not look good.Can anyone help me on this.
2) Also the HTML output is 50 rows per page, but can we make excel output in one excel worksheet instead of many sheets , each containing 50 rows per sheet
Title: Re: Report studio output in excel in cognos 10
Post by: skdeep9 on 29 Sep 2011 02:30:49 PM
can anybody will help me on this ?

Thanks in advance
Title: Re: Report studio output in excel in cognos 10
Post by: blom0344 on 05 Oct 2011 08:43:18 AM
Setting 'rows per page' property to an explicit high number should give the crosstab on one sheet, I reckon?