I'd like to edit the Picking Sheet printing Crystal report to only print orders containing a specific item. So if it contains that item, it prints a picking sheet with that item and any additional items ordered.
Does anyone have a formula for that? Using select expert, I've been able to print all the picking sheets containing that item, but it leaves off any other items on that order.
That would require user intervention to check the header UDF or use a script to read through the detail to set the value of the header UDF.
You can accomplish this by using a simple formula that evaluates…
That is the exact idea I had for a Group filter... we've used that technique many times before (sometimes using TRUE / FALSE and a min/max formula instead of sum). I wouldn't do that kind of filter…
That would require user intervention to check the header UDF or use a script to read through the detail to set the value of the header UDF.
You can accomplish this by using a simple formula that evaluates if the ItemCode equals a value and output a 1 if it does or a 0 if it doesn't. Since the report already has a group on the SalesOrderNo, you only have to modify the report's Group selection to sum the formula using the SalesOrderNo and evaluate if it is greater than 0. This effectively counts the number of lines matching your criteria by sales order and if at least one line is found matching the criteria, all of the sales order's lines will be selected.
EDIT: you should do this in another form code other than the STANDARD so that you don't cause confusion in the event someone isn't aware of your requirement and make sure to give the new form code a suitable description.
