limit data to top X in html while not splitting data in multiple sheets in excel

[kiran.timsina]

If I set row limit to 20 and if I have 100 rows of data, html output shows 20 rows of data in 5 pages and excel outputs breaks into 5 sheets with each sheet having 20 rows. My requirement is to show only 20 in html while show all 100 in the same sheet in excel. How can I limit my data to top X in html while not splitting data in multiple sheets in excel (Cognos 10.1.1 Report Studio)?

[adik]

By default HTML output is set to 20 row, if you do not specify any value then in HTML you will have 20 rows while in excel all rows will show on 1 page

[kiran.timsina]

What if 20 has to be set to something else? Is there an easy way? If not, I'll go for 20.

[adik]

the moment you set any value in rows per page (i think this is the property name) it will split in excel as well
if you leave that property to a blank value if will default in html to 20 and in excel to maximum
you could achieve what you want in a different way
duplicate the report page, this way you will have the report twice on two pages
make a boolean variable like ReportOutput() = 'HTML'
set the render variable of one report page to yes for this variable and no to the other page
this way when you run the report in html you render one report page and set as many rows per page as you want and when you run in any other format the other report page will render where you will have a blank rows per page property

[kiran.timsina]

I too thought of the idea but as I already have 53 report views for just 4 reports (parent+child), I'll stick to leaving the row limit property to blank.