insert blank page on odd pages 1

[gooseriver]

I am using Crystal Reports 10

Report Structure:
GrpHeader1a - d (ClientLastName)
GrpHeader2 - Registration Number

In GrpFooter1d - I have New Page After
This put a new client on each page. However if the client starts on a even page number I want to insert a blank page so that the client starts on a odd # page.

How can I do this?

 

[IdoMillet]

Use the New Page Before expression...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[gooseriver]

Yes but how to do this on an even page number?

 

[lbass]

Insert a GF_e and format it to new page before and to new page after, and in the suppress->x+2 area add this formua:

remainder(pagenumber,2) <> 0

-LB

 

[gooseriver]

Thanks lbass, only issue is I need to suppress the Page Footer on the blank page.

 

[lbass]

Use a suppression formula on the page footer like this:

remainder(pagenumber,2)= 0 and
{table.group1field} <> next({table.group1field})

I notice you have a group on name, and that can be a problem with similar names, so you might consider grouping on a formula:

{table.name}+totext({table.ID},0,"")

You can still display just the last name instead of the groupname.

-LB

 

[gooseriver]

lbass, I modified my report using the remainder(pagenumber,2) <> 0 but it does not seem to be inserting a blank page when the lastmiddlefirstname starts on an even number page.

I used your suggestion on using names I added Middle name to it..

Here is my structure:
Page Header
GroupHeader1a - LastMiddleFirstName
-Keep Group Together
GroupHeader1b - LastMiddleFirstName
-Keep Group Together
-Suppress Blank Section
GroupHeader1c - LastMiddleFirstName
-Keep Group Together
-New Page After
GroupHeader1d - LastMiddleFirstName
-Keep Group Together
-New Page After (Not OnLastRecord)
-Suppress Blank Section
GroupHeader2 - RegistrationNumber
-Suppress Blank Section
Details
-Suppress Blank Section
GroupFooter2
GroupFooter1 - LastMiddleFirstName
-New Page After (Not OnLastRecord)
GroupFooter1a - LastMiddleFirstName
-Suppress Blank Section

GroupFooter1b - LastMiddleFirstName
-New Page Before (remainder(pagenumber,3)<>0 and {?newPage} = 1)
-New Page After (remainder(pagenumber,3)<>0 and {?newPage} = 1)
-Reset Page Number After
Page Footer
Report Footer

Page Footer
Report Footer

 

[lbass]

You did not implement my solution as suggested. Why are you using 3 instead of 2, and what is the new page parameter?

-LB

 

[gooseriver]

Actually it is 2 instead of 3 - typo the new page parameter is for a label surpress condition

 

[lbass]

I don't know how you are using {?newpage}, but it does not belong in the new page after/before formula area. Please try my suggestion as shown.

-LB

 

[gooseriver]

lbass, i inserted the section and added the condition to New Page Before and New Page After as you suggested-for some odd reason this did not work. I took that condition and placed in New Page After and New Page Before in the GrpHeader1d and it seems to be working..

 

[lbass]

I don't know what you are doing. The formulas belong on the group footer_b section. I did test this.

-LB