Foundset-based report with SQL-based sub-report

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Foundset-based report with SQL-based sub-report

Postby rossent » 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?
Rossen Totev
Argos Software
rossent
 
Posts: 288
Joined: Wed Dec 31, 2008 2:03 pm

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

Postby Gordon McLean » Thu Mar 27, 2014 9:26 am

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
Gordon McLean
Clickdigital.com
Gordon McLean
 
Posts: 191
Joined: Wed Aug 03, 2005 12:24 pm
Location: UK


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 3 guests