AdW2KProducts.rdl


<?xml version=”1.0″ encoding=”utf-8″?>
<Report xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition” xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner“>
  <rd:GridSpacing>0.25cm</rd:GridSpacing>
  <RightMargin>2.5cm</RightMargin>
  <Body>
    <ReportItems>
      <Table Name=”table1″>
        <Height>1.90476cm</Height>
        <ZIndex>1</ZIndex>
        <Style />
        <Header>
          <TableRows>
            <TableRow>
              <Height>0.63492cm</Height>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”textbox2″>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BackgroundColor>IndianRed</BackgroundColor>
                        <TextAlign>Center</TextAlign>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                        <FontWeight>700</FontWeight>
                      </Style>
                      <ZIndex>8</ZIndex>
                      <rd:DefaultName>textbox2</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value>Name</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”textbox3″>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BackgroundColor>IndianRed</BackgroundColor>
                        <TextAlign>Center</TextAlign>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                        <FontWeight>700</FontWeight>
                      </Style>
                      <ZIndex>7</ZIndex>
                      <rd:DefaultName>textbox3</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value>Color</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”textbox4″>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BackgroundColor>IndianRed</BackgroundColor>
                        <TextAlign>Center</TextAlign>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                        <FontWeight>700</FontWeight>
                      </Style>
                      <ZIndex>6</ZIndex>
                      <rd:DefaultName>textbox4</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value>List Price</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
            </TableRow>
          </TableRows>
        </Header>
        <Details>
          <TableRows>
            <TableRow>
              <Height>0.63492cm</Height>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”Name”>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <ZIndex>2</ZIndex>
                      <rd:DefaultName>Name</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!Name.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”Color”>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <ZIndex>1</ZIndex>
                      <rd:DefaultName>Color</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!Color.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”ListPrice”>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <TextAlign>Right</TextAlign>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <rd:DefaultName>ListPrice</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!ListPrice.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
            </TableRow>
          </TableRows>
        </Details>
        <DataSetName>DSProducts</DataSetName>
        <Top>1.5cm</Top>
        <Footer>
          <TableRows>
            <TableRow>
              <Height>0.63492cm</Height>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”textbox8″>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <ZIndex>5</ZIndex>
                      <rd:DefaultName>textbox8</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”textbox9″>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <ZIndex>4</ZIndex>
                      <rd:DefaultName>textbox9</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name=”textbox10″>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <ZIndex>3</ZIndex>
                      <rd:DefaultName>textbox10</rd:DefaultName>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
            </TableRow>
          </TableRows>
        </Footer>
        <TableColumns>
          <TableColumn>
            <Width>5.08333cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>5.08333cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>5.08333cm</Width>
          </TableColumn>
        </TableColumns>
      </Table>
      <Textbox Name=”textbox1″>
        <Style>
          <PaddingLeft>2pt</PaddingLeft>
          <FontFamily>Times New Roman</FontFamily>
          <BackgroundColor>Brown</BackgroundColor>
          <BorderWidth>
            <Bottom>3pt</Bottom>
          </BorderWidth>
          <BorderColor>
            <Bottom>Black</Bottom>
          </BorderColor>
          <BorderStyle>
            <Bottom>Solid</Bottom>
          </BorderStyle>
          <FontSize>18pt</FontSize>
          <TextAlign>Center</TextAlign>
          <Color>White</Color>
          <PaddingBottom>2pt</PaddingBottom>
          <PaddingTop>2pt</PaddingTop>
          <PaddingRight>2pt</PaddingRight>
          <FontWeight>700</FontWeight>
        </Style>
        <rd:DefaultName>textbox1</rd:DefaultName>
        <Height>0.8381cm</Height>
        <CanGrow>true</CanGrow>
        <Value>AdW2KProducts</Value>
      </Textbox>
    </ReportItems>
    <Style />
    <Height>7.75cm</Height>
    <ColumnSpacing>1cm</ColumnSpacing>
  </Body>
  <TopMargin>2.5cm</TopMargin>
  <DataSources>
    <DataSource Name=”AdventureWorks2000″>
      <rd:DataSourceID>60c4e09f-4e67-4d6d-946f-c77561a27c0d</rd:DataSourceID>
      <DataSourceReference>AdventureWorks2000</DataSourceReference>
    </DataSource>
  </DataSources>
  <Width>15.25cm</Width>
  <DataSets>
    <DataSet Name=”DSCategories”>
      <Fields>
        <Field Name=”ProductSubCategoryID”>
          <DataField>ProductSubCategoryID</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name=”Name”>
          <DataField>Name</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>AdventureWorks2000</DataSourceName>
        <CommandText>SELECT     ProductSubCategoryID, Name
FROM         ProductSubCategory</CommandText>
      </Query>
    </DataSet>
    <DataSet Name=”DSProducts”>
      <Fields>
        <Field Name=”Name”>
          <DataField>Name</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name=”Color”>
          <DataField>Color</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name=”ListPrice”>
          <DataField>ListPrice</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name=”Size”>
          <DataField>Size</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name=”Weight”>
          <DataField>Weight</DataField>
          <rd:TypeName>System.Double</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>AdventureWorks2000</DataSourceName>
        <CommandText>= “SELECT Name, Color, ListPrice, Size, Weight FROM Product WHERE (ProductSubCategoryID IN (” &amp; Parameters!Category.Value &amp; “))”</CommandText>
        <QueryParameters>
          <QueryParameter Name=”@Category”>
            <Value>=Parameters!Category.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
    </DataSet>
  </DataSets>
  <LeftMargin>2.5cm</LeftMargin>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <PageHeight>29.7cm</PageHeight>
  <rd:DrawGrid>true</rd:DrawGrid>
  <PageWidth>21cm</PageWidth>
  <rd:ReportID>f7bc8689-f045-4985-85ee-5d5f183e6b87</rd:ReportID>
  <BottomMargin>2.5cm</BottomMargin>
  <ReportParameters>
    <ReportParameter Name=”Category”>
      <DataType>String</DataType>
      <DefaultValue>
        <DataSetReference>
          <DataSetName>DSCategories</DataSetName>
          <ValueField>ProductSubCategoryID</ValueField>
        </DataSetReference>
      </DefaultValue>
      <Prompt>Category</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>DSCategories</DataSetName>
          <ValueField>ProductSubCategoryID</ValueField>
          <LabelField>Name</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
  </ReportParameters>
  <Language>en-US</Language>
</Report>

Comments (1)

  1. Although Reporting Services is almost 22 months old, I haven’t found any pure render extension yet (please…

Skip to main content