----- Original Message -----
From: Josh Hillman <admin-maillist@talstar.com>
To: <emerald@iea-software.com>
Sent: Saturday, April 24, 1999 1:20 PM
Subject: Re: [Emerald] Email Invoices
> From: Dale E. Reed Jr. <daler@iea-software.com>
> >However, I'll look into trying to come up with a way to allow you to
> >configure that information w/out requiring crystal reports. Its
> >not that we are against it, its just that you are the first person
> >to bring it up as an issuse. :(
>
> This stuff has no bearing on us because we already have CR6, but I do have
> an idea that seems simple enough to take care of the people who don't have
> CR6.
>
> Maybe a new table ("ISP" or something) could be added to the Emerald db
that
> contains at least the following columns (at least in the US):
> Company varchar(50)
> Address1 varchar(50)
> Address2 varchar(50)
> City varchar(50)
> State varchar(20)
> Zip varchar(10)
> Email varchar(50)
> Phone varchar(20)
> SupportURL varchar(50)
>
> And have IEA take whatever Invoice.rpt file they distribute and either
make
> a copy of it or modify it so that the above information is displayed on it
> in some way so that the companies that don't have a way of editing the
> reports at least have their company's info on the invoice for when they
> mail/email it out. This would work for all companies and wouldn't be
> customized in any way for one individual company.
>
> Obviously, anyone with CR6 can remove the information off of the
Invoice.rpt
> file if they didn't want it, and could also not bother creating the new
> table in Emerald unless they had some other use for it.
>
> So my suggestion is for IEA to write/release a short SQL script to
generate
> a generic "ISP" table for the Emerald db and insert those columnnames into
a
> revised invoice.rpt file so that the output looks organized in some way,
> maybe something like:
> ISP Name Phone: 850-555-1212
> 123 Main St. Email: support@whatever.com
> PO Box 1234 Support: http://support.whatever.com
> Tallahassee, FL 32301
>
> Josh Hillman
> hillman@talstar.com
>
>