Report studio output in excel in cognos 10

[skdeep9]

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

[skdeep9]

can anybody will help me on this ?

Thanks in advance

[blom0344]

Setting 'rows per page' property to an explicit high number should give the crosstab on one sheet, I reckon?