Focal Point
[SOLVED] Joining multiple values into one column (mailing address)

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

June 11, 2009, 02:20 PM
BDAVIS
[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|'
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