Hi Servoy,
We have a need to create reports where the main report is based on a foundset or dataset but then it has sub-report(s) which need to use SQL query. To do this, the main report must have a
Currently, there is no way to provide both - a foundset/dataset AND a database connection at the same time to the reports via the Servoy Jasper Plugin.
How can we achieve the functionality which we need? Is this technically possible considering that foundset-based reports run always on the client and SQL-based reports run always on the server?