Reporting solution for a very long report

[krislioe]

Hi All,

We have requirement to print a very long report ( about 150.000 pages
folio size, something like account statement ). Database server is in
remote location, connected to report's client via 64 kbps VPN.

What is the best solution for such requirement ?

Some thoughts are :
- using Crystal Report / Oracle Report , display the report on browser
and print it
- Query the data from client side, save the data locally and create
report from it

or is there any best solution for this ?

Thank you for any help,
xtanto

 

[Jhair Tocancipa Triana]

Hi All,
We have requirement to print a very long report ( about 150.000 pages
folio size, something like account statement ). Database server is in
remote location, connected to report's client via 64 kbps VPN.

Will you read the 150000 pages? In most cases the data needs to be
accordingly aggregated and formated so a human can read and understand
it, and there is software which does just that.

What is the best solution for such requirement ?

It depends on what you want to do with the 150000 page data.

 

[krislioe]

Hi,

We have to print hard copy of all 150000 pages because it is like
account statement that should be given to each members.
Whats the best approach ?

Thank you,
xtanto

 

[Jhair Tocancipa Triana]

We have to print hard copy of all 150000 pages because it is like
account statement that should be given to each members.
Whats the best approach ?

At this point you should already know your question has nothing to do
with Java so I would stop this conversation here.

 

[Chris Uppal]

It depends on what you want to do with the 150000 page data.

And on where the printer is which is capable of handling so many pages.

I'd be tempted to create the report at the same place as the database, send the
resulting PDF (or whatever) file to a print bureau (perhaps on a DVD, since
it's likely to be getting on for a GByte in size), and have them send the
printed pages overland to the unfortunate bugger who is supposed to read it (or
use it as fuel during the Winter months).

-- chris

 

[Roedy Green]

We have to print hard copy of all 150000 pages because it is like
account statement that should be given to each members.
Whats the best approach ?

that is not what you normally call a report. You would usually
describe that is we have to print 150,000 pages of statements,
or 100,000 statements, two sided 1 to 3 pages each.

 

[Roedy Green]

We have requirement to print a very long report ( about 150.000 pages
folio size, something like account statement ). Database server is in
remote location, connected to report's client via 64 kbps VPN.

What is the best solution for such requirement ?

You put the data on DVD and fedex it over to where your big printer
is.

If necessary electronically sent a delta file of last minute changes.

 

[James McGill]

that is not what you normally call a report. You would usually
describe that is we have to print 150,000 pages of statements,
or 100,000 statements, two sided 1 to 3 pages each.

It bothers me that a business with a hundred kiloclients hasn't planned
this out in advance.