Re: Crystal Reports

Dale E. Reed Jr. ( (no email) )
Mon, 17 Mar 1997 12:34:57 -0800

Chris Jennings wrote:
>
> Does anyone out there write there own reports. We are a Canadian ISP looking
> at emerald.

I've written a couple. Most Emerald users have CR.

> What we would need to do is take the tax feild and split it into two parts
> (Federal & Prov. tax). These can be writen to SQL as one amount but they
> need to show on the invoice as two items.
>
> In the report we would need to program
>
> line 1 = 50% of tax field, "write PST = line 1"
> line 2 = 50% of tax field, "write GST (GST reg no.) = line 2"
>
> Is this possible

I just made a modifications to handle something like this. You can
change the
GST_Tax and PST_Tax formulas to reflect the percentages that you need.
The
report is:

ftp://ftp.emerald.iea.com/emerald/reports/inv_cnd.rpt

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com