No of records in Report based on Report Output selection

[tarunkrdas2013]

I have a Report requirement where in when user select HTML report i should be able to display 10,000 rows and when user selects report output as excel
report should display 65000 records in excel,how can i achieve that,please let me know

[tarunkrdas2013]

Please note its a crosstab report

[MFGF]

I have a Report requirement where in when user select HTML report i should be able to display 10,000 rows and when user selects report output as excel
report should display 65000 records in excel,how can i achieve that,please let me know

Please note its a crosstab report

Why? What possible use is a 10,000 row or a 65,000 row crosstab? Who is going to look at it and be able to deduce anything remotely useful? It's not a report, it's a data dump. If you want to dump data out for use in other analysis tools, use the right tool for the job, which in this case would be an ETL tool.

Otherwise, look deeper into the requirement and deliver the final summarised analysis in Cognos rather than another tool.

MF.