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?

[bidya1]

Thank you. I was looking for this for editing the conditions in ACL. Works like charm

[Uncle Rob]

Are you on Fuji?   If so, try this...

EDIT:   Ahhh... I see the problem now.   The criteria builder makes you pick a variable, not a property of a variable (like the dot walked value of something the variable references).
I'm not sure how you'd pull this off.

Is there any reason you can't write the variable location to the Task's location field and run your logic off that?

[billi_lumley]

Thanks!   Do you know if you can dot walk using the columns for a list view?  

[Uncle Rob]

Doesn't look like it.

[billi_lumley]

Is there any reason you can't write the variable location to the Task's location field and run your logic off that?   - Yes that is what I'm thinking I will have to do but my concern is if any other varaibles are needed for reporting.   Thanks!!!