Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detail row information printing only on odd pages

Status
Not open for further replies.

barefoottraveler

Programmer
Dec 13, 2006
10
US
I am working with Crystal v9. I have Oracle 10g datasource. Trying to "insert a blank page" after page one of the report for duplex printing. I have the following formula in in Section Expert.Page Header/Footer.Suppress:

if remainder (pagenumber,2) = 0 then 'even page
formula = true
else
formula = false
end if

This formula successfully suppresses the header/footer but I am unable to do the same with the detail section. The detail section always leaves one row of data on the even numbered pages.

Anyone have insight on how to "push" detail rows to odd numbered pages only??
 
What is on page one? Are you grouping on a field with new page after set on the group footer?

-LB
 
Page one has the Page Header, Detail rows and Page Footer.

The grouping is done in the code and the data is stored in a data table as a string delimited by '~'. The report then parses the data to form each unique Detail row.

There can be from one to hundreds of rows per group. The Detail section holds 26 rows of data before moving to the next page.
 
Okay, insert a detail_b section and then go into the section expert->detail_b->suppress->x+2 and enter:

remainder(recordnumber,26) <> 0

Then select detail-b->new page before->x+2 and enter:

remainder(recordnumber,26) = 0

Then add the same formula to new page after (again on detail_b).

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top