|
Display nested product category sales data. Detail rows for each category are
shown in collapsible lists with subtotal formula rows.
Technical Overview
Choose a year from the dropdown list below. This is a SQL parameter that
retrieves order data from the AdventureWorks2000 database for a particular
year. The sales data is written into the worksheet and grouped by major
product category. Subtotal lines are written after each major product
category. Each group of product sales line items is also grouped into a
collapsible outline.
If you need to display nested, subtotaled data in your Excel report, this demo
will be particularly useful to you.
View source
Click to generate
Copyright 2005 © SoftArtisans, Inc. All Rights
Reserved.
|
