Print reports - page break between Groups

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a report that we Group/Sort, so each Group has multiple records.  When printing to PDF it givers me the option to print each record on a separate page but I really need to print each GROUP on a separate page.  How can I do that?

Photo of Jason

Jason

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
If you have a table which drives your groups, you can make an embedded report similar to your full report.  Then print out your group records and select the option to print 1 page per group.

If you do not have a group table, then I would make a summary report of your groups and populate such a table. 


Either way, filter the report so that it only lists groups with data.  You will need to make a summary field to determine that.

.. or a low tech possibly painful way is to make the group be an <ask the user> and run the report manually once per Group.
Photo of Jason

Jason

  • 0 Points
You are a genius as always!  Thanks!
Photo of Dana

Dana

  • 0 Points
I have a similar scenario. I have a table report with records grouped by a date field, and I would like to put each date on its own page (and have the headers appear on each page). I do not see an option to print 1 page per group. Is this only available on certain report types?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
If it is a Table Report type, then the option to Print 1 Page per record comes up when you Print using the More ... Print button..
Photo of Dana

Dana

  • 0 Points
Hm, I only see two options: Print the report as a table and Print one session per page (855 total). Each day grouping can have 1 to 100+ sessions, so I wouldn't want 855 pages, but more like 10, depending on how many days total I have for that project. Do I need a table for Days in order to print by day groups?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
OK, sorry, I misread your question.
Maybe it should have been a new question so more Forum users would see it.

I do not know of a way to page break on break of report heading.  I suggest that you post it as a new question.  The only thought I have is if there is a special character string which universally means to cause a page break, and embed that into your group heading text.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Actually, there may be a way.  I suggest that you post this as a new question.

I did a test with a field called [Report Break Heading] with the following code and html enabled.
In this case i was trying to Page Break on Client, ie one Client per page of records.

"<div style='page-break-before: always'>&nbsp" & [Client]

It did affect the print out to heading break on group by, but it may also have sort of locked up my app and also I think I lost the column headings.