Report to file
Posted in 1996
I have the following report running in Informix. It works fine. However,
instead of piping it to the print spooler [cov_print -p lp2 -m c], I want
to send the output to file. What is the proper command to include for
that?
Thank you.
Howard Schwartz
Johnson City Publishing
12 Hall Street
Binghamton, NY 13903
(607) 772-0687 Ext: 307
fax: (607) 772-2902
email: hsprintjc@aol.com
database
maindb
end
output
report to pipe "cov_print -p lp2 -m c"
end
select job_date_billed, job_cunm, job_net_price from job where
(job_date_billed >="01/01/96" and job_date_billed <= "09/30/96")
order by job_cunm
end
format
after group of job_cunm
print job_cunm, group total of job_net_price, group count
on last row
print "Total Price: ", total of job_net_price
end