Hello, I have an environment where packing lists are sent to department printers. Thus, frozen items (Department=4) go to a printer over by the freezer. Dry Goods (Department=1) go over by, you guessed it, the dry ingredients area.
I can see already that Crystal Reports is the tool to use in this situation. I have seen that destination printers can be changed/called in the CR code.
----- Printer select code (to be triggered after item/department sort) Dim prt As Printer For Each prt In Printers
If prt.DeviceName = strPrinterName Then Set Printer = prt
strDeviceName = prt.DeviceName strDriverName = prt.DriverName strPort = prt.Port
Exit For End If Next prt Set prt = Nothing Report.SelectPrinter strDriverName, strDeviceName, strPort Report.PrintOut True
-------------------------------
I need to take a said transaction, and send pieces that are sorted by Department or ItemLookupCode to various areas.
Theoretically, this can be accomplished by a main report that prints everything as a Main Packing Slip, then performs a subquery or conditional branch to fire off other pieces.
If Transaction has Items where Department = X Then Print to PrinterX
This If statement could be repeated to filter for each department, or maybe a switch conditional
Is this something that is too advanced for someone to just pickup Crystal Reports and fire away? Just asking for some friendly advice from the CR gurus in the forum before I drop 300 bucks on the developer edition....
Thanks for your input!
Kevin