Re: Custom Reports

Dale E. Reed Jr. ( (no email) )
Tue, 25 Feb 1997 14:49:37 -0800 ()

On Tue, 25 Feb 1997, sword wrote:

> Grand Totals
> Charges Tax Total Charged Total Received
> The problem is, I don't know which fields to query in the database. Can
> you help out here? Also, I only want it to do it for a certain period
> (from the 1st of the month to the current date) Any help would be
> appreciated.

Charged and Received in the same report is tough, because 4.5 can't do
sub-squeries (5.0 can). I put together a quick report for this. Take
a look in /emerald/contrib/reports for monrev.rpt. Its NOT complete or
perfect, just an basis for you to look at what you are trying to