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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data not showing on 2nd Page

Status
Not open for further replies.
Mar 2, 2006
14
CA
Crystal XI SP1, ODBC. I have a report that displays a company's address in the page header. This info is pulled by using the following formula:

IF {Customer_Master.NAME_23}={SO_Master.NAME_27} and {Customer_Master.ADDR1_23}={SO_Master.ADDR1_27} and {Customer_Master.ADDR2_23}={SO_Master.ADDR2_27} and {Customer_Master.CITY_23}={SO_Master.CITY_27}

THEN {Customer_Master.ADDR2_23}

// test if the ship-to is a subcontractor

ELSE IF "NAMEEXAMPLE" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE IF "NAMEEXAMPLE3" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE IF "NAMEEXAMPLE2" in {SO_Master.NAME_27}
THEN {Customer_Master.ADDR2_23}
ELSE {SO_Master.ADDR2_27}

The name and address displays correctly on page 1 but not on any of the following pages.
 
Are you sure you have placed this in a page header and not the report header? If this is in a subreport, there are no page headers, and you have to create a fake one by first creating a formula like:

whilereadingrecords;
1

Then insert a group on this formula and check "repeat group header on each page". Then remove the group name and add your page header fields to this new "page header".

-LB
 
There is no subreport. Have verified and yes, it is in the page header. There are 4 Page headers. It will not print in any of them.
 
Another point--if I put the field into the section directly without the formula mentioned in my first post, it still does not display.
 
After realizing that this report worked prior to changing the data sources I moved around some of the links and now it works. Thanks fo the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top