Hi,
Is there a way to design reports using directly the foundset blueprints? Or do we have a designer that has the capability of adding fields in various relations and including the complete databaseproviderid path to the jrxml file?
Erik,
That does not exist (yet) unfortunately.
This could probably be built by creating a plugin for ireport that queries a solution to find the data providers (via the rest-ws plugin maybe?).
Rob
Thanks, Rob, for this.
I don’t quite have something like that, but I did build a small utility I use for building foundset based reports. It is a module that can be added to any solution the reads the database and dataproviders used in a solution. It basically builds the JRXML strings for the fields, which then can be copied and pasted into the iReport XML viewer. I don’t have a lot of hours put into it as I just built primarily for my own use and was in a hurry, so if people would like to add to it, that would be great.
I will post it later today on ServoyForge and will update this forum post when it is available.
On another note, if any Java developer out there is interested, an iReport plugin that would also allow you to run a foundset based report from iReport would be nice. A rest-ws could also be utilized here as well I suspect.
I have posted the utility module as promised on ServoyForge:
Please feel free to use and make changes/suggestions/etc. I do not have documentation for it yet, but it is not too hard to figure out. It allows you to build the field by selecting the relation (if necessary) then the field. It also tries to select the java type for the field for you.
I will try to add some documentation of features in the next few days.
Jason