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!
John
*********** 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 ...in 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. www.iea-software.com