force new group

[duehring]

I would like to limit group details to n records. If 'details > n', a new group would print. I don't care how many groups/details are on each page, and I don't want to 'new page after'. I just want the 'details > n' to print in the next group down. Ideas?

Example if details > 2
----------------------
Unique Employee 1 SSN Date of Hire
Sales 1
Sales 2

Unique Employee 1 SSN Date of Hire
Sales 3

Unique Employee 2 SSN Date of Hire
Sales 1

Unique Employee 3...

 

[lbass]

If these don't need to be groups per se, and if you do in fact want the employee to repeat above new details, then you can do this:

Insert a group on employee and suppress the group header. Insert a details b section. Add the employee field to details_a and the sales field to details_b. Then insert a running total {#cntwingrp} that does a count of {table.sales}, evaluate for each record, reset on change of group: {table.employee}.


In the section expert->details_a->suppress->x+2, add this formula:

remainder({#cntwingrp},2)<>1

-LB

 

[duehring]

Thanks for the idea!