How to create a report on variable set

[jparman]

I have a table called sn_sm_finance_request that extends sm_order table that extends task table.

I need to include the variables on the list as columns specifically the vendor details and request details so that the user can filter /search the list based on vendor name, vendor code etc.

Is there a way i can do this? Is it possible for me to create a report that can give me the list i need.

This is the variable set that we used.

[Kusuma2 · Accepted solution]

Hi Joni,

Inorder to pull the report of the variables ,You   need to select the table --->variable[+]---------->and then click on the +   button and select the variables on which you need to generate a report.

Regards,

AJAY.

[A Amrin Banu]

Hello Kusuma,

I tried following select the table --->variable[+], this would give me the catalog item fields but not showing up the variable set fields. Could you please confirm how to check for Variable set fields?? 

[Alikutty A]

Hi,

You might have to create a database view, Are these variables in a record producer?

Database views

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response