Re: PL/SQL: Printing questions

gelewyc_at_nyct.com (george lewycky) wrote in message news:<68aecc05.0307010652.55aa20dc_at_posting.google.com>...
> Daniel,
>
> If things went differently we would be using a product by Evergreen
> to do this, but without any money or resources and since my users
> arent satisfied with oracle's canned invoices we must resort to other
> methods,
>
> Discoverer is still an option but we require some customization
> and lookups and formatting that Discoverer wont handle.
>
> Right now I'm trying to use pre-printed forms and populate the
> needed areas with the data as a work around
>
> george
>

George,

Usually you use Oracle Reports with Oracle Apps. It's easy, all "canned" reports in Apps are written used Reports, you can customize them without big problems. What's the problem with Reports on your installation?

>
>
> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F0060E9.58B8ACC@exxesolutions.com>...
> > george lewycky wrote:
> >
> > > I have Oracle Apps ( AR & GL) and I working on creating our own
> > > Invoice but I'm unsure about certain aspects of PL/SQL & Printing.
> > >
> > > I have some PL/SQL working with the invoice data from AR_INVOICE_HEADER_V
> > > table already.
> > >
> > > 1. DBMS_OUTPUT vs. TEXT_IO
> > > What advantages exist for the two ?
> > >
> > > 2. Page breaking ??
> > > How can a perform a page break other than setting the lines per page?
> > > I will have situations where page breaks will occur before I reach
> > > the page break point
> > >
> > > 3. Is there a TAB feature?
> > > I need some method to position the text in a way other than
> > > using the space bar.
> > >
> > > Thank you very much
> > >
> > > George Lewycky
> >
> > No verison information so what you get will possibly be of limited usefulness.
> >
> > I'd use neither. Neither is a report writer and each of limited usefulness.
> >
> > Why not Oracle Reports? Discoverer? Seagate (Crystal), Cognos, Brio?
> >
> > Unless you are donating your time the cost of you writing this stuff manually
> > is a magnitude or more greater
> > than the cost of using the right tool for the job.
Received on Wed Jul 02 2003 - 17:11:41 CEST