page break for cards

[lauriesamh]

Hi,
I'm doing memebership cards for my company. Currently in CR8.5, but moving to 10. The main report has the primary person with a subreport listing their dependants. In some cases a person has more than 6 dependants which exceeds the 6 line limit fit on a card. I would like to do a page break on the group footer record in the subreport on every 7th dependant. Is there a way to do this.

A dependant is based on it's id and extension and they print on the extension grouping.
ie. 12345 01
12345 02....

Any ideas welcome

 

[synapsevampire]

Sure, use the three formula method:

Group Header:
whileprintingrecords;
numbervar Counter:=0

Details:
whileprintingrecords;
numbervar Counter:=Counter+1

Group Footer formula for new page after:
whileprintingrecords;
numbervar Counter;
int(counter)/6 = counter/6

Since it fits six, you wouldn't want every 7th, you want a new page after for every 6. So the above works if they have 7 or 15 or even 100.

-k

 

[synapsevampire]

Sorry, the group footer formula new page after should have been the details new page after formula:

Sure, use the three formula method:

Group Header:
whileprintingrecords;
numbervar Counter:=0

Details:
whileprintingrecords;
numbervar Counter:=Counter+1

Details formula for new page after:
whileprintingrecords;
numbervar Counter;
int(counter)/6 = counter/6

Since it fits six, you wouldn't want every 7th, you want a new page after for every 6. So the above works if they have 7 or 15 or even 100.

-k

 

[lauriesamh]

there are two group headers... one for the primary person and then a header for each dependant. Just to confirm:

I put this in the dependant group header new page after formula in the section expert
//Group Header:
whileprintingrecords;
numbervar Counter:=0

and this in the details new page after formula in the section expert.
//Details:
whileprintingrecords:
numbervar Counter:=Counter+1

and then the last part in the group footer for the dependants new page after formula in the section expert.

//Details formula for new page after:
whileprintingrecords;
numbervar Counter;
int(counter)/6 = counter/6

Thanks!!!!1

 

[lbass]

The first two formulas belong on the report in the designated sections (you can suppress them). The last one belongs in the new page after formula section for the details section.

-LB

 

[synapsevampire]

Note that my 2nd post coirrected the first, you have it set to my first post.

The final formula goes in:

right click the details, select format section-> click the X2 adjacent to Suppress

-k

 

[lauriesamh]

K,
I'm obviously not doing something right as I'm getting the subreport records printing one per page with breaks after each.

I put the formula @GROUPHEADER in the Primary Person Header... should this go in the Dependant header?
whileprintingrecords;
numbervar Counter:=0

I put the @Detail Counter formula in the dependant group footer.
whileprintingrecords:
numbervar Counter:=Counter+1

I put the formula into the Section Expert for the Group footer for the dependant section.
whileprintingrecords;
numbervar Counter;
int(counter)/6 = counter/6

Please let me know what I'm missing... many thanks.

 

[synapsevampire]

Detail counter goes in the details.

The last formula goes in the new page after formula of the details section.

-k

 

[lauriesamh]

Thanks!

 

[lauriesamh]

k-
Belated question on formatting.
In the subreport the first page for primary members with multiple dependants prints fine, but the subsequent page(s) the subreport puts the dependants on the top of the next page. How do I format the subreport to print in the exact page position on the subsequent pages?
Thanks