RE: Report to file
Posted in 1996
I haven't used ace for years, so I may be wrong here.
If memory serves me well, all you have to do is
output
report to "filename"
end
HTH
Marco,
____________________________________________________________________________
rem radioterapia, which I immeritately manage, seldom agrees with what I say
marco greco (Catania, Italy) Work:
marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558
(was mar.greco@agora.stm.it) Achea 39 95 503117
--- On 5 Oct 1996 21:26:56 -0400 Hsprintjc <hsprintjc@aol.com> wrote:
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
-----------------End of Original Message-----------------