create a report of 2 different tables from a database view

[Arjun Reddy Yer]

As I'm trying to create a report from 2 different tables in which I had created a database view in which I had combined 2 tables but I'm unable to get the report. 

In the below screenshot from a catalog item I'm trying to full the marked data in the report

For this I had created a Database View as mentioned in the below screen shot

And I had added fields to the tables to get the data to display in the report but I'm unable to get the report of marked one in 1st screen shot of catalog item

can any one help me @Ankur Bawiskar @Gunjan Kiratkar @Mohith Devatte @Aman Kumar S @Chuck Tomasi @asifnoor @Anil Lande @Jaspal Singh 

[Ankur Bawiskar]

@Arjun Reddy Yer 

data you want to get is for MRVS variable

the where clause should be like this

multi_parent_id=screq_sys_id

[Arjun Reddy Yer]

but still unable to get the report of MRVS variable @Ankur Bawiskar @Gunjan Kiratkar @Mohith Devatte @Aman Kumar S @Chuck Tomasi @asifnoor @Anil Lande @Jaspal Singh 

Can I know the fields that are selected for the tables are correct or is there any changes required

Below mentoned screen shot error I'm getting in the report

[Aman Kumar S]

Hi @Arjun Reddy Yer ,

With current design, reporting is not supported for multi-row variables set. This limitation is also documented here:
https://docs.servicenow.com/csh?topicname=c_ServiceCatalogVariableSets.html&version=latest