0

# Group by Data in Report Footer

Oct 31, 2017 at 10:22 AM

27

Former Member

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.

crimage.jpg (846.9 kB)

Abhilash Kumar
Oct 31, 2017 at 10:35 AM
0

Hi Scott,

Could you post the code in both the formulae please?

-Abhilash

Share
Former Member Oct 31, 2017 at 11:07 AM
0

I also included the "Load JobOPs" to show what the PrintOPs is passed.

```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)`
Share
Abhilash Kumar
Oct 31, 2017 at 11:15 AM
0

Hi Scott,

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

-Abhilash

Show 2 Share
Former Member

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

Former Member

Abhilash Kumar, could the report be modified to allow sorting on the CurrentOP?

Abhilash Kumar
Dec 11, 2017 at 10:18 AM
0

Hi Scott,

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

-Abhilash

Share