How to extract a report on RITM/REQTASK table, along with it's multi-row variable set values?

[AbdurRahmanSnow]

Good afternoon.!
I have an RITM/REQTASK where it contains a multi-row variable set value. How can we achieve it to have one single report that fetches this value, along with the normal variables.
Please help.!

@Ankur Bawiskar @Dr Atul G- LNG @Viraj Hudlikar 

[Ankur Bawiskar · Accepted solution]

@AbdurRahmanSnow 

you can't combine both as normal variables are stored in different table than MRVS variables

Either you have RITM + Normal Variables by join using database views

OR

You have RITM + MRVS Variables by join using database views

Reporting on MVRS along with other Variables 

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

[AbdurRahmanSnow]

Hi @Ankur Bawiskar 
I see, no problem. I will convey this to the user. Thanks a lot for always helping me. Really appreciate it.

[Dr Atul G- LNG]

It’s not possible, mate. Since it’s an MRVS with multiple rows, it’s not easy to handle. Implementing it through scripting would introduce technical debt, so it’s better to avoid that approach.