Reporting solution for a very long report

Thread view:

krislioe@gmail.com - 07 Apr 2006 06:47 GMT

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

Reply to this Message

Jhair Tocancipa Triana - 07 Apr 2006 08:22 GMT

krislioe writes:

> 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.

Signature

--Jhair

Reply to this Message

krislioe@gmail.com - 07 Apr 2006 08:39 GMT

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

Reply to this Message

Jhair Tocancipa Triana - 07 Apr 2006 09:15 GMT

> 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.

Signature

--Jhair

Reply to this Message

Roedy Green - 07 Apr 2006 10:13 GMT

>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.

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.

Reply to this Message

James McGill - 07 Apr 2006 10:23 GMT

> 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.

Reply to this Message

Chris Uppal - 07 Apr 2006 09:42 GMT

> > What is the best solution for such requirement ?
>
> 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

Reply to this Message

Roedy Green - 07 Apr 2006 10:15 GMT

>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.

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.

Reply to this Message

Reporting solution for a very long report

Free Magazines