Focal Point
[SOLVED] I need a help on adding column heading based on column name.

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6947066686

June 09, 2017, 03:04 PM
RaviD
[SOLVED] I need a help on adding column heading based on column name.
I have to display below columns in the report and based on column name I need to add a heading on top of the column names. What is the best way to achieve this design. Any suggestion will be appreciated.


Report Mockup:


Spread Performance Business Value KPI

Spread Forecast Diff PYEH Diff from PYEH Start Terms
12 10 2 13 1 2 1

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports
June 09, 2017, 03:29 PM
MartinY
RaviD,
Remember to use the code tag
</>

Spread Performance Business Value KPI

Spread Forecast Diff PYEH Diff from PYEH Start Terms
    12       10    2   13              1     2     1

to have sample properly aligned.


Why would you
quote:
based on column name I need to add a heading on top of the column names
?

If your displayed column's may change, you should have something (a selection made by the user per example) to have them changed, use the same trigger/selection to select and display the corresponding heading.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
June 09, 2017, 03:37 PM
RaviD
Sorry for that. Thanks Martin for your reply!

My columns are fixed. i have to generate the Excel report and send it to user.


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports
June 09, 2017, 03:45 PM
MartinY
Ok....
So what is the issue ?
What is your real question ?


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
June 09, 2017, 04:33 PM
RaviD
The question is how we can group the columns (then i need to provide heading on top of column titles) based on column title? I am not clear on your first reply?


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports
June 12, 2017, 02:12 AM
Dave
Something like this?

TABLE FILE CAR
	SUM SALES		AS 'Sales'
		MIN.SEATS 	AS 'MN Seats'
		MAX.SEATS	AS 'MX Seats'
		CNT.DST.CAR AS 'Cars'
	BY	COUNTRY		
HEADING
"countries<+0>Sales stuff<+0>Seats stuff<+0>Cars"
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=HEADING,
     HEADALIGN=BODY,
$
TYPE=HEADING,
     LINE=1,OBJECT=TEXT,ITEM=2,COLSPAN=1,
$
TYPE=HEADING,
     LINE=1,OBJECT=TEXT,ITEM=3,COLSPAN=2,
$
ENDSTYLE
END



_____________________
WF: 8.0.0.9 > going 8.2.0.5
June 12, 2017, 09:20 AM
Msondra
Do you want to make groupings of columns and put a heading above the grouping?


WebFOCUS 8.1.05
Windows, All Outputs
June 14, 2017, 11:11 AM
RaviD
Thanks Dave. this helped us a lot.

now issues is resolved.


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports