Skip to Content
avatar image
Former Member

Group by Data in Report Footer

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 31, 2017 at 10:35 AM

    Hi Scott,

    Could you post the code in both the formulae please?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2017 at 11:07 AM

    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)
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2017 at 11:15 AM

    Hi Scott,

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2017 at 10:18 AM

    Hi Scott,

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded