I got a glance at it in DC yesterday, you guys had mentioned that it would be available today. This is a must have for me, it will save months. Where can I find it?
I am really looking forward to the Dynamic Report Builder Module as well.
Great job with everything, I think my head is spinning a little more now.
Erich
You can get it at:
http://developer.servoy.com/downloads/reportwriter.zip
You can also see a screenshot at:
http://www.clickware.com/servoy/reportwriter.htm
DO read the “READ ME” file for IMPORTANT information before installing!
Thanks,
I heard to wrote that core of that module on a plane trip. Very impressive!
Maybe you could just write my solution for me in a couple of minutes and save me a few more months.
Nice work
That code has actually evolved over a period of time. I started by creating a solution called “ReportMaker” - that just did straight tabular reports. I learned a lot about how NOT to do it - then completely re-wrote the code for the “ReportWriter” module.
I’ve probably spent over 200 hours on it…
Wanted to let you know that there is a new version of the ReportWriter module online at:
http://developer.servoy.com/downloads/reportwriter.zip
Installation instructions are included in the “READ ME.txt” that is included in the download.
IMPORTANT RELEASE NOTES:
=-=-=-=-=-=-=-=-=-=-=-=
!!!IMPORTANT!!!
This solution uses i18n strings for ALL text strings. You MUST have an i18n connection and table and you MUST import the i18n strings when importing the solution - or it won’t look right. MAKE SURE you have a “default” i18n server and table setup in the “Local” tab of the Edit → Preferences BEFORE you import the solution!!
!!!ALSO IMPORTANT!!
When you import this build - IF YOU HAVE A PREVIOUS VERSION - you MUST update the styles, the media, and the i18n data!
=-=-=-=-=-=-=-=-=-=-=-=
REVISION HISTORY:
0.9 build 31:
[fix] added better error checking for valid server names when creating a new connection
[fix] when creating report - wizard screen now shows the fields from the first table after creating a new connection
[fix] added i18n strings for various “hard coded” errors
[fix] changed button sizes, graphics, and modified styles for correct display on Mac OS X
[fix] “move all” buttons now working
[enh] added encryption of passwords using free cryptor plug-in by IT2Be (Servoy Components – Plugins, Beans, Web Components, Angular Services & Servoy Developer Consulting)
[enh] changed structure - added “mod_rpt_styles” table and separated the admin prefs from styles
[enh] now can attach a particular named style (when setup in Admin Prefs) to a report (wizard screen #2)
[enh] changed the admin style dialog to reflect the actual functionality of the report rendering
[enh] made the admin dialog taller to accomodate more data in the list views
[enh] changed all the checkboxes so that user can click on the text of the item and not just the checkbox
[enh] added the ability to run manual queries
[enh] added pre-loading of the report wizard forms for smoother first-time UI
[enh] updated sample data, styles, etc.
0.9 build 30:
[fix] saving of searches now conforms to pref
[fix] “back” button working when using drill down reports
[fix] adding a new connection when creating a report no longer produces error
There is a NEW VERSION available: 0.9 build 32
Download at: http://developer.servoy.com/downloads/reportwriter.zip
=-=-=-=-=-=-=-=-=-=-=-=
!!!IMPORTANT!!!
This solution uses i18n strings for ALL text strings. You MUST have an i18n connection and table and you MUST import the i18n strings when importing the solution - or it won’t look right. MAKE SURE you have a “default” i18n server and table setup in the “Local” tab of the Edit → Preferences BEFORE you import the solution!!
!!!ALSO IMPORTANT!!
When you import this build - IF YOU HAVE A PREVIOUS VERSION - earlier than build 31 - you MUST update the styles, the media, and the i18n data!
IF YOU HAVE A VERSION THAT IS BUILD 31 OR HIGHER - you do need to import the i18n data.
=-=-=-=-=-=-=-=-=-=-=-=
0.9 build 32 RELEASE NOTES:
[fix] fixed password access for both admin prefs and for user actions
[fix] fixed a bug in the startup script that would sometimes show an error at startup
[enh] added error checking for encrypted passwords and for existence of cryptor plug-in
[enh] added option for encryption for existing passwords when plug-in is available
[enh] added a way to refresh a connection’s tables/columns in Admin Prefs
[enh] added a way to add additional connections in Admin Prefs
[enh] added a checkbox to NOT allow users to enter a new connection name when defining a report
There is a new build available at: http://developer.servoy.com/downloads/reportwriter.zip
ReportWriter Module - VERSION 0.9 BUILD 33
=-=-=-=-=-=-=-=-=-=-=-=
BUILD 33 SCHEMA CHANGE - If you are using an earlier version - you need to go into each report and delete and re-add the SORT columns. IF you have a subsummary report - you can just REMOVE and re-add the group by columns
!!!IMPORTANT!!!
This solution uses i18n strings for ALL text strings. You MUST have an i18n connection and table and you MUST import the i18n strings when importing the solution - or it won’t look right. MAKE SURE you have a “default” i18n server and table setup in the “Local” tab of the Edit → Preferences BEFORE you import the solution!!
!!!ALSO IMPORTANT!!
When you import this build - IF YOU HAVE A PREVIOUS VERSION - earlier than build 31 - you MUST update the styles, the media, and the i18n data!
IF YOU HAVE A VERSION THAT IS BUILD 31 OR HIGHER - you do need to import the i18n data.
=-=-=-=-=-=-=-=-=-=-=-=
REVISION HISTORY:
0.9 build 33:
[fix] fixed the “update connection” in application prefs to take into account deleted tables/columns
[fix] disabled the “close” box on the report creation/edit window to prevent auto-commits
[fix] if there are no columns added to the report - the wizard will not go any further
[enh] added list of broken tables/columns to the admin prefs - in connection maintenance
[enh] added ability to see reports affected with deleted items with a red “X” and red type
[enh] added ability for admin to delete missing items from reports (servers, tables, columns)
Hi Bob,
The ReportWriter link doesn’t seem to work. Any hope of it going back online soon?
Thanks,
Andrew
So no more Report Writer?
just send Bob an email (bcusick@servoy.com) or a private message through the forum.
Mostly he will respond right away.
http://www.servoy.com/downloads/downloa … writer.zip
NOTE: This has NOT been tested/verified with 3.0 - and probably won’t be! You can use it as a starting place or idea for your own development efforts.
The overall problem with this solution is it’s just too complex. I tried to put too many features into it - and it proved confusing to people. PLUS, now that in 3.0 you can get the SQL and parameters behind foundsets, it makes the saving of foundsets much easier. PLUS, with the great stuff that Matt Frizzell and James Garfield (both from adBlocks) are doing with reporting, this example is a little lame.
Nonetheless, it’s got some serious code behind it - and James Garfield can show you how to code the subsummary engine in 40 lines, rather than the 1,600+ that I used to do it!
I guess the correct download link is:
Hi guys,
is there another way to customize Jasper based reports in Servoy Clients?
We are still looking for a solution.
We are thankfull for every answer.
Silvio
Schöttner EDV