Hi all,

I have a sub-report with 5 groups.
One of the fields in the sub-report displays multiple values so I am using formulas to reset (Group Header), calculate (Details) and display (Group Footer).

Now I need to place a display formula in the group header but I cannot figure out where to place the initialization and calculation formulas.

My formulas are:
Init formula
Shared stringVar Department:=chr(13);

Calc formula
Shared stringVar Department;
if ({DATA_FIELDS.NAME}="Department")
    then
    (
        if (InStr(Department,chr(13)+{TYPE.NAME}+chr(13))=0)
            then Department:=Department+{TYPE.NAME}+chr(13)
    )
;

Display formula
Shared stringVar Department;
if (Department=chr(13))
    then ""
    else Right(Left(Department,Length(Department)-1),Length(Department)-2)
;

Any ideas would be highly appreciated,

Barry

I am trying to display the data in the GH of the subreport.

I will give it a try, thanks.

Edited by barry.ein - 22 Oct 2015 at 8:45am