4GL and writing reports to a report

4GL and writing reports to a report

Post by Ed Schaef » Sun, 31 Dec 1899 09:00:00



Hi Informix professionals:

Under SCO, I'm writing to a pipe such as:

START REPORT TO PIPE lp_command

where lp_command equals something like

rcmd <node_name> lp <comand flags> <printer_name>

So far, nothing out of the oridinary.  My customer reports that
performance suffers when a certain report is executed.  The fix is to
cycle the power on the printer pointed to by <printer_name> and
performance returns to normal.

Now, I've heard of the unix print que getting so messed up that
rebooting the operating system is necessary, but never just cycling a
printer.

I was wondering if anyone else has ever seen such a phenomena.  Any
insight would be appreciated.

regards,

Ed
Schaefer

 
 
 

4GL and writing reports to a report

Post by Peter Lancashir » Sun, 31 Dec 1899 09:00:00



> Hi Informix professionals:

> Under SCO, I'm writing to a pipe such as:

> START REPORT TO PIPE lp_command

> where lp_command equals something like

> rcmd <node_name> lp <comand flags> <printer_name>

> So far, nothing out of the oridinary.  My customer reports that
> performance suffers when a certain report is executed.  The fix is to
> cycle the power on the printer pointed to by <printer_name> and
> performance returns to normal.

> Now, I've heard of the unix print que getting so messed up that
> rebooting the operating system is necessary, but never just cycling a
> printer.

> I was wondering if anyone else has ever seen such a phenomena.  Any
> insight would be appreciated.

> regards,

> Ed
> Schaefer

Some random thoughts culled from years of fighting printers...

How is the printer connected? If via a parallel port, do you use polling
or interrupts to service printer requests? If polling (required on some
versions of Xenix on some hardware), that could be the problem.

Is the printer sending messages back to the port? If it is a serial
port, are you using xon/xoff control? If so, try out-of-band signalling
with rts/cts or some such.

Is the print job asking the printer to do some complex processing which
is bogging the system down with printer wait signals? This would apply
to a PostScript printer.

Is it an ancient dot-matrix? Could you change the buffer size or
high-water mark to fit better with the data speed?

Could you use the sar program to get more information?
--
Peter Lancashire
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258,  Fax: +44-1635-562281
---
If all else fails, read the instructions.
All opinions are my own and not those of Bayer plc.
My Internet plumbing does not allow me to mail and post news together.
Sorry.
---
Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/

 
 
 

1. Reports, reports, reports, reports.....REPORTS!

Why do users want reports?

I mean, isn't it enough for them to see their information on the screen?
Why waste paper, toner, printheads, time, money, etc.?  If they *really*
want to distribute information to their clients, can't they just send them a
cheap computer with a replicated copy of the database?  Wouldn't that just
be much simpler for everyone involved (especially me)?

I can't figure it out.  I *try* and *try* to tell them that reports are
really unnecessary.  It's all in their mind.  It's a myth.  Paper reports
are like...like...dinosaurs...just waiting for the next meteorite.

But, alas, they pay me no heed and continue to insist on reports.  So, here
we are.

Currently, we're using Crystal Reports 7.0.  But, I find I *ABSOLUTELY AND
UNEQUIVOCALLY DO NOT LIKE IT.*  It's not that there's anything wrong, per
se, with the product.  Just a preference.

Has anyone out there used both Crystal and Active Reports and have some
opinion or comparison they can offer?

Manish

2. Retrieving user rights

3. How to write 4GL reports which could be read by Word and cont

4. JOB: US - Plano,TX -- Ecommerce Java Developer

5. Writing Reports using Data Reports in Visual Basic 6

6. Loading JdbcOdbcDriver class into database

7. Changing 4GL reports without changing 4GL source

8. onmonitor error : memory fault

9. REports and sub-reports in Crystal Reports

10. Reports, Reports, Reports

11. Crystal Reports/SQL 2000 - Reporting from a Stored Procedure with multiple selects (for a sub-report)

12. Free Report ### Free Report $$ Free Report

13. !FREE REPORT FREE REPORT FREE REPORT!