Need to suppress last inner group footer 1

[crystaldev1]

Hello. I have two groups (Group #1 and Group #2). I have a line in Group Footer #2 for every groups in Group #2. I would like to suppress that line if the group is the last group for Group #2 so it doesn't show before Group #1. Thanks for your help.

 

[highsmith]

Since I'm asking questions today I'll try to help with a few too!

Can you answer these two questions and maybe I can help...

Group 1 hdr
Group 2 hdr
Group 2 ftr
Group 2 hdr
Group 2 ftr <--you want to suppress just this one? always?
Group 1 ftr

 

[crystaldev1]

Yes to both questions. Thanks.

 

[lbass]

Use a suppression formula like this on the section containing the line (the line should be in its own section):

nextisnull({table.group#1field}) or
{table.group#1field} <> next({table.group#1field})

-LB

 

[crystaldev1]

Thanks for the reply. I tried using those formulas above and it seems like it's being suppressed only for the last record in the report and not the last record in the group.

 

[crystaldev1]

I got it to work finally. Thanks for all your help.