dlclark wrote:Omar,
Yes, been there and reviewed webinar several times. It does not provide any information on how to access FOUNDSETS within JASPERSOFT REPORTS.
I am thinking there must be an either an XML file that gets generated somehow or a JAR that I need to reference in Servoy. Just guessing though...
I have been able to create the dataset using a direct connect to the MYSQL database and creating a query for the data I need.
But, FOUNDSETS seem so much more of an ELEGANT solution. (Hate to constantly reinvent the wheel here....)
Daryl
Hi Daryl,
JasperSoft does not have any knowledge of Servoy internals such as foundsets. It is the JasperSoft plugin (written by Servoy developers) that negotiates between Servoy and the JasperSoft engine. This plugin is loaded into Servoy and operates in only 1 direction, from Servoy to JasperSoft.
So you have two options:
1. Access the database you are using from JasperSoft directly without using foundsets (old style)
2. Or you can simply define the needed fields in your report (including fields through relations) and trust on the plugin to map your Foundset data to those fields (new style)