Cognos report spreading across mulitple tab sheets when exported into Excel

[mp3909]

Hi,

Cognos Report Studio version 11.

I have report with just tab
In this report I have just one table.
When I get to the 100th record in the table, I have to click page down to see next record in the table when viewing report in HTML.
And when I export report into Excel 2010, the report gets split across 7 different tab sheets.
Ideally, want the report to be shown in just one tab sheet.
The total number of records in the table is 679.
It seems like each tab sheet in excel is just containing maximum 100 records in the table before it gets split into another tab sheet.

Is there a way I can display all records in a single tab?

Thank You.

[MFGF]

Hi,

Cognos Report Studio version 11.

I have report with just tab
In this report I have just one table.
When I get to the 100th record in the table, I have to click page down to see next record in the table when viewing report in HTML.
And when I export report into Excel 2010, the report gets split across 7 different tab sheets.
Ideally, want the report to be shown in just one tab sheet.
The total number of records in the table is 679.
It seems like each tab sheet in excel is just containing maximum 100 records in the table before it gets split into another tab sheet.

Is there a way I can display all records in a single tab?

Thank You.

Hi,

Have you looked at the Pagination property in the Properties pane for your List? How is it set currently? Maybe turn off page breaking and horizontal pagination? You could also try setting the Rows per Page property to something higher than 679?

Cheers!

MF.

[mp3909]

thank you, that worked