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, BSS1_LTB..so 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

if ("FACILITY_TRANSFORMER_2ND_PHASE_A_WINDING_TEMP" in {S2KVTQ_VTQTimeView.OBJPATHNAME}) then Maximum ({S2KVTQ_VTQTimeView.OBJVALUE},{S2KVTQ_VTQTimeView.OBJNAME})

Please Help me solve this issue

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 05 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

    "*FACILITY_TRANSFORMER_2ND_PHASE_A_WINDING_TEMP*" then {S2KVTQ_VTQTimeView.OBJVALUE} else 0

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

    Ian

    Add comment
    10|10000 characters needed characters exceeded