Re: [Emerald] Report Help Dale!!!

PowerNet ( (no email) )
Wed, 14 Apr 1999 14:31:42 -0400


I have made these changes to the serv rev report, but somehow the data it=
gives me is incorrect. I know this because it multiplies amount by=
quantity and the quantities are not even close.

I need to figure my sales tax report out within the next 4 days. I am in=
desperate need of a report that will report this data accurately.

Please Help!

I can email you a copy of my report if that helps. Let me know!


*********** REPLY SEPARATOR ***********

On 4/14/99, at 9:38 AM, Dale E. Reed Jr. wrote:

>PowerNet wrote:
>> Here is the SQL query on the serv_rev.rpt that I have. It looks a=
little different than what you said.
>> What is my query below asking for?
>> What do I need to change to make it last full month only?
>You don't change the SQL. In CR when editing the report, Select the
>Report...Select Export pull down menu. The second tab should be
>Invoices.Date. Change it from the perdio...last full month,
>to whatever you want it to bee (there are a bunch of options
>in the third box).
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.