Skip to Content
0

Report with multiple columns under same group header

Feb 02 at 07:31 AM

21

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Feb 05 at 11:30 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded