Setting up two different limits based on output type

[raghurambo]

The user will generate the report first in HTML followed by Excel if required. The HTML needs to cap at 1000 rows and the Excel to 200K rows. Gurus, please advise.

[MDXpressor]

Sounds like a conditional block for this.

• Set a boolean condition to:   ReportOutput() = 'HTML'
• Place a conditional block on your page
• Select the conditional block & set Block Variable property to your Boolean expression
• Just below that property set the current block to 'Yes' or 'True' (cant remember which one it shows for a Boolean).
• Copy your list container into the block
• Set the rows per page to 1000
• Set your current block to 'No' or 'False'
• Copy your list container into the block
• Set the rows per page to 200000

Voila 2 different outputs, one for HTML, one for Excel (& every other output type).