Click to See Complete Forum and Search --> : Suppress a section based on Page Number


Kiranikaa
June 27th, 2006, 12:46 PM
Hi,

I have a report that has Report Header, Page Header, Couple of Detail Section, Page Footer and Report Footer

In Report Footer i have used 3 sub section RF a, RF b and RF c.

I want to do the following:
---------------------------------
if section RF b is an odd number page and it will be suppress. If it is even number page, display it.

I have tried, using formula in RF b section suppress(No Drill-Down) formula box to the following code:

PageNumber Mod 2 = 1

But it does not work.

Any one help me please!
Thanks in advance.

Thank you,

JaganEllis
June 27th, 2006, 06:18 PM
You want to use the page footer, not the report footer.
From the help:

Report Footer
This section is used for information you want to appear only once at the end of the report

Page Footer
This section usually contains the page number and any other information you want to appear on the bottom of each page

JaganEllis
June 27th, 2006, 06:22 PM
But if you really do want the report footer to be suppressed on an odd page then what you've done should work - it does for me.
Sorry, not much help :)

Kiranikaa
June 28th, 2006, 09:22 AM
Thank you for your reply.

I have 3 subsection in ReportFooter. So i nedd to supperss the second subsection only based on the page number. Third section having a subreport. It will display multiple pages(atleast 2 pages)