One of Freelock, LLC's ongoing customers needed a web front end for a proprietary reporting tool. This reporting tool could be configured to generate reports that ended up in Microsoft Excel.

 The customer wanted a prototype web site that would automatically display results from the latest version of the report. The prototype developed was fully functional. It used the Sablot XSLT parser and PHP to pre-process the reports, by parsing each Excel file saved in XML format. It used the Microsoft MSXML 3.0 DOM to manipulate the pre-processed data in IE 6, providing an interface that could be sorted and filtered without reloading the page.

Dynamic XML-based report browsing tool: