Hi-
I have Order Header/Detail Line type data that I need to print a form for. This is not your usual "print the Header Info, followed by line 1, then line 2, etc."
The detail information needs to be printed in a grid - with the quantities filled in the appropriate boxes. There are (currently) 94 boxes, across 10 lines. (you can view an image of the form at - the bottom half.
I may have anywhere from none to all 94 of the detail items on an order, and basically I need to print the quantity, if not zero, in the right box. I don't see this as a cross-tab report. Or at least, I can't figure out in my head how to do it as a cross tab.
Using a series of formula, like "if Product ID = "M100" then [table.qty] else 0" works for the individual box, but since each detail line read causes the report to print a new detail section, the 94 boxes print each time a detail line is encountered (so a 3 line order gives 282 boxes). Placing the boxes in the footer gives only the last record, and in the header gives just the first, as you'd expect.
I'm using Crystal Reports version 8. Any ideas on how to get all the quantities printed in just one set of 94 boxes would be greatly appreciated!
Thanks much,
Bob Goldberg
I have Order Header/Detail Line type data that I need to print a form for. This is not your usual "print the Header Info, followed by line 1, then line 2, etc."
The detail information needs to be printed in a grid - with the quantities filled in the appropriate boxes. There are (currently) 94 boxes, across 10 lines. (you can view an image of the form at - the bottom half.
I may have anywhere from none to all 94 of the detail items on an order, and basically I need to print the quantity, if not zero, in the right box. I don't see this as a cross-tab report. Or at least, I can't figure out in my head how to do it as a cross tab.
Using a series of formula, like "if Product ID = "M100" then [table.qty] else 0" works for the individual box, but since each detail line read causes the report to print a new detail section, the 94 boxes print each time a detail line is encountered (so a 3 line order gives 282 boxes). Placing the boxes in the footer gives only the last record, and in the header gives just the first, as you'd expect.
I'm using Crystal Reports version 8. Any ideas on how to get all the quantities printed in just one set of 94 boxes would be greatly appreciated!
Thanks much,
Bob Goldberg