Hi friends,
I have a crystal report to display invoices. Each invoice has multiple products. I have grouped by Invoice No and put the products in the 'Details' section. I have given 'Record Number' from insert >> special field (1, 2, 3, ...) to each of my products which I want to display on the invoice.
However, now the serial numbers keep incrementing on the next invoice (I want them to start from 1 on the next invoice, i.e. the next group item).
For e.g., if Invoice1 has 3 products and Invoice2 has 5 products, the numbering of products in Invoice2 is coming as 4, 5, 6, 7, 8. While, I want it to be 1, 2, 3, 4, 5
Is there a way to get over this? Or can I write a formula (which is not striking me at the moment).
Cross Post [ame="http://www.vbforums.com/showthread.php?t=589015"]here[/ame]
Regards,
Karan
I have a crystal report to display invoices. Each invoice has multiple products. I have grouped by Invoice No and put the products in the 'Details' section. I have given 'Record Number' from insert >> special field (1, 2, 3, ...) to each of my products which I want to display on the invoice.
However, now the serial numbers keep incrementing on the next invoice (I want them to start from 1 on the next invoice, i.e. the next group item).
For e.g., if Invoice1 has 3 products and Invoice2 has 5 products, the numbering of products in Invoice2 is coming as 4, 5, 6, 7, 8. While, I want it to be 1, 2, 3, 4, 5
Is there a way to get over this? Or can I write a formula (which is not striking me at the moment).
Cross Post [ame="http://www.vbforums.com/showthread.php?t=589015"]here[/ame]
Regards,
Karan
