Hi, I'm hoping someone can suggest a good way to do the following.

We print a picking slip used by the warehouse to pull items for an order.

Currently the warehouse locations are stored in a separate database. When the warehouse receives the picking slip on their printer, they manually look up and write down the locations for each item and give it to the forklift guy.

So, the goal is to pull the location detail from the other database, and add it to the picking slip. I've done this, and I've got the locations printing under each line item.   

What I'd like to do is list them all together on the last page for organized usage, but I'm trying to avoid requiring the user to print an additional report manually.

Can you print additional detail for each record at the end of the report? Perhaps store the selection criteria in a string or something?

Or what might be even easier, is triggering a second report that contains the new details, but uses the same selection criteria.   Is this possible?

Thank yoU!

Edited by theghetto - 29 Apr 2013 at 1:16pm

Thanks for your help,

But can you be more specific on your suggestion?

If I place the subreport in a footer, it will only display the extra details of the last record.   How do I get it to display the details of all the records in the report?

Thank you!

Here's the basic thing I'm trying to do on the same report. Line item details from the order at top, warehouse locations at the end of the report:


ITEM #        QTY          Description

ep-12345    10,000        plastic bottle
ht-28273    500            trigger sprayer
aac-234     5,000          aerosol can
aac-2783    5,000          can end

-----------------------------------------------

ITEM       Location     Cartons    pieces/carton

ep-12345   RACK 12-E       3        2,000
ep-12345   RACK 12-D       1        2,000
ep-12345   RACK 18-A       1        2,000

ht-28273   G-7             1        500

aac-234    B-1             5        500
aac-234    C-9             5        500

aac-2783   RACK 8-A        1        1,000
aac-2783   D-4             4        1,000