cancel
Showing results for 
Search instead for 
Did you mean: 

Group by Data in Report Footer

scott_selph
Participant
0 Kudos
135

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.

View Entire Topic
scott_selph
Participant
0 Kudos

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)