Is there a way to format an answer set from a CF request to a database into
a report and then send it directly to a user's printer while bypassing their
browser?

We are migrating a mainframe CICS application to a web application using CF
and Oracle.

When a user requests a listing/report, the mainframe application will return
up to 300 rows to the screen, will divert between 301 to 3000 rows to the
user's mainframe associated printer, and will ask the user to refine their
search if the answer set reaches 3001 rows.

The users want us to duplicate this 300/3000 row functionality in the web
app version and they also want the capability of sending output directly to
a printer regardless of how many rows are in the answer set (at times this
could be as many as 5000 rows!). The output that gets directed to a printer
must be formatted into a listing/report just like the output that gets
displayed in the browser. I.e., the print output must have report headers,
column headers, counts and totals, etc., not just be a dump of the answer
set.

Our dilemma is how do we format the output into a listing/report and send it
directly to the user's printer while bypassing the browser?

How would you do this?

If this is not possible, what other alternative(s) would you consider to
satisfy this requirement?

We are still on CF 5 on Win2k, moving to CFMX 6.1 on Win2003, then to CFMX
6.1/Blackstone on Solaris . . .

Thanks!

George
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to