I would like to create a report using MySQL queries I have already written.
I have added the queries to the report and the "Data Source" looks like this:
Then, I drag-and-drop each query to create a table with its items, and that is how the report looks like:
What I expect to be displayed in the "Preview" tab is two different tables, one showing number of users created per group, and one number of users logged in per group.
The problem is, it seems that each time only one query can be active: on the first try, only the first query is active. We see all groups A-D with their corresponding count, but results of the second query don't seem right; they are just a repetition of the first row.
If I set the second query as the active query, the opposite happens (please check the picture).
How can I have the results of both queries displayed correctly at the same report?
Data Report with several different queries
Re: Data Report with several different queries
We will review this post and will answer you as soon as possible.
Re: Data Report with several different queries
With the Data Report feature, It's not possible to make a report that is based on two or more queries containing not related tables.
The Data Report feature is built using the DevExpress component https://documentation.devexpress.com/Xt ... ar-Reports
The Data Report feature is built using the DevExpress component https://documentation.devexpress.com/Xt ... ar-Reports