Focal Point
[SOLVED] Stacking/Combining Columns

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

October 20, 2017, 05:03 PM
Kevin Patterson
[SOLVED] Stacking/Combining Columns
I'd like to print two columns together in the space of one column. In my real world example it's the post date and purchase date on a purchase card report. So it would look like:
|Card | Purchase/ | Amt   | ETC
|     | Post Date |       |
|1234 | 10/1/2017 | 33.01 | etc
|     | 10/3/2017 |       |
|3425 | 10/2/2017 | 26.71 | etc
|     | 10/5/2017 |       |
  


I guess for the CAR example it could be something like:
  
|Region | Make/  | Sales
|       | Model  |
|SE     | Ford   | 120,000
|       | Fiesta |
|SE     | Mazda  | 133,000
|       | Miada  |




I'm pretty sure I've seen this done before, but I cannot find the right terms to look it up in the Help documents.

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


Kevin Patterson
Appalachian State University
WebFOCUS 7.7.03
Windows, All Outputs
October 20, 2017, 06:37 PM
FP Mod Chuck
Hi Kevin

Try this...

TABLE FILE CAR
PRINT 
     CAR.COMP.CAR AS '' OVER 
     CAR.CARREC.MODEL AS ''
     CAR.BODY.SALES AS ''
BY  CAR.ORIGIN.COUNTRY AS ''
HEADING
"Country<+0>Car/Model<+0>Sales<+0> "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=HEADING,
     HEADALIGN=BODY,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=4,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
ENDSTYLE
END



Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 23, 2017, 04:36 PM
Kevin Patterson
Thank you that was what I was looking for! I'm still having some trouble with my heading... probably because I have a compute field I'm using in the footer that I'm not printing out... but that's a different issue.


Kevin Patterson
Appalachian State University
WebFOCUS 7.7.03
Windows, All Outputs