I've got some changes that need making to the Packing List report within the next two weeks and I'm staring at Crystal Reports and the 1001 other things to do around here and thinking I haven't got the time to ascend the learning curve. Input would therefore be much appreciated on how to achieve this or to identify someone who could do this work for us!
The problem:
Get a picking location onto the Picking List. We have new staff starting in 3 weeks and with 2000 SKUs and growing, navigating the warehouse is becoming increasingly difficult.
Solution so far:
Added a custom property 'LOCATION' which can be set per product. This is now in the ProductProperties table as nValue1 = 18. However the report must assume this might not have been set for a product - which is where Crystal Reports immediately let me down. Despite fathoming out how to start modifying the SQL, the left outer join from OrderDetail to ProductProperties fails to return a row when there is no row in ProductProperties. This is before I've figured out how to get the resultant ProductProperties.sString1 value that contains the location onto the report.
Pointers welcome, or if you do custom reports work then please email me for a spec to quote against.
Alternatively, if someone's done this before in a different/easier way then I'd be interested to hear about it!
Cheers,
simon
The problem:
Get a picking location onto the Picking List. We have new staff starting in 3 weeks and with 2000 SKUs and growing, navigating the warehouse is becoming increasingly difficult.
Solution so far:
Added a custom property 'LOCATION' which can be set per product. This is now in the ProductProperties table as nValue1 = 18. However the report must assume this might not have been set for a product - which is where Crystal Reports immediately let me down. Despite fathoming out how to start modifying the SQL, the left outer join from OrderDetail to ProductProperties fails to return a row when there is no row in ProductProperties. This is before I've figured out how to get the resultant ProductProperties.sString1 value that contains the location onto the report.
Pointers welcome, or if you do custom reports work then please email me for a spec to quote against.
Alternatively, if someone's done this before in a different/easier way then I'd be interested to hear about it!
Cheers,
simon
Comment