I don't know how to describe my problem. I have a report that I use for billing. Simple fields, Lastname, Firstname. So, this past month I had 2 bills with the same last name, let's call them Jane Cruz and John Cruz.
My Pageheader is ALLT(LASTNAME)-" "ALLT(FIRSTNAME) and in the Field Properties I have it to "Print When", Print Repeated Values set at yes.
Everything works great except when I have 2 entries with the same last name. Instead of printing 2 separate bills for $350.00 each, I get 1 bill for $700.00. The name of the second bill (John Cruz) doesn't print out, but the text of the bill does print out as if it was part of Jane Cruz's bill.
How do I split them up? Ideally, I would like it to continue printing for the same Lastname+Firstname but when the firstname changes the bill should change.
I hope I've put enough information in here.
Thanks for your help, I'm not a computer programmer, just a Foxpro user.
Alan
My Pageheader is ALLT(LASTNAME)-" "ALLT(FIRSTNAME) and in the Field Properties I have it to "Print When", Print Repeated Values set at yes.
Everything works great except when I have 2 entries with the same last name. Instead of printing 2 separate bills for $350.00 each, I get 1 bill for $700.00. The name of the second bill (John Cruz) doesn't print out, but the text of the bill does print out as if it was part of Jane Cruz's bill.
How do I split them up? Ideally, I would like it to continue printing for the same Lastname+Firstname but when the firstname changes the bill should change.
I hope I've put enough information in here.
Thanks for your help, I'm not a computer programmer, just a Foxpro user.
Alan