I am using Crystal Reports 2008 developer edition. The store I am working with has a door counter which puts its count data into an access database controlled by the TrafficFlow software. TrafficFlow also has the ability to export the data in xml format. In the end, I want the user to be able to specify a date range, and have the report pull the count info from TrafficFlow and pull the sales information from there POS software which is in an access database, and give the closing ratio.
The closing ratio calculation would be "number of sales" dvided by "number of walk-in traffic". I would also like it to calculate the average amount spent per customer.
I am brand new to Crystal reports, but am MCSE certified.