Schedule-Report to send to mail

RMS currently has no this feature, however if you have crystal report then you have 2 free online tools available for this one is crystal passage and other one is crystal delivery. These are free.

The other th> Hello,

One of the most expensive options, but one of the best if you have numerous locations or reporting needs not covered within RMS, would be to build an Analytical database. Using this you can schedule distro of any report you create. Dually, you will have the function to create stronger reporting with pivot tables and added info that RMS will not retain or give you (can we say historical inventory and sell thru reporting). Additionally, when managing several installations, you can add details like royalty reporting based on %ages or store build out costs, etc.

I use the osql command line utility to write query results to a text file, then mail it to myself using the command line mailer called Blat.

Search the group for osql and blat and you will find some previous posts about how to do this.