Conditionally Suppress Section 1

[Thadeus]

Hello,
I'm attempting to conditionally suppress a section if it is an odd numbered page and I seem to be suppressing whether it is even or odd... Here's the formula I've entered into the Section Expert's Suppress formula:

Remainder (PageNumber, 2) <> 0

I do not have the check box checked for Suppress in the Section Expert and the formula icon does show red...

 

[Madawc]

Create a formula field with
pagenumber/2 = int(pagenumber/2)

This will be a Boolian, true for even and false otherwise

Madawc Williams
East Anglia
Great Britain

 

[Ngolem]

both of those formulas should work...Madawc's way is the more common way...if you get the same result there are other forces at play.

Which section of the report are you trying to suppress??
Are there any other conditions set on this section (eg. &quot;suppress blank section &quot;?

Jim Broadbent

 

[jwkolker]

OK, I needed to set New Page Before/After (not sure which - did both and doesn't appear to have impacted me negatively)

HOWEVER - Section prints on page 11 and it gets suppressed (excellent) Here's the problem, All the page numbers are then decreased by that first suppression, so the next time the section comes about it is now on an Even numbered page.
Ex.
Page 1(secA,) 2(secB), 3(secC), 4(secA), 5(secB), 6(secC), 7(secA), 8(secB), 9(secC)

If I suppress secC because it is on an odd page (3) then all of the pages are re-numbered and the next time it gets to secC it is on page 5 (still working)... re-number again and the next time it gets to secC it is on page 8 NOT ODD... hrumpf.

Any help?

 

[Thadeus]

Hold on I screwed up my example.

Thadeus / JWKolker

 

[Ngolem]

you might try placing &quot;WhilePrintingRecords&quot; in front of your formula...this makes sure this is done at the proper time.

Jim Broadbent