COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: asmfloyd on 27 Nov 2018 08:57:37 AM

Title: Using page break while bursting csv files
Post by: asmfloyd on 27 Nov 2018 08:57:37 AM
Hello Gurus,
  I am bursting a report (PDF & CSV) which will generate details of all funds(fund_id) for a bank (bank_id). My burst key is based on bank_id. It is working well.

Now for each bank report, I need to keep a pagebreak by fund_id. When I keep pagebreak, the pdf is coming correctly with pagebreak. But csv is creating separate report files for each fund_id.

How can I fix the csv report so that it generates all funds in one bank file?

Thanks,
Title: Re: Using page break while bursting csv files
Post by: asmfloyd on 28 Nov 2018 01:20:19 PM
I think it looks to be like a formatting limitation for csv files as they were not intended to format that way. I tried generating as excel (with page break) and it looks to be generating as separate sheets within a workbook.
Title: Re: Using page break while bursting csv files
Post by: MFGF on 29 Nov 2018 03:11:11 AM
Quote from: asmfloyd on 28 Nov 2018 01:20:19 PM
I think it looks to be like a formatting limitation for csv files as they were not intended to format that way. I tried generating as excel (with page break) and it looks to be generating as separate sheets within a workbook.

Hi,

The CSV rendering option is designed to deliver only data, but not the formatting or pagination defined in the report.

Cheers!

MF.
Title: Re: Using page break while bursting csv files
Post by: hespora on 03 Dec 2018 02:16:54 AM
create two pages with your data, and give them both a render variable around the ReportOutput() function.