Rows Per Page - different setting for HTML and Excel/PDF

[AM]

Hello,
I've written some reports where I only want to show the first 500 rows when it is rendered in HTML, but show all rows when it is exported to Excel or PDF.

I have implemented this using conditional blocks

if    (reportoutput() = 'HTML')
then    ('HTML')
else   ('Non HTML')

I placed the same list into both 'HTML' and 'Non HTML' conditions, with the 'Rows Per Page' property to be 500 for 'HTML' and blank for 'Non HTML'.

This works, however it is not great as there is a maintenance and testing overhead - every time a change is made to the list it needs to be implemented and tested twice!

If someone can suggest a slicker way to implement this that would be great.

Thanks,
AM