on 2017 Oct 31 10:22 AM
In the screenshot shown, data is reported in Group Footer #2. The "@Print Ops" formula field (Bullet 1) is a string of manufacturing operations. I have added the formula field "@Current OP" (Bullet 2) which returns the first operation listed in the "@Print OPs" field.
My question is, how can I group on the "@Current OPs" field and it be the first/primary group? Most of this report was developed by assistance provided by abhilash.kumar.
I also included the "Load JobOPs" to show what the PrintOPs is passed.
Load JobOPs
Shared stringVar JobOps;
Shared stringvar temp;
If {JobOperations.jmoProcessID} <> '' and {JobOperations.jmoProductionComplete} = 0 and
Instr(temp,totext({JobOperations.jmoJobOperationID},0) & "-" &{JobOperations.jmoProcessID}) = 0 then
(
temp := temp + totext({JobOperations.jmoJobOperationID},0) & "-" &{JobOperations.jmoProcessID} + ', ';
JobOps := JobOps + {JobOperations.jmoProcessID} + ' ';
)
;
' ';
Print OPS
Shared stringVar JobOps;
If Instr(JobOps,', ') > 0 then
Left(JobOps, Len(JobOps)-2)
else
JobOps + " "
CurrentOP
Left({@Print Ops},Instr({@Print Ops}," ")-1)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.