Is there a way with Crystal Reports to string together 3 different sales order form codes to print at once?
either for a single order of for multiple orders?
Click the Multi-Part button on the SO printing screen and you can print multiple copies from one form code. Use the Shadow Text field to pass different values into the report, allowing you to customize each copy (conditional text, section suppression...). All the logic has to fit within one report, but generally speaking this strategy is effective (with good Crystal Reports skills).
i see what you're saying but these form codes are differ greatly. i'll see if I can get it. Thanks
You can use sub-reports too, but that has it's own complications (grouping, page breaks, page headers / footers).
I have done this before and subreports is the best way if the forms differ greatly. Create the master report with just the SalesOrderWrk table and but the Sales Order Number in there as a group. Then add each subreport to the group footer and link based upon the Sales Order Number. Its best to create a group footer for each subreport. Hope this helps!
ok. that might work. thanks
That would certainly be less design work, with a blank main report (except for the group sections) and everything coming from the sub-reports.
Multi-Part gives you the ability to send each copy to a different printer, and the Paperless PDF will only include one copy (better if you are also emailing), but the sub-report idea suggested by Sage100Reports is certainly worth considering.
*Community Hub is the new name for Sage City