supress line in detail section after the last record 1

[yog2go]

I have a group with two detail sections.
Detail section a has all fields in it.
Detail section b has dotted line in it.

I would like to supress the dotted line after the last record is hit in the group. How can i do that?

Thanks in advance.

 

[vidru]

Try using a Suppression formula on the Details b section based on your group field. If the next group is different then the current group, then you know you're on the last record for that group.

The suppression formula would look like this:
[tt]
OnLastRecord or {Table.GroupField} <> Next({Table.GroupField})
[/tt]
The OnLastRecord will suppress the Details b section for the last record on the report.

-dave

 

[yog2go]

I would like to suppress line at the end of each group not at the end of the report.
I have 3 groups.
I tried your formula somehow didn't work.

Thanks.

 

[vidru]

Did you replace "{Table.GroupField}" with your Group #3 field?

-dave

 

[yog2go]

Hi,
Sorry!! Instead of replacing your formula with actual field name i.e.({vwRPTEmployeeBenefitPlan.SalaryLevel}), i was replacing it with (GroupName({vwRPTEmployeeBenefitPlan.SalaryLevel}).

It works!!
Thank you sir,

Thanks for helping me!!