Field Displays on Page 2 in page header but not page 1

[wanzek]

I am working on a report that has a page header. That has various fields but when I select fields from a certain table it will not display on any page except for the vary last page. Any idea why this would be? Could it be a link issue between tables?

 

[lbass]

Are you placing an actual field in the page header? Or just a label for the field? If a field, it will only pick up the value of the first record on the page. You should try placing the same field in the detail section. If it is null on the first page, you would not see a value on the page header on that page.

-LB

 

[wanzek]

I am placing the actual field. When I place the value in the detail section the first field is blank. This is what I am trying to accomplish:

When we enter data into our software it creates a batch each batch is automatically assigned a batch ID number. I would like to have the last batch ID number print that is associated with the job selected.

Is it possible to tell crystal to give the last batch ID?

 

[lbass]

Create a formula like this:

maximum({table.batchID})

Place this in the page header. If you have a group on job, and you want the last batchID per job, then change the formula to:

maximum({table.batchID}, {table.job})

-LB