Crystal 10 - Identify Last Page of a Group

[pamelarj]

I work for a health insurance company and we print what are referred to as EOBs. An EOB will list, per member, the claims for that member that have been denied during a particular week. The report is grouped by Member ID and the number of claims (thus pages) for the Member ID varies by member.

Because we print so many we'd like to run this print job through our mail sorter. In order to do that we have to print Bar Codes at the top of the page.

My dilemma is that I need to know how to identify the last page of a Group. As the last page for a member will have a code that indicates to the mail sorter that its the last page to be put in the same envelope.

To further complicate things, our Mail Room Supervisor would like for these to be batched by the No. of pages for each member. In other words single pages would print together, then EOBs with only two pages would print together, etc.

Any ideas?

 

[synapsevampire]

Try a formula of:

whileprintingrecords;
if next({table.groupfield}) <> {table.groupfield} then
"Last Page"

Creating a formula of:

count({tale.field},{table.group}) might allow you to use the Report->Group Sort Expert, however you are grouping on something already so this complicates things and I can't test on Crystal right now.

-k

 

[pamelarj]

Synapsevampire,

Where would I put this code?

 

[lbass]

If you format the group footer to "New Page After" and also "Reset Page Number After", the "special field" totalpagecount will reflect the total pages in the group. YOu can then use a formula like:

if pagenumber = totalpagecount then "Last Page in Group"

-LB

 

[synapsevampire]

Susbtitute your bar code display for the formula.

Also you could just display in the group footer, that's always the last page of that group.

-k