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.

[Daryll Conway]

I'm on Dublin patch 7 btw

[Anurag Tripathi]

the + will appear when u single click on a reference field on the slush bucket.

[Daryll Conway]

It doesn't. Can you tell me if you are using a list that is a reference or just a reference field in your example.

Looking at other lists fields (that are references to other tables) in my instance, none of them have this plus (to drill into the referenced table). So by the looks of it, this functionality is not possible on reference list fields at least not in Dublin.

[Daryll Conway]

As you can see this field doesn't show a drill down to the referenced table...