Focal Point
[SOLVED] How to Display 2 Lines Data in One Row in WF

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

December 28, 2016, 11:45 PM
S.G
[SOLVED] How to Display 2 Lines Data in One Row in WF
Hello,

We have a requirement to display 3 fields in one row in report. One field is displayed in the left side, and 2 fields which are came in two lines in the right.
Like this:  
  B
A
  C


Is there a way to do that ? Thanks.

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


WebFOCUS 8105
Windows, All Outputs
December 29, 2016, 02:11 AM
Avinash
Hi,

Can you please tell us that these 3 items in 3 rows of one columns or one row of three columns.


Thanks!
@vi

WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs
December 29, 2016, 03:28 AM
S.G
Hi Avinash,

I'm sorry that I cannot draw them in correct position here.

To simplify, B and C are merged in two lines, then merge them to A. So these 3 items are displayed in one row of one column.


WebFOCUS 8105
Windows, All Outputs
December 29, 2016, 04:38 AM
Maran
Hi S.G,

can you tell us more detail? you want to display column B+C+A as single column..?


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
December 29, 2016, 05:36 AM
S.G
Hi Maran,

Just to mosaic these 3 items to single column.The display value is not changed.


WebFOCUS 8105
Windows, All Outputs
December 29, 2016, 06:23 AM
Avinash
If A,B,C are columns then you can concatenate in a defined column.


Thanks!
@vi

WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs
December 29, 2016, 06:39 AM
Maran
Hi S.G,

You want output like this...?
  
+--------------+------------+-----------+---------------------+
|CURR_JOBCODE  | FIRST_NAME | LAST_NAME | EMP_NAME_WITH_JCOD  | 
+--------------+------------+-----------+---------------------+
| A07          | ALFRED     | STEVENS   | ALFRED STEVENS A07  | 
+--------------+------------+-----------+---------------------+
| B14          | MARY       | SMITH     | MARY SMITH B14      |  
+--------------+------------+-----------+---------------------+
| B03          | DIANE      | JONES     | DIANE JONES B03     |
+--------------+------------+-----------+---------------------+
| A01          | RICHARD    | SMITH     | RICHARD SMITH  A01  |  
+--------------+------------+-----------+---------------------+



WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
December 29, 2016, 08:51 AM
Danny-SRL
SG,

Try this:
  
-* File SG4.fex
TABLE FILE CAR
PRINT
     BODYTYPE AS '' OVER 
     DEALER_COST AS '' OVER 
     RETAIL_COST AS ''
BY  LOWEST COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET BYDISPLAY ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     PAGESIZE='A4', BORDER=LIGHT,
$
TYPE=DATA, BACKCOLOR=WHITE,
$
TYPE=DATA,
     COLUMN=N5,
     JUSTIFY=LEFT,
$
TYPE=DATA,
     COLUMN=N6,
     JUSTIFY=RIGHT,
$
TYPE=DATA,
     COLUMN=N4,
     JUSTIFY=RIGHT,
$
ENDSTYLE
END



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

December 29, 2016, 10:10 AM
Danny-SRL
You could also use the Alignment Grid and display everything in a SUBHEAD:
  
TABLE FILE CAR
PRINT 
     CAR.BODY.BODYTYPE NOPRINT 
     CAR.BODY.DEALER_COST NOPRINT 
     CAR.BODY.RETAIL_COST NOPRINT 
BY  LOWEST CAR.ORIGIN.COUNTRY NOPRINT 
BY  CAR.COMP.CAR NOPRINT 
BY  CAR.CARREC.MODEL NOPRINT 
     
ON CAR.CARREC.MODEL SUBHEAD
" <+0> <+0> <+0> <BODYTYPE"
"<COUNTRY<CAR<MODEL<DEALER_COST"
" <+0> <+0> <+0> <RETAIL_COST"
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE SET BYDISPLAY ON 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     PAGESIZE='A4',
$
TYPE=REPORT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='WHITE',
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='WHITE',
     BACKCOLOR='NONE',
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=.889,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=2.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     JUSTIFY=RIGHT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=.889,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=2.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=4,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=.889,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=2.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=FIELD,
     ITEM=1,
     JUSTIFY=RIGHT,
     WIDTH=1.000,
$
ENDSTYLE
END



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

January 04, 2017, 12:35 AM
S.G
Hi Maran,

Thanks your reply!

For column EMP_NAME_WTTH_JCOD,its data is correct, but the display position is not what i want.
 
Below is an example:
___________________________________________________
             |             Field B    |
Other column |     Field A            | Other column
             |             Field C    | 
---------------------------------------------------



quote:
Originally posted by Maran:
Hi S.G,

You want output like this...?
  
+--------------+------------+-----------+---------------------+
|CURR_JOBCODE  | FIRST_NAME | LAST_NAME | EMP_NAME_WITH_JCOD  | 
+--------------+------------+-----------+---------------------+
| A07          | ALFRED     | STEVENS   | ALFRED STEVENS A07  | 
+--------------+------------+-----------+---------------------+
| B14          | MARY       | SMITH     | MARY SMITH B14      |  
+--------------+------------+-----------+---------------------+
| B03          | DIANE      | JONES     | DIANE JONES B03     |
+--------------+------------+-----------+---------------------+
| A01          | RICHARD    | SMITH     | RICHARD SMITH  A01  |  
+--------------+------------+-----------+---------------------+

This message has been edited. Last edited by: S.G,


WebFOCUS 8105
Windows, All Outputs
January 04, 2017, 03:01 AM
Neelima
Hi,

Can you please try this

 DEFINE FILE CAR
