<DataSourceName>AdventureWorks</DataSourceName>

        <CommandText>SELECT        Employee.FirstName + '''' '''' + Employee.LastName AS Employee, DATEPART(Year, SalesOrderHeader.OrderDate) AS OrderYear, DATEPART(Month, SalesOrderHeader.OrderDate)

                         AS OrderMonthNum, DATENAME(Month, SalesOrderHeader.OrderDate) AS OrderMonth, SUM(SalesOrderDetail.LineTotal) AS Sales

FROM            SalesOrderHeader INNER JOIN

                         &lt;= @ReportMonth)

………………….

SalesOrderHeader.OrderDate)</CommandText>

        <QueryParameters>

          <QueryParameter Name="@ReportYear">

            <Value>=Parameters!ReportYear.Value</Value>

          </QueryParameter>

   <Fields>//前面提到的Sales是一个定义过的Field，这里就是Field的定义，如果要增加数据，这里也要进行修改，

        <Field Name="Employee">

          <DataField>Employee</DataField>//Employee对应为SQL查询语句的返回结果！

          <rd:TypeName>System.String</rd:TypeName>

        </Field>

         ….

    </Fields>

   <ReportParameter Name="ReportMonth">

      <DataType>Integer</DataType>//Month控件为Integer类型

      <DefaultValue>

        <Values>

          <Value>6</Value>

        </Values>

      </DefaultValue>

上一页  [1] [2] [3] [4] [5]  下一页