How to build visulization using multiple source

[pramn]

Hi Mates, 

I'd like to build a report showing all open PC orders in our business. I used data source 'requested item'. However, there is no 'business' field in that source. So that I got a report with all open orders across . I tried to add another data source but found the 'add data source' button is grey. Pls advise how to build the report as I described.

Thanks for your help

[Dr Atul G- LNG]

No mate, 

“You need to create the Database View first, and then you can do the reporting.”

[Tanushree Maiti · Accepted solution]

Hi @pramn 

Because the Business data is stored on a different table than the Requested Item, you need to utilize a Database View to combine the information.

To track exactly which PC models are on order by individual users or departments, combine the sc_req_item (Requested Item) table  with sc_task (Catalog Task) tables and user table 

Or

at least  combine sc_task (Catalog Task) tables and user table .

then create report on that database view.