ReportViewer教程(15)-矩阵报表-1

 

我们用矩阵报表来观察2002-2003年各季度货物的销售情况：

 

 

    新建一个项目并在其中放入Windows窗体(步骤见ReportViewer教程(1)-新建工程，添加Form和报表浏览器）；建好项目后再在解决方案资源管理器中的项目上右击，添加一新建项，选XML文件，名称为Data.xml,将以下复制到Data.xml文件，将其内容复盖：

<?xml version="1.0" standalone="yes"?>

<AdventureWorks2000DataSet xmlns="http://tempuri.org/AdventureWorks2000DataSet.xsd" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Wheel</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>204276.2973</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Saddle</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>68441.3552</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Jersey</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>300465.7950</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Touring Bike</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>3763461.0256</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Bottles &amp; Cages</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>31782.1380</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Tights</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>56298.7425</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Bottom Bracket</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>23334.9960</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Crankset</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>13599.9600</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Pumps</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>8196.0252</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Locks</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>1229.8500</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Derailleur</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>46430.8400</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Headset</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>24565.2028</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Gloves</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>57939.9187</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Vest</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>94783.6500</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Handlebars  </SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>13139.0678</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Brakes</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>3399.9900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Bottles &amp; Cages</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>1214.8500</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Handlebars  </SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>72543.4627</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Brakes</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>782.9900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Chain</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>16240.8608</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Mountain Frame</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>1405118.8044</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Road Frame</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>1191875.9659</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Pumps</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>26544.1800</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Jersey</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>24200.1184</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Socks</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>1395.5500</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Bike Stand</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>16688.4900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Locks</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>2205.0000</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Road Frame</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>617196.2410</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Touring Frame</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>3578.2700</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Road Bike</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>4753299.0324</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Headset</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>16442.7900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Tights</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>74929.9570</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Shorts</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>140248.4555</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Cap</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>5789.6826</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Road Bike</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>3963847.2136</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Mountain Bike</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>2841196.0341</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Mountain Bike</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>10.17</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Touring Frame</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>1131882.1700</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Saddle</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>3131.9600</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Hydration Pack</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>29703.8820</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Locks</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>6360.0000</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Cap</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>1000.1286</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Mountain Frame</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>279236.6915</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Fork</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>29375.6058</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Touring Bike</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>41130.2866</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Gloves</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>61223.3408</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Bib-Short </SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>13713.2610</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Helmet</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>208135.0765</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Handlebars  </SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>27702.7626</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Bike Stand</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>4768.1400</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Cleaners</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>143.1000</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Vest</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>2429.7000</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Brakes</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>60904.3900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Shorts</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>112682.2035</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Tights</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>61904.2450</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Tires &amp; Tubes</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>53867.3660</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Touring Frame</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>879983.1730</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Derailleur</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>1565.9800</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Socks</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>30572.0473</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Vest</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>2214.9750</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Touring Bike</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>30644.8900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Socks</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>2111.8500</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Jersey</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>54947.6267</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Helmet</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>30718.3065</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Saddle</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>4697.9400</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Bike Racks</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>58048.1400</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Helmet</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>18865.6370</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Bottom Bracket</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q4</OrderQtr>

    <Sales>17153.5778</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Bottom Bracket</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q1</OrderQtr>

    <Sales>121.4900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>

    <SubCat>Cap</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>1612.5669</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Mountain Bike</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q2</OrderQtr>

    <Sales>3024108.0392</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Pedals</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>102116.9044</Sales>

  </vSales>

  <vSales>

    <ProdCat>Component</ProdCat>

    <SubCat>Saddle</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>782.9900</Sales>

  </vSales>

  <vSales>

    <ProdCat>Accessory</ProdCat>

    <SubCat>Panniers</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>2384.0700</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Mountain Bike</SubCat>

    <OrderYear>2003</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>3241338.5239</Sales>

  </vSales>

  <vSales>

    <ProdCat>Bike</ProdCat>

    <SubCat>Touring Bike</SubCat>

    <OrderYear>2002</OrderYear>

    <OrderQtr>Q3</OrderQtr>

    <Sales>13499.9600</Sales>

  </vSales>

  <vSales>

    <ProdCat>Clothing</ProdCat>