COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: tarunkrdas2013 on 07 Dec 2015 01:59:32 PM

Title: No of records in Report based on Report Output selection
Post by: tarunkrdas2013 on 07 Dec 2015 01:59:32 PM
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
Title: Re: No of records in Report based on Report Output selection
Post by: tarunkrdas2013 on 07 Dec 2015 02:02:19 PM
Please note its a crosstab report
Title: Re: No of records in Report based on Report Output selection
Post by: MFGF on 14 Dec 2015 11:02:46 AM
Quote from: TKD on 07 Dec 2015 01:59:32 PM
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

Quote from: TKD on 07 Dec 2015 02:02:19 PM
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.