I have a report to create a budget reconcilation with the following structure:
- report header (text box with co-joined text and fields)
- page header (the same as the report header but smaller format)
- 2 field headers
- detail
- 2 field footers (for summing the fields)
- page footer (date & page)
- report footer (grand total)
My page header fields are not repeating on every page. There doesn't appear to be any rhyme or reason to why it appears or doesn't. The page header is set to not appear on the first page. Sometimes the page it appears on has the start of a new section, sometimes it's not.
I've tried putting the fields in as separate text-boxes, but it doesn't make any difference. The cojoined data doesn't appear; the stand alone data doesn't appear.
I tried putting the fields in the footer - same thing; appears some pages, doesn't appear other pages. If I put the fields in BOTH the header and footer sometimes they appear together; sometimes neither appear; but then again - on some page one will, the other won't.
I'm very confused.
*********
Okay, sorry about that. I hate working in databases I didn't design! I looked at the underlying query - it picks up budget inputs for "spent this invoice" plus "blanks" (ie budget items we haven't spent anything against this invoice). The fields I'm trying to get in my header are invoice number and the dates the invoice covers. Not all items in the underlying query have this info.
I've solved it with d'lookups
- report header (text box with co-joined text and fields)
- page header (the same as the report header but smaller format)
- 2 field headers
- detail
- 2 field footers (for summing the fields)
- page footer (date & page)
- report footer (grand total)
My page header fields are not repeating on every page. There doesn't appear to be any rhyme or reason to why it appears or doesn't. The page header is set to not appear on the first page. Sometimes the page it appears on has the start of a new section, sometimes it's not.
I've tried putting the fields in as separate text-boxes, but it doesn't make any difference. The cojoined data doesn't appear; the stand alone data doesn't appear.
I tried putting the fields in the footer - same thing; appears some pages, doesn't appear other pages. If I put the fields in BOTH the header and footer sometimes they appear together; sometimes neither appear; but then again - on some page one will, the other won't.
I'm very confused.
*********
Okay, sorry about that. I hate working in databases I didn't design! I looked at the underlying query - it picks up budget inputs for "spent this invoice" plus "blanks" (ie budget items we haven't spent anything against this invoice). The fields I'm trying to get in my header are invoice number and the dates the invoice covers. Not all items in the underlying query have this info.
I've solved it with d'lookups
Last edited:
