Sage 100

Does anyone know of a way to have the Picking Sheet in MAS 200 sort the details differently based on the shadow text in multipart printing? Client prints 3 copies of Pick Sheet, and wants the first copy to sort by bin location, with the remaining copies sorting by Sales Order Line number. I don't see where I can enter a formula for the sort, but the client would really like to just print one form instead of having to print twice. MAS 200 version 4.3, Crystal 10. Thanks, Ed

You could do a sub report one for each way and suppress based on shadow text.

Thanks Todd! I'll give that a try and let you know how it worked.

Tried the sub report idea, but the system sort overrides the sorts in the sub reports. I had one subreport set to sort by bin location and the other by line item. Suppression based on shadow text. Left the border around one sub report to make sure that the sub reports were printing. Each attempt to print sorted the reports based upon the selection in SO Options. To confirm this, I changed the selection from Bin to Item to Line, and the report printed according to that selection each time. I'll be glad to try any other ideas, but I'm ready to tell the client it can't be done.

I don't know why you couldn't have a different sort in the subreport. Where are you putting the subreport and what are you linking? It would not be by item it would be on the order level so you link the order number. The whole detail would be the subreport in the sort you wanted.

I wouldn't do a subreport; I would just create a formula called ""SORT"" and group by that field. I've done things like this when users wanted a crystal report sorted different ways and they could pick the sort method at runtime.

select {@ShadowText} Case ""BIN"" : {SO_PickingSheetWrk.BinLocation} Case ""LINE ORDER"" : {SO_PickingSheetWrk.SortField}