Hi Folks - I spent some time with Servoy’s Jasper video tutorials yesterday and really like the plugin’s abilities. I know the latest plugin now has the ability to use a foundset for population of the report - great step forward!
Are there any tutorials on that latest version of the plugin (documents or video)? I saw Jason’s webinar on the plugin some time ago - but that was based around a utility he had written - not generally available - and therefore the tutorial seems to have little to do with the day to day application of the ‘bare bone’ plugin (appologies to Jason if I miss construed that)?
To use a value directly from the foundset, the name of the field must match the dataprovider name. Example: customerid
To use a value from a related foundset, use the name of the relation, then the name of the dataprovider in the related foundset. Example:customers_to_orders.orderdate
To create a subreport or list of values, create a field with the related foundset as the name. So if I were creating a list of orders for a customer, and the report is based on a customer foundset, add a field named customers_to_orders. When specifying the data for the list or subreport, just refer to the field. Any fields now on the subreport or list will now be reference to an orders foundset, so fields will be named accordingly.
One thing to watch is that the Java data types for each field are set correctly; unlike Servoy, Jasper Reports cares if you try to send an integer to a string field.
The utility I presented was created just to make the process easier (eliminate misspellings and easily apply data types for Jasper Reports fields). It is not necessary to create a Jasper Report based on a foundset, just makes it more efficient and easier.