Suppress Line in Bottom Group Footer of each Page

[takamisa]

I have the following setup:

PH
GH1
GH2
GH3a
GH3b
GH3c
Details
GF3
GF2
GF1a
GF1b
PF

There is a box surrounding all data from PH to PF.

Group2 filters the data and provides subtotals in GF2. Group2 has 'Keep Together' selected. After the subtotals is a line.

At the moment, the line is doubling with the box if there is more than one Group2 record per page.

I can suppress the line at the end of each report with:
'OnLastRecord' or '{OEORDH.ORDNUMBER} <> Next ({OEORDH.ORDNUMBER})'

But how do I suppress the line in the last Group2 per page to prevent it doubling with the box.

[anne-petteroe]

Hello Francis,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,
Anne

[DellSC]

There is no way to remove the line at the end of the page. You could remove the line from GF2 and put it at the top of GH2 instead and see whether that gives a more acceptable layout for you. However, that will potentially give you a double line at the top when Group 2 starts at the top of a page.

Another option, instead of having your box from PH to PF, would be to do the following:

1. Put a box from the top of GH1 to the bottom of GF1b.

2. Go to the Options tab of the Group Expert for Group 1. Turn on either "Always Close Border" or "Close Border on Page Breaks" - you'll have one or the other depending in which version of Crystal you're using.

3. Put a box from the top of GH2 to the bottom of GF2. Set so that the sides are on top of the Group 1 border. Make sure that the Y position for the box is 0 so that it's at the very top of the GH2 section. Pull the bottom of the GF2 section up to the bottom of the box.

4. In the Options tab of the Group Expert for Group 2, turn OFF the close border option.

-Dell