[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,
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 -- *