second page header is blank

[atarrqis]

CRXI and Oracle
I have a report with the following sections:
Page Header A
Page Header B (suppress if PageNumber<>1)
Page Header C
Group Header #1
Details A
Details B
Details C
Details D
Group Footer #1
Report Footer A
Report Footer B
Report Footer C
Report Footer D
Page Footer A
Page Footer B
Page Footer C

Page Header A contains a few text boxes and a few data fields. Depending on how many rows of data in a particular report it may run into 2 pages. If the report is just barely over 1 page, the data fields in the Page Header A on page 2 are blank - although they are correct on the first page. If there is just a little bit more data (or I expand a section slightly) the 2nd page header prints the data just fine. It's as if it doesn't quite recognize the new page. Is there some setting I'm missing?

 

[lbass]

What data fields are you placing in the page header?

Also, what field are you grouping on?

When there is missing page header information, what report sections are displayed on the page (what section names do you see in the gray area to the left of the report canvas?

-LB

 

[atarrqis]

Invoice_no, customer_no
The group is on report_key.
Page 2 has:
PHa
PHc
RFc
RFd
PFa
PFb
The only difference with Page 1 is that it has PHb and the detail sections. The report footer sections are all flagged as "key together" and some are flagged as suppress if blank.

 

[GJParker]

It sounds like all of the records are printing on page 1 and so in your PHA section on page 2 there aer no more records to print.

If you ar erunning teh report for multiple customer / invoices you will need to create a group
from customer/ no and invoice no and use teh group header sections insteda of page headers

If your report is running fro single invoices then could create 2 formulas and place these in PHa instead.

//@Invoice_no
Shared NumberVar InvoiceNo := {table.invoice_no}

//@Customer_no
Shared NumberVar CustomerNo := {table.customer_no}

HTH





Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

The page header should pick up the last values from the previous page if there are no values on the current page. But I agree with Gary, that it would be better to use group headers. If there is only one value per report, then create formulas for the page header, e.g.:

maximum({invoiceno})

-LB

 

[atarrqis]

There is always only one invoice_no & customer_no per report_key. If there are more details the second page prints fine, including the page header with invoice_no & customer_no. If there are less details, the one and only page prints fine, including the page header with invoice_no & customer_no. It is only when it's just over one page that I lose the page header fields - just the data, not the text boxes.
I've removed the group since it's not necessary but no improvement.
I removed customer_no and I added the formula as suggested
//@Invoice_no
Shared StringVar InvNo := {CUST_ORDER_IVC_REP\\.INVOICE_NO}
and used only this for data in the Page Header and suppress where PageNumber=1. Again, text prints on the second page but not this data.
I can create the maximum({invoiceno}) using the Summary command but it will not let me place this in the PageHeader area.

 

[lbass]

Create a formula and place it in the page header. Inserted summaries can't be placed there, but formulas can. Since you have a group, make the formula:

maximum({invoiceno},{table.report_key})

-LB