Report formatting based on # of detail records

G

Guest

I'm at a loss. I have an invoice report that has varying numbers of detail
records for each customer. I need a page break and line to show up at the
bottom of a page if the number of detail records is a particular number, say
12. Otherwise, the invoice footer should just print on the page as usual

I have a text box that will show the TOTAL number of detail records per
customer, but that doesn't help me. I set the page break and line to
'visible' in the group footer format event, but I don't know how to tell it
to only do so if the number of detail records reaches 12.

Can anybody help? I appreciate it.
 
A

adsl

DEW said:
I'm at a loss. I have an invoice report that has varying numbers of
detail
records for each customer. I need a page break and line to show up at the
bottom of a page if the number of detail records is a particular number,
say
12. Otherwise, the invoice footer should just print on the page as usual

I have a text box that will show the TOTAL number of detail records per
customer, but that doesn't help me. I set the page break and line to
'visible' in the group footer format event, but I don't know how to tell
it
to only do so if the number of detail records reaches 12.

Can anybody help? I appreciate it.
Click to expand...
 
A

adsl

DEW said:
I'm at a loss. I have an invoice report that has varying numbers of
detail
records for each customer. I need a page break and line to show up at the
bottom of a page if the number of detail records is a particular number,
say
12. Otherwise, the invoice footer should just print on the page as usual

I have a text box that will show the TOTAL number of detail records per
customer, but that doesn't help me. I set the page break and line to
'visible' in the group footer format event, but I don't know how to tell
it
to only do so if the number of detail records reaches 12.

Can anybody help? I appreciate it.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Orphan Footers 2
Report, Repeat the group footer 1
Vertical Lines in Detail Section of Report 1
Need some help with reporting 0
Rpt totals of datediff field only if checkbox of another field che 1
Restarting Page Numbers on a Multi-Page Report 3
Running sum on report 4
Report prints blank lines in detail section 1

Top