Display Value of a Referenced List in a report

Daryll Conway
Giga Guru

‎05-18-2015 04:22 AM

I have a list on my form which is a reference to the cmdb_ci table.

When viewing on the form I have no problem the sys_id in the field is converted to the display value (name).

However when users look for the CI Name in a report they find nothing.

If I use the sys_id in the report I find what I was expecting but this isn't very user friendly.

Can anyone tell me how I can get the report to search for the CI name rather than the sys_id?

I can't get 'show related field' in the report to show the referenced fields it just shows as the single field on the form with no drill down to the related table.

0 Helpfuls
  • 3,185 Views
15 REPLIES 15

Daryll Conway
Giga Guru
In response to randrews

‎05-18-2015 08:56 AM

Thanks Doug just checked and I only have one field set to Display = true.


My issue is not with the display on the form (that works fine) my problem is with adding a filter for the CI Name in a report.


It won't find the CI name (which is displayed on the form) only when you search by the sys_id is it found.


Have you managed to filter list references in a report in this way?


0 Helpfuls