Focal Point
[CLOSED] Multiple fields in listbox in HTML composer

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

October 27, 2010, 02:14 PM
JI
[CLOSED] Multiple fields in listbox in HTML composer
I'm working in the html composer and i'd like to be able to display more than one field in a list box for example: instead of just an item number, i'd like to have the item number and description display in a listbox/double listbox so the user can see both a number and description or a concatenation of the two fields? ie.
Item Num Desc
0000001 Example Item Desc
0000002 Example Item Desc
0000003 Example Item Desc
0000004 Example Item Desc
etc.

Is this allowed in the gui?

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


version 7.14
Windows and Unix servers
Mostly html, and some excel outputs
October 28, 2010, 03:21 AM
GamP
As far as I know this is only possible when you populate the listbox by means of a fex. Alternative is to have the field that you wish to display inserted into the data table.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
October 28, 2010, 03:55 AM
Alan B
Create a DEFINE in the MFD, concatenating the 2 fields for display.


Alan.
WF 7.705/8.007
October 28, 2010, 04:28 AM
Senthilvasan S
You can also create a embedded procedure, having define with the concatenation, possible to diaplay both "ID Description" in the same list box.


WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL
October 28, 2010, 05:40 AM
Ramkumar - Webfous
your procedure should be something like...

DEFINE FILE XXX
CIDNAME/A20 = EDIT(Item Num) || DESC;

TABLE FILE XXX
PRINT
CIDNAME
BY
ITEMNUM
ON TABLE PCHOLD FORMAT XML


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5