Display Value of a Referenced List in a report

[Daryll Conway]

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.

[Harish KM]

Hi,

Try making display value true for reference field.only one display value can be made true.

[Daryll Conway]

I have the CI Name field set as display true on the cmdb_ci table but I get nothing in a report. Is there a way to make a referenced list field open up the 'show related fields' option in a report. It's almost like it's not seeing it as a reference field just as the entry on the form it comes from (Change_request in this case)

[Pradeep Sharma]

Hi Daryll,

I am not able to reproduce this issue at my end. However you can click on the + icon to dot-walking in the reference table fields.

Please find the screenshot attached for reference.

[Daryll Conway]

My list (reference) above "Affected Item List" doesn't have a plus next to it. I'm wondering if this is possible with a reference field that is a list?