Crystal X -
Here's my formula:
if {gpv_SalesOrders.batchid} startswith 'N' then 1 else if
{gpv_SalesOrders.batchid} startswith 'O' then 2 else if
{gpv_SalesOrders.batchid} startswith 'P' then 3 else if
{gpv_SalesOrders.batchid} startswith 'W' then 4
Here's my Dataset........
N20120106-1
N20120203-2
W20120126-7
P20120103-6
O20120201-1
W20120104-3
etc.....
Standard report - formula doesn't error but doesn't return anything.....
Note - One batchid does start with 01072012SW (formula obviously doesn't cover this dataset........do I need to alter formula to catch 'all the non-conforming datasets? If so, how?
Anybody have a suggestion?
IP Logged
