Re: [SL] Trend analysis

[David J <ja...@in...>]

Duncan
I've been thinking of preparing some end-of-month reports to
run automagically by cronjob, and email to
owner/manager/administrator.
Is it possible to somehow get any existing SQL-L reports
sent this way, or will my custom perl script need to dig
(and format) its own data directly from the SQL-L database ?
We've previously used some perl scripts to insert data into
SQL-L, but can't see any way to capture SQL-L output for ->
email.
Cheers
DJ


> What kind of trends are you looking for?  For sales
> analysis I wrote a  little Perl script that is cron'd to
> run on the 5th day of each month  (gives me a couple of
> days to fix any month end issues).  The script  summarizes
> each sales person's sales and receivables for the month. 
> It  also provides a delta of the month over the previous
> month and the month  over the same month one year ago. 
> Finally, it builds a nice little  (electric company bill
> style) 13 month bar graph.  The script then  emails the
> personalized report to the salesperson and their manager.
> 
> Dunc
>