Conditionally Suppress Line in GF on Last Record in Group

[vb6novice]

A report I'm developing using CR 11 has 3 levels of grouping with GH and GF1, 2, and 3. In GF3 there is a vertical line and 2 fields that I want to show each time GF3 is printed, unless it is the last GF3 before a new GF2 prints, in which case only the fields show and NOT the line.

Is it possible to determine when the report is printing the last GF3 before the next GF2?

All expert advice welcome.

 

[lbass]

You could create a running total that counts on change of group#3 and is reset on change of Group#2. Then use a conditional suppression formula of:

{#rt} = distinctcount({table.group3field},{table.group2field})

-LB

 

[vb6novice]

That might work. While you were typing your response I just tried a little thing that works.

I duplicated the field that is the basis for change of Group 2 and put it in GF3. Then I made it's Right Border Single, and then used a conditional suppression formula ofif Next({CR_REQUEST_LINK.LINK_NO}) <> {CR_REQUEST_LINK.LINK_NO} then
true)

It works as desired. Thanks for the help.

 

[lbass]

You should be using:

{table.group2field} <> next({table.group2field})

Maybe that's what you mean. And yes, that would be simpler.

-LB

 

[vb6novice]

That's what

Next({CR_REQUEST_LINK.LINK_NO}) <> {CR_REQUEST_LINK.LINK_NO}

is.

Thanks.