1. Home
  2. Point-Of-Sale Software
  3. Crystal Reports 8.5 & RMS

Crystal Reports 8.5 & RMS

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

Reply to
Fisher
Loading thread data ...

Reply to
Paul

The question was whether or not Crystal Reports was accessible enough for someone who has a rough idea of what they want out of it. I didn't know if the runtime RMS engine was watered down or difficult to work with.

Also, I was interested as to whether or not anyone had attempted sending precompiled reports to multiple printers. I know that RMS was intended for a retail environment, but with a few nips and tucks, I could see it handle B2B and wholesale fairly well, too. I.e. pack slips to multiple departments for coordinated shipping and order fulfillment.

Thanks! Kevin

Reply to
Fisher

My suggestion on multiple printers is sort of sad, but it works set up printer 2 as adobe pdf writer the use e-mail. We are wholesale retail as well.

Have you found the Report library? also macros are easy to set up.

"Fisher" wrote:

Reply to
Paul

Fisher,

I would recommend exploring the Crystal Reports forum for an answer to printing to multiple printers.

formatting link
9 - Tek Tips is a great resource for many other things as well. Rob

Reply to
Robert

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.