I have a report that works off of a filtered query. Everything works correctly on the report except a field shows the ID value rather than the value of the record. The query that brings the data in shows the correct value in the field. How do I fix?
Example in the report:
doc number description rev type
123 test doc A 1 (type should be Instructions)