AA/A200='<P align=left>'||'ABC'||'</P><P align=right>'||'XYZ'||'</P> <P align=left>'||'PQR'||'</P>';
END
TABLE FILE CAR
PRINT 
     AA
BY  CAR.COMP.CAR
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     PAGESIZE='A4',
$
TYPE=REPORT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='WHITE',
$
TYPE=DATA,
     COLUMN=N1,
     BACKCOLOR='NONE',
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N1,
     JUSTIFY=CENTER,
$
ENDSTYLE
END



WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
January 04, 2017, 03:59 AM
S.G
Hi Daniel,

Thanks your suggestion!

I have tried and it work. However there is still a issue for display position.
 
For your code, below is an example:
____________________________________________________________
|            |           |                BODYTYPE         |
|COUNTRY     |CAR        |     DEALER_COST                 | 
|            |           |                RETAIL_COST      | 
------------------------------------------------------------


quote:
Originally posted by Danny-SRL:
SG,

Try this:
  
-* File SG4.fex
TABLE FILE CAR
PRINT
     BODYTYPE AS '' OVER 
     DEALER_COST AS '' OVER 
     RETAIL_COST AS ''
BY  LOWEST COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET BYDISPLAY ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     PAGESIZE='A4', BORDER=LIGHT,
$
TYPE=DATA, BACKCOLOR=WHITE,
$
TYPE=DATA,
     COLUMN=N5,
     JUSTIFY=LEFT,
$
TYPE=DATA,
     COLUMN=N6,
     JUSTIFY=RIGHT,
$
TYPE=DATA,
     COLUMN=N4,
     JUSTIFY=RIGHT,
$
ENDSTYLE
END



WebFOCUS 8105
Windows, All Outputs
January 05, 2017, 12:41 AM
S.G
Hi Neelima,

Thanks your method!

I try this and find it doesn't work for PDF output format. Besides these 3 items is not only left-aligned or right-aligned. They are similar displayed in center.

Below is a example:
 
____________________________________________________________
| column 1  |         column 2        |       column 3     |
|___________|_________________________|____________________|
|           |             abc         |                    |
| 1         |         XYZ             |        10.00       |
|           |             pqr         |                    |
------------------------------------------------------------
|           |             a           |                    |
| 2         |          XX             |        20.00       |
|           |             sdef        |                    |
------------------------------------------------------------


quote:
Originally posted by Neelima:
Hi,

Can you please try this

 DEFINE FILE CAR
AA/A200='<P align=left>'||'ABC'||'</P><P align=right>'||'XYZ'||'</P> <P align=left>'||'PQR'||'</P>';
END
TABLE FILE CAR
PRINT 
     AA
BY  CAR.COMP.CAR
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     PAGESIZE='A4',
$
TYPE=REPORT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='WHITE',
$
TYPE=DATA,
     COLUMN=N1,
     BACKCOLOR='NONE',
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N1,
     JUSTIFY=CENTER,
$
ENDSTYLE
END



WebFOCUS 8105
Windows, All Outputs
January 06, 2017, 01:24 AM
Danny-SRL
Hi SG,

What do you mean by:
quote:
However there is still a issue for display position.



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

January 06, 2017, 11:56 AM
S.G
Hi Daniel,

These 3 items(column 2) are not only left-aligned or right-aligned. They are similar displayed in center.

Below is a example. Is there a way can do this? Thanks in advance!
 
____________________________________________________________
| column 1  |         column 2        |       column 3     |
|___________|_________________________|____________________|
|           |             abc         |                    |
| 1         |         XYZ             |        10.00       |
|           |             pqr         |                    |
------------------------------------------------------------
|           |             a           |                    |
| 2         |          XX             |        20.00       |
|           |             sdef        |                    |
------------------------------------------------------------



quote:
Originally posted by Danny-SRL:
Hi SG,

What do you mean by:
quote:
However there is still a issue for display position.



WebFOCUS 8105
Windows, All Outputs
January 07, 2017, 02:18 PM
Danny-SRL
SG,

Looking at your example, it seems then that the fields on lines 1 and 3 are LEFT-aligned but spaced further than line 2 where the field is RIGHT-aligned.

I think that you should try my second solution, using SUBHEAD, which I tweaked a bit.
Notice that the numeric fields were converted to alpha in order to accomplish right-justifying.
 
-* File SG5.fex
DEFINE FILE CAR
ADCOST/A12=FPRINT(DEALER_COST, 'D6', 'A12');
ARCOST/A12=FPRINT(RETAIL_COST, 'D6', 'A12');
END
TABLE FILE CAR
PRINT
     CAR.BODY.BODYTYPE NOPRINT
     CAR.BODY.ADCOST NOPRINT
     CAR.BODY.ARCOST NOPRINT
BY  LOWEST CAR.ORIGIN.COUNTRY NOPRINT
BY  CAR.COMP.CAR NOPRINT
BY  CAR.CARREC.MODEL NOPRINT

ON CAR.CARREC.MODEL SUBHEAD
" <+0> <+0> <+0> <BODYTYPE"
"<COUNTRY<CAR<MODEL<ADCOST"
" <+0> <+0> <+0> <ARCOST"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     PAGESIZE='A4',
$
TYPE=REPORT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='WHITE',
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='WHITE',
     BACKCOLOR='NONE',
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=.889,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=2.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=TEXT,
     ITEM=4,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=.889,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=2.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=2,
     OBJECT=FIELD,
     ITEM=4,
     JUSTIFY=RIGHT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=.889,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=2.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=TEXT,
     ITEM=4,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=3,
     LINE=3,
     OBJECT=FIELD,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
ENDSTYLE
END



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