Group by Data in Report Footer

[scott_selph]

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.

[abhilash_kumar]

Hi Scott,

CurrentOp refers to PrintOps which itself is a Printtime formula. So both can't be used to Sort or Group.

-Abhilash

[abhilash_kumar]

Hi Scott,

You cannot group on the CurrentOP formula as it refers to other Print Time functions.

-Abhilash

[scott_selph]

Is there another method to group by the first op contained within the PrintOPs?

[scott_selph]

abhilash.kumar, could the report be modified to allow sorting on the CurrentOP?

[scott_selph]

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)

[abhilash_kumar]

Hi Scott,

Could you post the code in both the formulae please?

-Abhilash