MAS500
asked on
Crystal Reports 10 - Repeat Footer based on Variable Data
NEWBIE ALERT!
I would like to know if it is possible to repeat a Footer x times, based on a variable.
In general terms, the report is grouped by Sales Order Number and Line Number. In the line number grouping we have Item Number and Quantity.
If multiple quantities of a given Item Number are purchased , I would like the Group footer repeated X times.
For Order Number 0001, I have 2 Line Numbers. Line 1 is Item Number 111111 with a Quantity of 2 and Line 2 is Item Number 22222 with a Quantity of 3
I would like the output to look similar to this:
Order Number 0001
Line Number 1
Item Number Quantity
11111 1
11111 1
11111 1
Order Number 0001
Line Number 2
Item Number Quantity
22222 1
22222 1
Any and all thoughts and methods are appreciated.
Thanks
I would like to know if it is possible to repeat a Footer x times, based on a variable.
In general terms, the report is grouped by Sales Order Number and Line Number. In the line number grouping we have Item Number and Quantity.
If multiple quantities of a given Item Number are purchased , I would like the Group footer repeated X times.
For Order Number 0001, I have 2 Line Numbers. Line 1 is Item Number 111111 with a Quantity of 2 and Line 2 is Item Number 22222 with a Quantity of 3
I would like the output to look similar to this:
Order Number 0001
Line Number 1
Item Number Quantity
11111 1
11111 1
11111 1
Order Number 0001
Line Number 2
Item Number Quantity
22222 1
22222 1
Any and all thoughts and methods are appreciated.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
A far better solution indeed. The reason for the footer approach was that was the parameter passed on to me via IM.
Thanks for your help!
Thanks for your help!
ASKER
Solved!
ASKER
Thank you for your support!
ASKER