This 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.

Technical Overview

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 AdventureWorks2000 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, look at the VBA code in the Excel template workbooks.

Click to run demo

Click the button below to begin the demo.

Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.