we are evaluating Flexmonster right now and came up with an important question. Is it possible to combine datasources in one report?
Let me explain the use case.
In our database we have an object users, who just use our system. Then users can have tasks (one to many) and users can also have reservations (also one to many) (there are many other objects, just for the example now)
I was thinking to create 3 different data sources for
But in reports we also would like to show users and its tasks (either aggregated or not), or users with tasks and reservations (for example list of users with number of open tasks, and number of open reservations).
So the question really is, is it possible to use in one reports 2 (or more) data sources, so that i can show for example the users and its tasks?
Thank you for writing to us.
Flexmonster works with one data set at a time. For such cases, we recommend combining the data set outside of Flexmonster (for example, on your server) and passing the combined data set to Flexmonster.
Here is a JSFiddle for illustration: https://jsfiddle.net/flexmonster/jv1wqckf/.
In the example, users and their orders are combined in one data set and passed to Flexmonster. Flexmonster processes the data and builds all the necessary relationships between the data points. Once the data is loaded in Flexmonster, you can select the desired fields (through Flexmonster’s UI in the Field List or programmatically by configuring the slice object) and create different reports.
This way, in your scenario, you can show both users and their tasks in one report.
Please let us know if any additional questions arise.
Yes thanks, we did this know and create all the different combinations of data sources. But one more question. So we have now the different data sources, but now we also many different customers. And we dont want to filter the data on the frontend. Is it possible to filter the data sources somehow in the flexmonster data server using specific customerIds?
For example, we have a data source Users. In that data source is a field customerId. Now when someone from the customer with the Id = 10 wants to create a new report with the Users data source, the data should get filters to only able to see the data for customerId = 10. Is that possible to do with the data server?
Thank you for your reply.
Yes, it is possible to filter the data with Flexmonster Data Server by using it as a DLL.
Using the Flexmonster Data Server as a DLL allows extending the Flexmonster Data Server functionality and adding additional features, such as a server filter. Here is a detailed tutorial for guidance: https://www.flexmonster.com/doc/implementing-server-filter/.
Please let us know if this works fine for you.
Looking forward to your reply.
Hello Vera, thanks a lot for you answer. We will look into that.