We are working on a special project for an existing client. We’ll be scanning hundreds of thousands of documents over the next year to year and a half. The delivery of the digital images will be on removable media so the customer can import it into their ECM. We wanted a way to be able to audit what was on the removable media each time we delivered it to the client so that we have an additional audit process confirming that the content is being delivered.
After doing a little bit of research I found that you can use a file system as a “data source” for Crystal Reports. The instructions on how to do that can be found here.
After setting up my removable media to be the Z drive (that way it won’t change around depending on if other devices are plugged in) I developed the Crystal Report you see below. Since there will always be a matching XML metadata file for each PDF document I setup a formula to alert us if the counts don’t match. Also by using a bar graph it makes it very quick and easy to check each folder and see that they match.
This report can be fired from directly within NetTrax.NET since we have our dynamic external reports module.