Foundset-based report with SQL-based sub-report
Posted: Wed Mar 26, 2014 4:14 pm
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?
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?