INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Hi I am trying to get a page foote

Hi I am trying to get a page foote

(OP)
Hi
I am trying to get a page footer to reset on the change of GH1.

I am using Crystal reports to produce an invoice, and every page footer holds the account payee information as well as page N of M. This works fine for a single invoice.

The users have now asked for a multiple invoice file so all invoice numbers for a customer can be printed off in one go rather than entering individual invoice numbers.

I have grouped the report by Invoice number so I have the multiple file working fine other than the report footer continues from page 1 through to the last page.
So if I had 3 invoices for a customer I would want page 1 of 7 > page 7 of 7 then for it to reset to page 1 of 8 for the next individual invoice number and then rest for page 1 of 5 > 5 of 5. Instead I get page 1 of 20.

I have used GF1a, GF1b, GF1c for subreports within the invoice, I cannot see how I can do this. HHHHHHEEELLLLPPP!!!

Thanks in advance.

RE: Hi I am trying to get a page foote

Hi,
I presume whole data set is a billing batch so :

If G1 is Customer, G2 is Invoice(or credit note) your footer should be in G2
something like :[field.docname] [field.docno] page n/n
- if you have credit notes, this work as Credit Notes will say "Credit Note", rather than hardcoding the word invoice.

In the section expert,
select group footer 2, go to the paging tab to check the box "Reset page number after" to switch on each page of each invoice no. having its own number.
so a file of 10 invoices will have 10 x page 1 and several of page 2 etc.
I just tested it, it worked for me.
Once you do this, you will see you were on the right lines,only slight out as to where to do this.

RE: Hi I am trying to get a page foote

(OP)
Thanks NickieP this worked fine

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close