IntroductionThis sample demonstrates an application of HotCell Technology that actively downloads reports from a web server based on selections made on a client-side Excel spreadsheet.
This is a "Drill Down" report that allows you to drill through several layers of relational data. The application starts on a list of customers from the AdventureWorks database. Select a customer to "drill down" and see a list of all orders made for that customer. Select an order to see the order details for that particular order.
Each time you select a customer or order to drill down into, HotCell VBA code contacts a Servlet on the server and downloads the data you have requested. With this technique, you only download the data you need.
In addition to the Servlet code below, look at the VBA code in the Excel template workbooks.
Templates: OrdersTemplate.xls, CustomersTemplate.xls, OrderDetailsTemplate.xls