Computing Number of Reports by Details

[StephHansen]

Each order can be identically repeated and there is a column in our table that shows this: CUR_ORD_QTY. So, if that number is 20, I should have 20 identical copies of that order printed out. How can I tell CR to do this and increment the number of that order that it is.

For example...Order 1234 is actually 20 orders that contain all the same items and details. How can I get make CR print 20 of that order and have it iterate 1/20...2/20...3/20...etc (similar to page 1 of 20, etc-but an order can take up more than one page based on the number of items it has)?


Thanks in advance!!!


Stephanie Nicholas
Software Engineer
i-Net Strategy

 

[crystalreporting]

There is one option that might work for you. Crystal creates one detail line for each record it finds. You could create a separate table with one record for each number e.g. 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5,6,6,6,6,6,6 and so on. You would then link your CUR_ORD_QTY field to the new table. This would repeat your detail section x number of times, based on the value in your CUR_ORD_QTY field. You would then be able to format your report to print a seperate page/section for each number. I know this sounds confusing, but it does work, and I use it regularly for printing a variable number of labels in Crystal based on an inventory or order quantity.

 

[StephHansen]

I think we are on the right track but I am a little confused...


I created a table in access called cur_ord, it only has one column, and has multiple rows, 1,2,2,3,3,3,4,4,4,4,etc with each number representing the next row. I linked it to my Orders table.

I created the group Cur_Ord_Qty from the new table.

I already have three groups in CR, Orders, Materials and Products (M and P representing items in the order). When I add the new Group above the orders group, I get that many readouts in the details section on one page, not splitting it up and repeating on a new page.

What have I done wrong? I have a "Print New Page" after the order group and one after the new qty group.

Thanks for your help!
Stephanie Nicholas
Software Engineer
i-Net Strategy

 

[StephHansen]

I have now removed the Materials and Products groupings but still have the Orders Group. Where should I add the group for the Number of SHeets to print out and how do I make it repeat everything, header and all details?

Thanks! Stephanie