I have a multipage document that can be between 3-8 pages. First I designed the whole thing in HTML so I could use HTML tables. Servoy was chopping my HTML tables in half if they fell at a page break, I discovered that the HTML rendering machine in Servoy does not support page breaks, so I decided to recode the whole thing in RTF.
Now that I have the whole thing in RTF I note that Servoy does not correctly paginate RTF area fields. It is very easy to demonstrate: Make a basic report form with a header a body and a footer. Make an RTF area field [same problem with text area fields] and put it on the body of a form. Do all the right stuff which includes turning off scrolling on the field and the form, setting the field to grow vertically, and setting the body to break across page bounderies. Type in 1 or 2 pages of text and look at it in print preview. All is well. Now type in 4-6 pages of text and you will see that Servoy chops off the last page of text and does some other wierd stuff at the end of the document.
I agree this is an issue. Long time ago I asked to support the HTML page-break (or whatever) command but this is not implemente (yet I think). Issue for Servoy is probably that they use the standard Sun implementation of HTML and RTF. If I have to make a choice between the 2 though I would go for HTML. The support of RTF is really low…
How are you displaying the html? I have found that if the html is displayed in a label then the table cells do get cut in half across page breaks BUT this procedure seems to work:
Generate the html and put into a global field;
Place the global field (NOT a label) on your report form (with type HTML area) and set it to expand/shrink vertically;
Make sure that body part of your form is allowed to break across pages;
I have just tried this again with a 400 row table (10 pages) and all page breaks were fine - no cut rows!
I have a form letter that has HTML tables mixed with HTML text. It is in a global field not a label. Maybe it works OK with a single table but in my real life example it most definelty chops the tables in half and does not produce a professional looking report.
It also definitely cuts off the last page of forms based on RTF_Area and Text_area fields set to grow placed on a body set to break across page bounderies. This also isn’t on a label it is in a field and I have set the field up as I describe above. It is a problem! It really should be adressed.
I’ll attach a simple solution like the one I describe.[Note that you will not see the problem till you enter about 4-6 pages of text]. Enter the text and then just look at it in preview mode. It chops off the end of the text!
We have exactly the same problem. We have an html field (not a global, but does that matter??) it has mixed html and tables and breaks across pages. Often at the break it will cut the text horizontally, making printing useless.
Is there any way to reliably get a field to to break across page bounds without cutting text? Should we use rtf? HTML seems more useful to print what we need.
I am still struggling with Servoy reporting. Servoy is a great tools
for database transaction, be able to handle big data transaction but
when it come to Reporting on huge data ( 100 - 1000+) pages of report
it become HOPELESS. To print 10 to 50 pages of report, it is fine. But
if you watn to print more 100 pages of report, you will face the
problem . The HTML REPORT send to global RTF field can
only handle to the max of 66 pages. The rest of the data is missing
even thuogh the HTML contains all the data. Until now I still cannot
produce a report with the GRNAD TOTAL as most of my report is more
than 100 pages (100k+ itemised record).
If you use Servoy form HEADER/BODY/SUMMARY to produce the report,
you have to create a lots of calculation field in the data base for certain
conditions filed in the BODY part and define a lot of aggregations filed
to print the summary total. Just imagine how many calculation and
aggreation field you have to create for different report requirement.
And the report took hours to produce for more than 100 pages
I agreed with Hameed that Jasper is the other option to use to produce
a better report. It is faster and support conditions define parameter to
generate different type of report. The problem is untill now we are
still cannot integrate Servoy with Jasper without a plugin. Servoy
have the plugin, but it only provide to those who attend the training.
For those of us who cannot attend the training and not an expert in
writting the plugin, we are still searching for other tools to produce
report to our customer. Every day we get angry call from customer
because we ask to print multiple copy of small range of report and
manually add up the grand total.
For SERVOY to be a greate database tools. good reporting is a MUST.
And the tools must be able to handle big database transaction.
I hope Servoy can publish out the plugin for all Servoy developer and
make it part of the Servoy product.
The Jasper integration was first offered to customers who attended a live training, we did this limited launch on purpose to first get the feedback of a small audience. This has been very succesful and starting March 1st the plugin will be available as a standard product in our webstore. It will be offered including a training and unlimited deployment license for $2000. We are offering a special introduction price for only $1500 if you order before March 1st.
In the beginning I spent some time create a jasperProvider servoy plugin and I was only partly successful. The plugin ran properly as a stand alone. But The plugin did not run properly from Servoy. So I have to buy it from Servoy.
They did a good job integrating the plugin. They have promised a feature update to send the foundset of records from servoy to the jasper reports. This feature is still not done. At the moment I have to workaround using LEFT JOIN in the jasper query and somehow build the WHERE condition in servoy and pass it to the jasper reports.
The price seems too expensive for me although I have already bought it. (The hard work of developing jasper reports was already done by jasperforge and servoy just integrated it)