Re: [Emerald] SQL Revenue Script

talon ( (no email) )
Wed, 4 Aug 1999 13:39:11 -0500

Well, I put revgross.rpt in with the other reports.. restarted emerald, and when I click reports... it doesnt show up.... ?

I noticed we had servrev.rpt already, i click diplay report,
it asks me if i want to refresh the data, i click yes.
Then i get this error: StartPrintJob in PrintCustom caused an error:
SQL server error.

Help!!

Thanks

Tim

---------- Original Message ----------------------------------
From: "Dale E. Reed Jr." <daler@iea-software.com>
Reply-To: emerald@iea-software.com
Date: Wed, 04 Aug 1999 11:21:55 -0700

>talon wrote:
>
> Im looking for a sql script that will show me the total revenue generated from all the accounts.. So basically, I need a query that shows me how much money im generating each month.
>
> Anyone have something like this??

I copied a couple of revenue reports that I have into the
/emerald/reports
directory on our FTP site:

ftp://ftp.iea-software.com/Emerald/reports/revgross.rpt
ftp://ftp.iea-software.com/Emerald/reports/serv_rev.rpt

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart



For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart