Link to home
Start Free TrialLog in
Avatar of MAS500
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
Avatar of MAS500
MAS500

ASKER

Of course, Line Number 1 is a Qty of 3 and Line Number 2 is a Qty of 2
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MAS500

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!
Avatar of MAS500

ASKER

Solved!
Avatar of MAS500

ASKER

Thank you for your support!