O$: report page break

[Geir Fjærli]

Not at all sure, but could you not add an invisible field that sits in the record section and which concatenates the school ID (or whatever you trigger the subtotal on today) with the page number, and use that as your sort field.That way, a new subtotal heading would be triggered when the page number changes as well as when the school changes. 

Now you may of course want the subtotal to actually contain something totaled for the entire school, not just what happened to fit on that page.

In that case, could you have a separate secondary sort field along the same lines, with its own subtot header, that is one that triggers only when the school is the same and there is a new page. So when there is a new school, subotal heading 1 is triggered, and when there is a new page (but not a new school) subtotal heading 2 is triggered. They could be, but don't have to be identical. (Number 2 could say "School X continued from previous page.")

That way subotal 1 would be for the entire school.

Another old style option: Set up the subotal 2 header to print on every record, then add an invisible field that again checks if same school and not same page, with "Skip section if empty" to prevent it from printing other than when a new page...

Sorry if this shows my declining memory of all things Omnis. I don't have Omnis handy to test here...

Geir :)

9. juli 2013 kl. 21:05 skrev Jim Pistrang <jim at jpcr.com>:

> Hi all,
> 
> In the category of I really should know this....
> 
> I have a report based on a list that loops through the list and does a Print Record for each line in the list.  There is a single subtotal level in the report, with a Subtotal Header section.  Usually there are 2 or 3 records for each section, but occasionally there are more or less.  I want to break to a new page for a new header whenever the detail records will not fit on the old page.  How can I do this?
> 
> The report output looks like this:
> 
> SCHOOL
>  student record
>  student record
> SCHOOL
>  student record
> SCHOOL
>  student record
>  student record
>  student record
>  student record
> SCHOOL
>  student record
>  student record
> 
> To rephrase my question, I never want to split up a SCHOOL from its student records.  How can I do this?
> 
> Thanks,
> 
> JIm
> 
> 
> --
> Jim Pistrang
> JP Computer Resources
> 413-256-4569
> <http://www.jpcr.com>
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com