Sorting Pick Tickets by Zone

[YoNeck]

We use Crystal to print our Pick Tickets for the warehouse and I'd like to know if I can sort a batch so the Pick Tickets come out sorted by the first zone on an order.

We may print 100 orders in a batch where 25 of the orders begin in Zone 1, 50 begin in Zone 2 and 30 begin in zone 3. Currently someone has to sort these orders into zones and give to the Order Picker in that zone.

Any suggestions?

 

[Turkbear]

If the Zone is in the data, then you should be able to Group ( or Sort) by Zone..
But, since no info about your data was provided,
please describe the table(s) used and their layout
as well as what datasource and version of Crystal.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

You should post techical information and then include descriptions if that seems neceesary.

Your software version, the database/connectivity, example data, and expected output.

You may be able to just Report->Sort and select the zone should work, menu depends on your software version) or use Insert->Group and select the zone. Then right click the Zone header and footer and select suppress.

-k

 

[IdoMillet]

1. Group the report by Order.

Let's assume that within order, you have a line items number (so you know which line item is first, second, etc.). If you don't, then you would need to check for 1st record within each Group using a global variable that gets reset in the Group header or via the Previous() function.

2. Create a formula of:
IF {Line_Item_Number}=1 THEN {Zone} ELSE 999

3. Create a formula that returns the Minimum of that formula for each Order. Assuming 999 is larger than any zone number you actually have, this would ensure you get the zone for the first line item within each Order.

4. Use the Group Sort expert to sort the groups by that Minimum.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[YoNeck]

Sorry for omitting all the details.

We are running Crystal Reports v8.5 with Dynamics eEnterprise 7.0.
The report draws the data from many tables but primarily two Sales order tables, SOP10100 Sales Header and SOP10200 Sales details and an Inventory table IV00102 field BINNMBR.

The picking zone is actually the first character of that field. For instance 1-a-1-a Zone 1, section a, level 1, Bin a. Each order can have picks from any or all of the zones.

My hope would be that all orders that start in zone 1 print first, zone 2 next, then zone 3, etc.