Page 1 of 1

Foundset-based report with SQL-based sub-report

PostPosted: Wed Mar 26, 2014 4:14 pm
by rossent
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?

Re: Foundset-based report with SQL-based sub-report

PostPosted: Thu Mar 27, 2014 9:26 am
by Gordon McLean
Have you considered using the Velocity Reports plugin ? this should be very achievable. You could produce your report and display this on screen either in smart or web client and offer the user the facility to run SQL queries. https://www.servoyforge.net/projects/velocity-report