Contact's foreign fields become ID

[kenleegit]

Dear support,

I created a Memebership Detail report, include some Contact's fields. The fields are fine if they are contact's direct value fields. For fields that are referenced fields, I see only the ID values of the referenced table. For example, values in Contact Prefix are all 1,2,3,4 (which stands for Mr., Mrs., etc.) Country columns are all 1228, 1098, State column are all 1016, ....etc. Fields that are of values look good, eg. First, name, address, etc. This problem does not occur if I view records on screen or print to printer.

Thanks for your help.

[masetto]

I have the same problem: why integer ids is not translated to human-readable values? What are problems reported in row 120 of civiexportexcel.php?:

// This seems to cause more problems than it fixes.
//$form->formatDisplay($rows); 

I tried to remove this line and it seems to work correctly.