Creation of report from Database and Process report?

Question

Hi Team, 
 Is it possible to create a report which gets data from database and a process report at same time? 
 I want to create a report that should take data from database and a process report simultaneously.

Sandeep Deshmukh · Answer

Yes, it is possible. you need to first create a Process report and call that process report to an Interface with a!queryProcessAnalytics() function, store it in a datasubset local variable. From database create a data store entity to fetch data from DB and in same interface call a!queryEntity() function (it is good if you can use create same number of columns) and again save this into another local datasubset variable. Now with the help of merge() function, merge these 2 local datasubset and store it into a third Datasubset. and display this newly created datasubset in Grid for Report.