Dot walking in Reporting

[anirban300]

Hello Everyone,

I want to create a report on "sc_req_item" table. The catalog item contains valiables which is referencing to the "sys_user" table. I want to show few columns from the user table(variable field).

I am not able to dot walk the variables. Can someone tell me how can we includes the sys_user data from the variables?

Regards

Anirban

[Monika13]

Hi

Pls follow below screenshot: find Variables field > Click on + 

Once you click on + New window will open with list of Items and variable.

Select item you want, you will get list of variables for that item in Available section shown in Above screen shot. Then you can move those variables to selected section

[anirban300]

Hi Monika,

Thank you for your response. But I want to dot walk data inside the variable i.e. my variable is referring to user table and I want to show user table data from the variable in the report.

Regards

Anirban

[Mark Guldhammer]

Hi

What datatype is the field you are trying to dot walk?