2nd column will not show (even in print preview mode)

4 posts, 0 answers
  1. Garrett
    Garrett avatar
    35 posts
    Member since:
    Feb 2012

    Posted 28 Oct 2013 Link to this post

    Hi there,

    I have a page 8.1 inches with margins .2 inches all around. I have also tried with 8 inch page.

    Second column will not work. I have tried 8" page, 7" page, no margins, 1" margins, etc. Whatever I do it does not work. I have also tried removing the header and that did nothing. I have attached a pic of what it looks like in PP mode.

    Here is my report:

    <?xml version="1.0" encoding="utf-8"?>
    <Report DataSourceName="sqlDataSource1" Width="8.1in" Name="guestlist" SnapGridSize="0.1in" xmlns="http://schemas.telerik.com/reporting/2012/3.3">
      <Style>
        <BorderWidth Default="0in" />
      </Style>
      <DataSources>
        <SqlDataSource ConnectionString="STRINGNAME" SelectCommand="select * from guestlist order by lastname" Name="sqlDataSource1" />
      </DataSources>
      <Items>
        <DetailSection Height="1.8in" Name="detail">
          <Style>
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
          </Style>
          <Items>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.07in" Value="Name:" Name="textBox1">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.3in" Value="Guest Name:" Name="textBox4">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.5625in" Value="Children:" Name="textBox5">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.8in" Value="Address:" Name="textBox6">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.25in" Value="Phone:" Name="textBox8">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.5in" Value="Email:" Name="textBox9">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.0700000151991844in" Value="=Fields.FirstName + " " + Fields.LastName" Name="textBox10">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.0299999993294477in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.3in" Value="=Fields.Guests" Name="textBox11">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.5625in" Value="=Fields.Children" Name="textBox12">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.8in" Value="=Fields.Street" Name="textBox13">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1in" Value="=Fields.City + ", " + Fields.State + " " + Fields.Zip " Name="textBox14">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.25in" Value="=Fields.Phone" Name="textBox15">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.5in" Value="= Fields.Email" Name="textBox16">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
          </Items>
        </DetailSection>
        <PageHeaderSection Height="1in" Name="pageHeaderSection1">
          <Style BackgroundColor="238, 236, 225">
            <BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />
            <BorderColor Top="74, 69, 42" Bottom="74, 69, 42" Left="74, 69, 42" Right="74, 69, 42" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Name="Edwardian Script ITC" />
          </Style>
          <Items>
            <PictureBox Value="Value" Width="7.7000002861023in" Height="0.799960613250732in" Left="0.199999968210856in" Top="0.0999999865889549in" Sizing="ScaleProportional" MimeType="image/png" Name="pictureBox1" />
          </Items>
        </PageHeaderSection>
      </Items>
      <PageSettings>
        <PageSettings PaperKind="Letter" Landscape="False" ColumnCount="2" ColumnSpacing="0in">
          <Margins>
            <MarginsU Left="0.2in" Right="0.2in" Top="0.2in" Bottom="0.2in" />
          </Margins>
          <BorderWidth Default="0in" />
        </PageSettings>
      </PageSettings>
    </Report>
  2. Peter
    Admin
    Peter avatar
    1611 posts

    Posted 31 Oct 2013 Link to this post

    Hi Garrett,

    We have reviewed the report definition and noticed that the report width is 8 inch. In order to set up correctly the multicolumn report you have to re-size the report to match the desired width of the columns. You can do this visually or by setting the Width property of the report in the Properties window.

    For more information check out the How to: Create a Multi-Column Report help article. Additionally you may find useful our Product Tag demo report that came with your Telerik Reporting installation

    Regards,
    Peter
    Telerik

    Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

  3. DevCraft banner
  4. Garrett
    Garrett avatar
    35 posts
    Member since:
    Feb 2012

    Posted 19 Nov 2013 Link to this post

    Hi Peter,

    sorry for the late reply.

    I have tried setting the report at various widths. The column is set to 4 inches wide, if I set the report to 8.1 with left and right margins of .2 to total 8.5 there is still only 1 column on the screen when there should be 2 columns with an extra .1 of space on the side (since there is no space between the columns).
  5. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 22 Nov 2013 Link to this post

    Hi Garrett,

    The following XML report definition is created based on the provided by you XML. We have set the Report.Width to 5in, set the Report.PageSettings.Landscape to true and Report.PageSettings.Margins to zero inches each:
    <?xml version="1.0" encoding="utf-8"?>
    <Report DataSourceName="sqlDataSource1" Width="5in" Name="guestlist" SnapGridSize="0.1in" xmlns="http://schemas.telerik.com/reporting/2012/3.3">
      <Style>
        <BorderWidth Default="0in" />
      </Style>
      <DataSources>
        <SqlDataSource ConnectionString="AdventureWorks" SelectCommand="select top(100) firstname, lastname, 10 as guests, 6 as children, 1 as street, 1 as city, phone, 10 as email, 1 as state, 1000 as zip from person.contact" Name="sqlDataSource1" />
      </DataSources>
      <Items>
        <DetailSection Height="1.8in" Name="detail">
          <Style>
            <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
            <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
          </Style>
          <Items>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.07in" Value="Name:" Name="textBox1">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.3in" Value="Guest Name:" Name="textBox4">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.5625in" Value="Children:" Name="textBox5">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.8in" Value="Address:" Name="textBox6">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.25in" Value="Phone:" Name="textBox8">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.5in" Value="Email:" Name="textBox9">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="None" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.0700000151991844in" Value="=Fields.FirstName + ' ' + Fields.LastName" Name="textBox10">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.0299999993294477in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.3in" Value="=Fields.Guests" Name="textBox11">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.5625in" Value="=Fields.Children" Name="textBox12">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.8in" Value="=Fields.Street" Name="textBox13">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1in" Value="=Fields.City + ', ' + Fields.State + ' ' + Fields.Zip " Name="textBox14">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.25in" Value="=Fields.Phone" Name="textBox15">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
            <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.5in" Value="= Fields.Email" Name="textBox16">
              <Style VerticalAlign="Middle">
                <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" />
                <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />
                <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
                <Font Size="9pt" />
                <Padding Left="0.03in" />
              </Style>
            </TextBox>
          </Items>
        </DetailSection>
        <PageHeaderSection Height="1in" Name="pageHeaderSection1">
          <Style BackgroundColor="238, 236, 225">
            <BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />
            <BorderColor Top="74, 69, 42" Bottom="74, 69, 42" Left="74, 69, 42" Right="74, 69, 42" />
            <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />
            <Font Name="Edwardian Script ITC" />
          </Style>
          <Items>
            <PictureBox Width="7.7000002861023in" Height="0.799960613250732in" Left="0.199999968210856in" Top="0.0999999865889549in" Sizing="ScaleProportional" MimeType="image/png" Name="pictureBox1" />
          </Items>
        </PageHeaderSection>
      </Items>
      <PageSettings>
        <PageSettings PaperKind="Letter" Landscape="True" ColumnCount="2" ColumnSpacing="0.2in">
          <Margins>
            <MarginsU Left="0in" Right="0in" Top="0in" Bottom="0in" />
          </Margins>
        </PageSettings>
      </PageSettings>
    </Report>

    Please compare both XML definitions and test the settings in your report.

    Regards,
    Stef
    Telerik

    New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

Back to Top