Do you have Microsoft RMS and wish you could write custom SQL report for it? Well you can and best of all it is easy to do. All you will need is a free Microsoft application and a little knowlege of SQL. Download and install Microsoft SQL Server Management Studio Express. Once you have it open you will be able to connect to your stores database. Use the object explorer to see what tables are available and start exploring to see how each table relates to the others.
You can create a new query window and test some SQL code like the following that selects the description for all items with a price greater than $10.00:
“select description from item where price > 10″
The possiblities are endless once you have direct access to the data. This flexibility is the primary reason I chose Microsoft RMS.
Robbalman