COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: esar on 16 May 2014 11:05:23 AM

Title: Newspaper Style page break
Post by: esar on 16 May 2014 11:05:23 AM
Hi Experts,

I am not sure if this was discussed earlier, but my search dint help. I need to have a list report that breaks after 20 rows and the next set of 20 rows should appear in the same page to the right of it instead of going to next page. I am able to achieve this with repeater, but the report is slow. Is there a way to achieve this with some page setting or pagination properties. I have attached the layout.

I appreciate any assistance offered.
Title: Re: Newspaper Style page break
Post by: navissar on 18 May 2014 12:28:59 AM
I can't think of a better way than to use a repeater. A repeater slows down your report because it uses Master Detail Relationship. Try moving to DQM if possible - MDRs are dealt with so much better on DQM. Also, check out this guide for improving MDR performance - in many cases, it works. http://www.ibm.com/developerworks/data/library/cognos/reporting/performance_and_tuning/page582.html (http://www.ibm.com/developerworks/data/library/cognos/reporting/performance_and_tuning/page582.html)