Skip to Content
avatar image
Former Member

Report with multiple columns under same group header

I want to prepare a report which looks like the following

from a database like

The way i aproach is i create a group header listing out the OBJNAME in specified order like"BSS1_LTA, on" Now i want to filter ou PHASE A , B,C winding temp in 3 columns from OBJID or OBJPATHNAME and display the maximum value in 3 colums.. I HAve tried placing different formulas at 3 columns , but i am not getting the expected results.. This is the sample report i have created.

this is athe sample formula I have written for LT _Voltage_Phase_A


Please Help me solve this issue

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 05, 2018 at 11:30 AM

    Not familiar with your data, but I would group by seqNo. -suppress header

    Then create formulas as below for each Phase and add to details, Suppress detail section

    if {S2KVTQ_VTQTimeView.OBJPATHNAME} like


    Then add maximum summary to this formula in seqNo group footer.


    Add comment
    10|10000 characters needed characters exceeded