salespersonsummary.xml

基于sqlserver2k,reporting service的扩展(auth,render,deliver==)应用（mssql,RS,AS,BI）

<?xml version="1.0" standalone="yes"?>
<SalespersonSummary xmlns="http://www.tempuri.org/SalespersonSummary.xsd">
  <xs:schema id="SalespersonSummary" targetNamespace="http://www.tempuri.org/SalespersonSummary.xsd" xmlns:mstns="http://www.tempuri.org/SalespersonSummary.xsd" xmlns="http://www.tempuri.org/SalespersonSummary.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
    <xs:element name="SalespersonSummary" msdata:IsDataSet="true">
      <xs:complexType>
        <xs:choice maxOccurs="unbounded">
          <xs:element name="Employee">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="EmployeeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
                <xs:element name="EmployeeName" type="xs:string" />
                <xs:element name="Title" type="xs:string" minOccurs="0" />
                <xs:element name="HireDate" type="xs:dateTime" minOccurs="0" />
                <xs:element name="Sales" msdata:ReadOnly="true" type="xs:decimal" minOccurs="0" />
                <xs:element name="NoOrders" msdata:ReadOnly="true" type="xs:int" minOccurs="0" />
                <xs:element name="Year" type="xs:int" minOccurs="0" />
                <xs:element name="Month" type="xs:int" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>220228.9871</Sales>
    <NoOrders>71</NoOrders>
    <Year>2003</Year>
    <Month>1</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>112937.1321</Sales>
    <NoOrders>74</NoOrders>
    <Year>2003</Year>
    <Month>2</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>46550.0020</Sales>
    <NoOrders>50</NoOrders>
    <Year>2003</Year>
    <Month>3</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>247247.4390</Sales>
    <NoOrders>122</NoOrders>
    <Year>2003</Year>
    <Month>4</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>128473.3656</Sales>
    <NoOrders>90</NoOrders>
    <Year>2003</Year>
    <Month>5</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>41874.5583</Sales>
    <NoOrders>51</NoOrders>
    <Year>2003</Year>
    <Month>6</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>355179.9544</Sales>
    <NoOrders>179</NoOrders>
    <Year>2003</Year>
    <Month>7</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>329825.8297</Sales>
    <NoOrders>155</NoOrders>
    <Year>2003</Year>
    <Month>8</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>478148.6795</Sales>
    <NoOrders>274</NoOrders>
    <Year>2003</Year>
    <Month>9</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>276964.7301</Sales>
    <NoOrders>150</NoOrders>
    <Year>2003</Year>
    <Month>10</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>193386.6210</Sales>
    <NoOrders>126</NoOrders>
    <Year>2003</Year>
    <Month>11</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>389757.3858</Sales>
    <NoOrders>221</NoOrders>
    <Year>2003</Year>
    <Month>12</Month>
  </Employee>
  <Employee>
    <EmployeeID>23</EmployeeID>
    <EmployeeName>Campbell, David</EmployeeName>
    <Title>Sales Representative</Title>
    <HireDate>2003-05-02T00:00:00.0000000-04:00</HireDate>
    <Sales>257987.0824</Sales>
    <NoOrders>123</NoOrders>
    <Year>2004</Year>
    <Month>1</Month>
  </Employee>
</SalespersonSummary>