A Combo box or Radio button field is, that uses a Table as it’s data source, can be used to display more than one column of data in the report.
An example:
A Table with three columns is created:
•Employee ID
•First name
•Last name
A Combo box field, using on the newly created Table as it’s data source, is now added to the template.
If you do nothing further the Table will be displayed in the report as a list where you can pick the values entered in the Employee ID column of the Table.
When a selection has been made, you will also only see the selected Employee ID in the report.
By making further configurations to the field, you can make more Table columns visible in the report.
You could, for example, display both Employee ID and Last name.
You can also control which one of the columns in the Table that should be visible in the pick list.
How to do it:
•Open the report template See Edit Report Template
•Open the Fields tab
•Click on the field in question

•Click the Selectable button to change the column that should be visible in the pick list
•Click the Show button to make the column visible in the report
•Click the Hide button to hide a column in the report