locked
Report with multiple columns. RRS feed

  • Question

  • I am using 2005 Reporting Service and following the instruction here to create a report to print address labels and write a report with multiple columns, however, the first column is always showing up a little bit lower than the rest two columns.

    Here is a sample 

    Any idea?


    • Edited by John Sun Monday, March 8, 2010 6:29 PM
    Monday, March 1, 2010 8:54 PM

Answers

  • Looks like the problem is that I need to put the rectangle at the top of the list.  By removing the space at the top of the rectangle, I am able to align all the columns.
    • Marked as answer by John Sun Monday, March 8, 2010 6:59 PM
    Monday, March 8, 2010 6:59 PM

All replies

  • John, We are unable to see your sample link provided.  
    Regards, KarthikShanth.
    Tuesday, March 2, 2010 6:46 AM
  • John, We are unable to see your sample link provided.  
    Regards, KarthikShanth.
    Sorry, I updated the link..
    Tuesday, March 2, 2010 2:22 PM
  • Hi John,

    Did you use 3 Tables to show these data in one List? If so, please don't. If you want to keep certain space between columns, please use the blank column between them instead of putting each column data in separate table. If i misunderstand, please provide more details on how to design this report.

    thanks,
    Jerry
    Wednesday, March 3, 2010 3:03 AM
  • I actually didn't use table, I used a list, and then placed a rectangle inside the list. The only issue I face now is that the first column is lower than the next two columns. Here is the output.

    Here is my code.
    <?xml version="1.0" encoding="utf-8"?>
    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
      <InteractiveHeight>11in</InteractiveHeight>
      <rd:DrawGrid>true</rd:DrawGrid>
      <InteractiveWidth>8.5in</InteractiveWidth>
      <rd:SnapToGrid>true</rd:SnapToGrid>
      <RightMargin>0.15in</RightMargin>
      <LeftMargin>0.15in</LeftMargin>
      <BottomMargin>0.5in</BottomMargin>
      <rd:ReportID>84e44a9e-f3ad-4c01-86ca-110deffd35b3</rd:ReportID>
      <Width>2.25in</Width>
      <Body>
        <ColumnSpacing>0.125in</ColumnSpacing>
        <ReportItems>
          <List Name="list1">
            <Left>0.125in</Left>
            <DataSetName>DataSet1</DataSetName>
            <ReportItems>
              <Rectangle Name="rectangle1">
                <ReportItems>
                  <Textbox Name="StreetAddress">
                    <rd:DefaultName>StreetAddress</rd:DefaultName>
                    <Top>0.5in</Top>
                    <Width>1.5in</Width>
                    <Style>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <ZIndex>1</ZIndex>
                    <CanGrow>true</CanGrow>
                    <Left>0.25in</Left>
                    <Height>0.25in</Height>
                    <Value>=Fields!StreetAddress.Value</Value>
                  </Textbox>
                  <Textbox Name="ChildsFirstName">
                    <rd:DefaultName>ChildsFirstName</rd:DefaultName>
                    <Top>0.25in</Top>
                    <Width>1.25in</Width>
                    <Style>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Left>0.375in</Left>
                    <Height>0.25in</Height>
                    <Value>=Fields!ChildsFirstName.Value</Value>
                  </Textbox>
                </ReportItems>
                <Style>
                  <BorderStyle>
                    <Default>Solid</Default>
                  </BorderStyle>
                </Style>
              </Rectangle>
            </ReportItems>
            <Top>0.125in</Top>
            <Width>2in</Width>
            <Height>1.375in</Height>
          </List>
        </ReportItems>
        <Height>1.875in</Height>
        <Columns>3</Columns>
      </Body>
      <Language>en-US</Language>
      <TopMargin>0.5in</TopMargin>
    </Report>


    Thursday, March 4, 2010 9:44 PM
  • Looks like the problem is that I need to put the rectangle at the top of the list.  By removing the space at the top of the rectangle, I am able to align all the columns.
    • Marked as answer by John Sun Monday, March 8, 2010 6:59 PM
    Monday, March 8, 2010 6:59 PM