Skip to Content
0

Group by Data in Report Footer

Oct 31, 2017 at 10:22 AM

27

avatar image
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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

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

Hi Scott,

Could you post the code in both the formulae please?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 31, 2017 at 11:07 AM
0

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)
Share
10 |10000 characters needed characters left characters exceeded
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
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
Former Member

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

0
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
10 |10000 characters needed characters left characters exceeded