Definitely check out the lattice package. One other option is to use sweave/latex mixed with RODBC. This can be used to produce PDF's for easy distribution as well. I would also consider operating this in a batch mode, the R/sweave/latex works very well this way.
Shawn Way, PE Engineering Manager -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Snow Sent: Thursday, January 20, 2005 10:52 AM To: [email protected]; [EMAIL PROTECTED] Subject: Re: [R] easing out of Excel >>> "Paul Sorenson" <[EMAIL PROTECTED]> 01/19/05 03:18PM >>> >> I know enough about R to be dangerous and our marketing people have >> asked me to "automate" some reporting. Data comes from an SQL source >> and graphs and various summaries are currently created manually in >> Excel. The raw information is invoicing records and the reporting is >> basically summaries by customer, region, product line etc. >> >> With function such as aggregate(), hist() and pareto() (which someone >> on this list kindly pointed me at) I can produce something roughly >> equivalent to the current reports. >> >> My question is, are there any neat R "lock out" features people here >> like to use on this kind of info, particularly when the output is very >> visual (report is intended for marketing people). >> >> Another way of looking at this is, What kind of "hidden" information >> can I extract with R that the Excel solution hasn't touched? Since you are looking for summaries within groups, you should look at the lattice package and some of the plots that you can produce with it (maybe for each product line you can produce a lattice/trellis graph with each panel representing a region and different colors symbols within panels to represent different customers). If we had more of an idea of what you are looking for, we could give better suggestions. >> For example, even the pareto plot mentioned earlier is something the >> Excel guys haven't thought of or can't easily produce. >> >> regards >> >> BTW the tool chain I am using goes something like: >> Production (run daily): >> DB -> SQL/python -> CSV -> R/python -> images -> network >> Presentation: >> network -> CGI/python -> browser It looks like you want the reports fully automated and the final result as HTML (to be viewed with a browser), I suggest you look at the R2HTML package and the sweave function (this lets you write a report in HTML with r-code in place of graphs and output, then a quick run through sweave and you have a final report in HTML ready to be viewed). There are also several tools available for running R through CGI, go to: http://www-r.project.org/ and click on "R web-servers" under the "Related Projects" heading in the left column to get details. Hope this helps, Greg Snow, Ph.D. Statistical Data Center [EMAIL PROTECTED] (801) 408-8111 ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
