Focal Point
[CLOSED] how to change the column title dynamically

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

October 24, 2013, 05:53 AM
santu
[CLOSED] how to change the column title dynamically
I am using below car example. I am displaying each type of car details in each page. Now i wanted to display car name as title for Sales column.

Present table column titles are displaying as below.

COUNTRY CAR SEATS DEALER_COST RETAIL_COST SALES

If car name is "Jaguar" then i need to display like below.

COUNTRY CAR SEATS DEALER_COST RETAIL_COST JAGUAR


 
TABLE FILE CAR
PRINT 
     CAR.BODY.SEATS
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
 ON CAR.COMP.CAR PAGE-BREAK
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBFOOT,
     FONT='TIMES NEW ROMAN',
     SIZE=9,
     STYLE=BOLD,
     HEADALIGN=BODY,
$
ENDSTYLE
END 
 



can you please help with this?

This message has been edited. Last edited by: santu,


Web FOCUS 7.7.03
PDF
October 24, 2013, 09:26 AM
Francis Mariani
Maybe here ...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 24, 2013, 04:22 PM
Noreen Redden
Literally I was just talking to Product Management that I always wanted this feature, but it can't be currently done easily (Francis pointed you to some ideas, but they all basically involve doing SUBHEADS instead of column headings. It is almost like a CAPTION, but there are all kinds of rules that would have to be in place (as you said, if it is based on CAR, then there has to be a PAGE-BREAK on CAR. Please open a request for a new feature through INFORESPONSE ONLINE, so I have real customer requests. and business cases. I'll add mine: I came from the insurance industry, and thought that different policy holders might call the same thing by different names, so if I were producing a report bursted on policy holder I could use the name they used.


WEFOCUS - All releases starting at 4.3.6
MF FOCUS -- All releases starting at 3.8.68
OS/Platfor _ Predominately Z/OS, but all others as swell
Expected Output Format -- *
October 25, 2013, 01:39 AM
Danny-SRL
Santu,

Maybe this: Change Title on PAGE-BREAK


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

October 25, 2013, 09:10 AM
santu
Thank you for all of your ideas....

Danny -SRL : I followed your logic.

Thank you very much to all.


Web FOCUS 7.7.03
PDF