Is using Report Output () function hampers the performance

[xyz]

Hi All,

I am using Cognos 10.2 and database is oracle and DMR model. We have a requirement to display 100 rows, when the report is run in HTML. When the same report is exported to excel, 10000 rows has to be exported to excel. To achieve this, I have used Report Output () function by creating the string variable condition like below.

Case
When (ReportOutput () in ('HTML'))
then ('HTML')
When (ReportOutput () in ('spreadsheetML', 'xlsxData', 'XLWA'))
then ('Excel')
End

Created two copies of crosstab report for one crosstab set Rows Per Page property to 100 and to other crosstab set the Row Per Page property to 10000 and rendering them based on the report output selected. The difference I am finding here is report is taking 20 to 30 seconds extra to render the prompt page itself. But, if I don't use this concept and render the normal report without using Report Output () function. Report prompt page is coming up in 20 seconds.

Can someone please let me know your suggestions/guidance, I am doing anything wrong here or does the usage of Report Output () function only generally consumes extra time?

Thanks in advance.

Thanks & Regards,
XYZ