CFReport Manually forcing a page break

[Guest]

Hi All,

I've an issue with my Coldfusion Report templates (.cfr) in where i have to put page breaks. I've read some posts all of them says its quite impossible to accomplish. If anybody can help me on this that would be greatful.

Thanks.

[asimrafi]

Well, technically CFReport in CFMX 7 didn't support page breaks. But I did this in my CFMX 7 days logically. Follow these steps:
1. Create a group in report for the field whose value changes on every record. i.e. the record primary key or query.currentrow etc.
2. Configure the group to start new page for each group. This will print each record on separate page.
3. Now, if you need two pages for each record, you paste the contents of 1st page in group header and 2nd page in group footer. Also, adjust page header height so that it would occupy the whole page.
4. If you need three pages for each record, paste the contents of 1st page in group header, 2nd page in detail and 3rd page in group footer.

Hope this will help. (Although your post is old, it may help someone else) 🙂

[jlig]

asimrafi, Thanks for this insightful post!

I have CF 7.02 and could not get the Page-Break (Red-Dotted line) to work in the Report Builder..

Finally came across your idea & it worked perfectly..

• I created the following SQl for my main report to get the needed Groups:
• Then, I just created 6 groups and told each to start a new Page
• Lastly, I placed my 6 subreports in each group Header, using the following settings:
• Position Type = Fixed
• SELECT    tblSalesReport.srID
    , SUM(IF(tblSalesCatg.scDesc <> "XXX", 1,0)) AS `Group1`
    , SUM(IF(tblSalesCatg.scDesc <> "XXX", 1,0)) AS `Group2`
    , SUM(IF(tblSalesCatg.scDesc <> "XXX", 1,0)) AS `Group3`
    , SUM(IF(tblSalesCatg.scDesc <> "XXX", 1,0)) AS `Group4`
    , SUM(IF(tblSalesCatg.scDesc <> "XXX", 1,0)) AS `Group5`
    , SUM(IF(tblSalesCatg.scDesc <> "XXX", 1,0)) AS `Group6`
  
• FROM      tblSalesReport, tblSalesCatg
  WHERE     tblSalesCatg.scID = tblSalesReport.srSalesCatg
  GROUP BY  tblSalesReport.srSalesCatg
  ORDER BY  tblSalesCatg.scID LIMIT 1

Thanks again,

jlig