Inserting a blank page to the report 3

[cdnamm]

Hi everyone,
I am doing a report that will create letters. I wanted to add a blank page to the letter that will end with the odd page number since we be printing as double-sided. I need the blank page for the letters that end with the odd number like 1, 3, 5, 7 and so on. If I don't have the blank page then the printer will take the next letter that follow the odd-page letter and print it on the back side of the odd-page letter and it'll mess up the order of the letters. Any
help would be greatly appreciated! Thanks!
cdnamm

 

[synapsevampire]

In the section with the letter add something like this to the New Page After:

remainder(pagenumber,2) <> 0

Note that this will alter the page numbering as the blank page will now be counted, and letters over 1 page will also cause problems.

Consider using another criteria (based on data perhaps) if required.

-k

 

[GMcNamara]

OK, I assume that Group 1 is what distinguishes one letter from the next. In GF1, in the section expert, click the x-2 button to the right of 'Suppress(No Drill-Down)'. In the formula editor, enter:
(pagenumber mod 2) = 1;

Click the 'New Page Before' checkbox.

click the x-2 button to the right of 'New Page After' and enter:
not onlastrecord;

 

[cdnamm]

synapsevampire,
I used a similar formula mod(pagenumber, 2) = 0 as a conditional suppress for a blank section. It will work
but on some letters it'll mess up the page number and
the gf would jump to another page.


GMcManara,
I think using your formula will suppress the groupfooter 1 when the page number is odd.

 

[GMcNamara]

Yes, GF1 needs to be empty. I should have mentioned that. If you are using GF1, insert a new section below it and do as above. I think that will work.

 

[cdnamm]

GMcNamara,
I tried that too but this new blank section is causing the page my other subsection of group 1 to jumb to another page eventhough the first page still has plenty of space. Do you know why it's like this? Thanks!
cdnamm

 

[Ngolem]

SV - I would use your formula but make the Group footer section into Section A and B

In Section (A) I would enable the &quot;New Page After&quot; unconditionally.

This moves us to a blank page...this is where the second section of the Group footer comes in

if the new page is an odd number we want to suppress the Group footer (B)
If the new page is even we want to enable the &quot;New Page After&quot;
We want to unconditionally set the &quot;Reset Page Number After&quot;

so in Group footer (B)

in the conditional &quot;suppress&quot; place the formula

WhilePrintingRecords;
remainder(pagenumber,2) <> 0;

in the conditional &quot;New Page After&quot; place the formula

WhilePrintingRecords;
remainder(pagenumber,2) = 0;

And check the &quot;Reset Page Number After&quot;

I think that will work


Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[GMcNamara]

The additional subsection of GF1 should jump to a new page, thus causing the blank page. So, if the page is odd, the GF1 subsection moves to the next page but doesn't display because it is blank. Then, we have checked 'New Page After', so the next letter starts on page 3.

 

[cdnamm]

Hi guys,
Thank you all very much for helping me! I tried Ngolem's way with the formulas that you guys gave me and took it from there...and it's worked. Again, thank you all very much!
cdnamm

 

[cdnamm]

Sorry guys, Ngolem...after double checking hundred of pages I found out that the the newpage after (remainder (pagenumber, 2) = 0) would not work on some of the letters. So now I will have several letters of combined of 2 into 1. Somehow, the formula on newpage after doesn't work on all letters. Thanks!

 

[Ngolem]

So what is special about the ones that didn't work??

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[cdnamm]

Ngolem,

I found out that all of the letters that have more than 1 page will be combined together. For example, if the first letter has 1 page then a blank page is inserted. If the next letter has more than 1 page then it will combined the following letter regardless of the no. of page that the following letter has. Anyways, I am thinking of suppressing the page no. Thanks!

cdnamm

 

[Ngolem]

OK - I think I have it now...I have tested it and it works fine on my machine

1. Suppress the page footer
2. Create 3 subsections of the Group footer
- Make the first Group subsection (A) the normal size containing what you would normally put in the Group footer.
- Make each following subsection(B) and (C) as small as possible.
3. In the Section Expert you will see 4 options for that Group footer...one for the section overall and one for each subsection (A),(B) and (C)
- In the section expert for the overall....remove [ALL] tick marks and conditional formulas.
- In footer (A), enable &quot;New Page After&quot;...nothingelse
- in footer (B), place the following forula in the conditional suppress

WhilePrintingRecords;
remainder(pagenumber,2) <> 0;

remove all other ticks and formulas
- in footer (C), enable &quot;New Page After&quot; and &quot;Reset Page Number after&quot;....nothing else.

It is critical that the page footer be suppressed...and the Footer sections (B) and (C) be made as small as you can

This works on my test report



Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[lyanch]

Okay... I haven't read all the post here so please forgive if this has already been stated.

The priniting of a blank page is only to make sure that the letters always start on an odd page correct???

If so.. why don't you just add to the section where the letter actually starts..

in the conditional formatting formula for &quot;new page before&quot;

remainder(pagenumber,2) = 0

..

Sorry if I made this too simple..

Lisa

 

[cdnamm]

Lisa,

I started out with the exact solution that you mentioned
above, but it would create all kind of problems like the subsections would jump to another page or the page no. wouldn't reset. Thanks for your help, though!

cdnamm

 

[cdnamm]

Ngolem,

It worked with resetting page number but it'll add a blank page to the letters that end with the even no. of pages.
I'm trying to work on that now....thnx!

cdnamm

 

[Ngolem]

It doesn't do so on my test report...make sure you exactly follow my directions.

Although you may have something I am not aware of in your report that causes a problem

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[cdnamm]

Ngolem,
I think you are right. The GF that I used to create
all 3 subsections also has 7 subsections above.
I took your advice and create 3 more subsections
below the 7 used subsections and did exactly what
you said but it produced a blank page for the even-pageno
letters. Therefore, I think the other subsections is
the cause of that. Thanks!
cdnamm