Report creation for variable set

[SHUBHAM78]

I have created one report to fetch the details of one catalogue item, now I am trying to fetch the variable set(multi row) details in that report but not able to do so. I try creating database view but it didn't work. Maybe the database is not 100% correct.

I want to fetch the details of variable set values in the report for this item how can we built  this report. Kindly suggest

[RaghavSh]

can you share the report?

[Ankur Bawiskar]

@SHUBHAM78 

data for MRVS is stored in other table

you will have to use that table as well when you create a database view

this link has approach shared by Kevin133 in 2020

how do report on multi row variable set 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@SHUBHAM78 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@SHUBHAM78 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[SHUBHAM78]

Hi @Ankur Bawiskar 
As it is not coming for reference filed data, it is showing sys id of that particular filed and for other two type is Date so for that it is showing. I have added one more table to convert the sys ID to display value