Picking Sheet Printing - pritning orders that contain a specific item

SUGGESTED

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.

Parents
  • 0

    I'd never do this kind of thing in a report filter.  Set up a header UDF and use the printing screen's Selection grid.

    If you absolutely must do this in the report, add a Group selection filter instead of Report selection.

  • 0 in reply to Kevin M
    SUGGESTED

    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.

Reply
  • 0 in reply to Kevin M
    SUGGESTED

    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.

Children