Printing large foundsets

Classic Servoy
1

Hi all

I am having an issue with printing reports with large foundsets.

My foundset is currently 2330 records which are subsummarised twice. The print preview is perfect but only previews about 2/3 of the records! The rest seem to be omitted. The report should be about 70 pages but stops at about 43 pages. i can scroll through the foundset and see all the records in a list but as soon as i go to print preview i lose approx 1/3 of the records!

Would appreciate any help.

2

Hi All,

I am having the same problem with large found set of data under
print preview. Currently my foundset contains 80,000 records for 2 days
of sales transactions. It is expected to increment to at least 1 million
records for 1 month of sales trxs and I need to key the database for at
least 12 months of sales transction.

I am running MySQL 5.10 & WINDOWS XP Pro. Everytime I preview
my daily summary department sales for from around 35,000 records
foundset to AROUND 10 pages in preview, when I press the CLOSE
button on the review page, the preview will not close. I can go to
Designer mode, but when I go back to Running Mode the preview
screen is stilled there. I need to SHOTDOWN the SERVOR application
and restart SERVOY.

Thanks in advance for any help.

Kelvin

3

Take a look at this post of mine from a while back:

I had trouble when creating a dataset from a SQL query, then using controller.loadRecords( dataset ) to load the foundset into my print form and the troubles went away if I just used controller.loadRecords( query ). Hope this is helpful.

SteveInLA

4

Hi

Thanks for your help, Steve.

My understanding is it shouldn’t matter how we get the foundset/dataset by sql, find mode or method, its all sql in the end anyway.

The problem is not in creating the foundset/dataset, i can see all the correct foundset by scrolling the list, they are all there. When i print preview the preview only shows a subset of these for whatever reason and will not display or print the whole foundset.

The report is over 80 pages, by sorting ascending i can print the first 42 pages. Sort descending (same foundset) i can print another 42 pages.

Is this a bug? my db is mySQL 5.0.18. Servoy v2.5

Thanks again.

5

My issue wasn’t so much in how the foundset was created, but how it was loaded into the form. For whatever reason, Servoy was behaving differently when asked to load records from a dataset vs. from a query.

SteveInLA