Suppress Page footer formula at group level

[niru7654]

Hello

I have created a legal letter to send to defendants and attorneys. Now, I added group#1 on the top of the letter to display the address label, and the next group, #2, starts from page two of the letter. There is a page footer for the letter I want to keep and to suppress the page footer for the address label page (group#1). How can I do that? Thanks in advance, and any help would be appreciated.

[DellSC]

Ok, try this:

1. In the Section Expert for GroupFooter 1 turn off "Reset Page Number After".

2. For the suppression formula for the page footer section, use something like the following formula instead of what I showed above:

OnFirstRecord or {MyTable.Group1Field} <> previous({MyTable.Group1Field})

This should suppress the page footer on the first page and then on the first page of every group.

-Dell

[niru7654]

Hi Dell,

As you mentioned the first approach is working; it was my mistake on Page Footer Section expert in the Paging section “Reset page Number after” was turned on. When I turned it off, I could see the page footer on every page of group# 2 and details sections except group#1, and that was what I wanted. Thanks for the second approach, and I will try that one. Thanks for your help!

[DellSC]

If I understand correctly, you want to suppress the footer on the first page of the group and show it on the second and successive pages within the same group. If that's correct, try this:

1. Go to the Section Expert for the group footer.

2. On the Paging tab, turn on "Reset Page Number After"

3. For the same section, click on the formula button to the right of "New Page After" (DO NOT check the checkbox!) and enter this formula:

Not OnLastRecord

This will prevent a blank page at the end of the report.

4. Still in the Section Expert, select the page footer section.

5. On the Common tab, click on the formula button to the right of "Suppress (No Drilldown)" (DO NOT check the checkbox!) and enter this formula:

PageNumber = 1

This will suppress the page footer on the first page of every group.

-Dell

[niru7654]

Hi Dell,

Thanks for the quick response. It suppresses the page footer for group#1 on page 1, so it works. Thank you!

Next, I want to display the page footer for group#2 on every page. I have about 11 group#2 sections (from a-k) because of the letter format; it gets 2 pages when I run/preview. I can see the page footer on page one of group#2 but not on page 3. I want to show the page footer for group#2 on both pages. Is there a way?