[SOLVED] Joining multiple values into one column (mailing address)
In a report I am listing a mailing address. Instead of listing each column out like address_line_1, address_line_2, city, state, zip.. I would like to list them under one column.
Now, I know I could join them together in a define as something like: ADDRESS_JOINED/A300 = ADDRESS_LINE_1||ADDRESS_LINE_2|| and so on, but I need to add a return after each line. Something like ADDRESS_JOINED/A300 = ADDRESS_LINE_1|' 1 '|ADDRESS_LINE_2 ... and so on, but that doesn't do anything in the report.
Other than listing out formatting in a subhead, what can I do? is that my only option here?This message has been edited. Last edited by: BDAVIS,
WebFOCUS 7.6.3 | Solaris 10 | Excel, PDF
June 11, 2009, 03:03 PM
Francis Mariani
Have you tried A OVER B OVER C...?
What is your report output format?
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
June 11, 2009, 03:18 PM
BDAVIS
Yeah, I just ran across that in another thread. Thanks. That gets my data right but bumps my column heading to the left of my data, and how do I get a heading on my address data (without editing the style sheet preferably). I am still relatively new to WF as you can tell, so I appreciate any help.
PRINT SO_NUMBER AS 'So #' ADDRESS_LINE1 AS '' IN 20 OVER ADDRESS_LINE2 AS '' IN 20
Outputs like: So # 012345........123 Fakestreet ...................Suite B
But I need something like: So #..............Street Address 012345............123 Fakestreet ..................Suite B (Periods signify spacing)
This is in a PDF
WebFOCUS 7.6.3 | Solaris 10 | Excel, PDF
June 11, 2009, 03:29 PM
Francis Mariani
TABLE FILE CAR
PRINT
COMPUTE COLTITLE1/A20 = '#'; AS '' IN 1
COMPUTE COLTITLE2/A20 = 'ADDRESS'; IN 15 AS ''
OVER
COUNTRY AS '' IN 1
CAR AS '' IN 15
OVER
COMPUTE DUMMY1/A1 = ''; AS '' IN 1
MODEL AS '' IN 15
OVER
COMPUTE DUMMY2/A1 = ''; AS '' IN 1
BODYTYPE AS '' IN 15
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT
ON MODEL SUBHEAD
" "
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=ARIAL, SIZE=8, $
TYPE=DATA, COLUMN=COLTITLE1, STYLE=BOLD, $
TYPE=DATA, COLUMN=COLTITLE2, STYLE=BOLD, $
END
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