Getting Visible Values from Combobox in Reporting

[gatsby]

Hello everyone,



i have a combobox with with 5 records in it. what i want to do is to preview a report and get visible values from the combobox because whenever i click Preview Report what appears are the hidden values.

Attached photos for your reference.

in the photos, what i want to appear in the reporting is either BQ, CUR, PO, BQ, EST, and ALL. my problem starts whenever i clicked Preview Report, what it appears is the hidden values or the 1st values from the Table :


Rate ID (HIDDEN; 1st column ; values are 1, 2, 3, 4, 5) ;

Rate Basis Field (VISIBLE ; 2nd column; values are BQ, CUR, PO, BQ, EST, ALL) - this is what i want to appear

Thanks!

[June7]

Include the table that has the descriptive values in the report RecordSource by joining on the ID fields.

The alternative is to save the descriptive values instead of the numeric ID, which is what I would do with such short descriptors.

[gatsby]

okay i got this.... what i did, instead of 1, 2, 3, 4, 5 (first column) i changed that to the same values in the 2nd column (BQ, CUR, PO, BQ, EST, and ALL).... in short, first column and second column in the Table have the same values and it gave me the correct reporting.

thanks.