Is it possible to dot-walk using a reference variable in a report?

[billi_lumley]

Is it possible to dot-walk using a reference variable in a report?   I've tried using reports that point to a database view (sc_task and sc_option_item_mtom tables), a variable log report and sc_request_item however cannot see how to dot-walk using a reference variable that points to the location table so that I can pull additional location information.   What am I missing?

[Steve McCarty]

If you are trying to dot-walk to build conditions for your report you may have to scroll to the very bottom of the field selector and click "Show Related Fields".   Once you do that reference fields should show twice in the drop down (once with just the name and once with an arrow pointing to the reference table) just like they do in other condition builders.

If you are building a list view, the reference fields should be highlighted and have a plus sign after the field name.   If you select the reference field and click the plus in between the Available and Selected boxes it will expand the reference field and let you add items from the reference table to your list report.

-Steve

[billi_lumley]

Tried that and still no good.   I can dot walk from the Requested Item, but not any of the reference variables.

Location Building and others in this image are reference variables.

[Steve McCarty]

That's strange... I use dot walking in a number of reports.   I definitely haven't seen where it would dot-walk on some fields and not others.   Can you pull up a list view of that table and create a filter from there that lets you dot walk through the fields you need?   If you can create the filter you want from a list view you can right click on a column header and choose "Bar chart" or "Pie chart" from the drop down list.   That will create a report with the filter you selected and then you can change the type to List and it should keep the filter the way you want it.

[billi_lumley]

I think it is important to note that these are service catalog variables, not form fields.