Suited for large reports ?

[2001 JI Open Discussion]

By: Franck Routier - alci

Suited for large reports ?

2002-12-18 06:16

Hi,

 

I was wondering if any of you has experience with large reports using JasperReports ?

By large, I mean something like a genral ledger with 100000 lines (something like 2000 to 5000 pages).

 

Another question is, is there a possibility to handle dynamic breaks ? For example, the user submits a range of acounts and the sums he wants (by date, then by acount). The other time, he may want to sort by acount, then by month, from the same report. Would this be possible ?

 

Thanks in advance for your comments,

 

Franck Routier

 

 

By: Paulo Soares - psoares33

RE: Suited for large reports ?

2002-12-18 06:57

iText has a limit of 8192 pages in the pdf generation. It will generate more pages but there's no guarantee that it will work in Acrobat. If there's enough interest for more it will be extended.

 

 

By: Teodor Danciu - teodord

RE: Suited for large reports ?

2002-12-18 07:21

 

Hi,

 

I heard people generating 900 pages reports.

As far as I know, there are only hardware limits to this (memory).

 

Your second question sound more like

dynamic report designs.

This is possible and you can take a look at the

"noxmldesign" sample.

But I think that in the end, your users will get to

load each time report templates that they previously

defined using a tool that you supply to them.

 

I hope this helps.

Teodor

 

 

 

By: Franck Routier - alci

RE: Suited for large reports ?

2002-12-18 07:25

Well, 8192 pages is enough I think. Thanks for the quick answer.

 

Franck Routier

 

 

By: John Pollard - johnnypoll

RE: Suited for large reports ?

2002-12-20 14:23

I have found long reports take a very long time to fill. For example 200 pages taking a minute to fill in one of my reports. Obviously it depends on detail but I guess a 1000 page report would be painfully slow to fill. I haven't had time to investigate where the delays are occurring but it is within Jasper (or within classes that Jasper makes use of such as iText) rather than my JRDataSource class. I would be interested if others are producing long reports quickly.

 

 

By: Franck Routier - alci

RE: Suited for large reports ?

2002-12-23 02:12

I don't find one minute a very long time for 200 pages... In what context is it a problem ?

As far as I'm concerned, up to a few minutes is ok, since it will be a background process, so the user won't have to wait. Moreover, it's the data access and manipulation that take most of the resource.

 

Thanks for the experience anyway. I find it encouraging. What bothers me more is memory consumption...

 

Franck Routier

 

 

By: Teodor Danciu - teodord

RE: Suited for large reports ?

2002-12-23 02:35

 

Hi,

 

Are you sure you cannot split your huge

print jobs into multiple consecutive tasks?

This would be easy if you can introduce page

breaks from time to time without affecting

the overall meaning of your documents.

 

Launching separate report filling processes once

every 100 pages or so would help with the memory

issue.

 

I hope this helps.

Teodor