none
Multi Column RDLC (Mailing labels) RRS feed

  • Question

  • Hi
    Can anyone help me create a multicolumn rdlc report? I am trying to print mailing labels with an ASP.NET 3.5 web app in VS 2008.
    Combing the net, got me this link  http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=30&threadid=640959. A poster named Jakob suggests, setting the reports to 3 columns. I tried but the data prints down along only the first (leftmost) column. it does not flow from 1 column to next, as necessary for label printing.
    Jakob also suggest using a list control. I couldn't get it to work either way.
    I could not find any other helpful links or resources.
    Here is my relevant RDLC markup. (I simply removed all field names etc..)

    1 <?xml version="1.0" encoding="utf-8"?>  
    2 <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">  
    3   <DataSources> 
    4     <DataSource Name="cnsMainBase">  
    5       <rd:DataSourceID>37a4e4c0-6808-4237-8b2c-706d8e59c353</rd:DataSourceID> 
    6       <ConnectionProperties> 
    7         <DataProvider>SQL</DataProvider> 
    8         <ConnectString /> 
    9       </ConnectionProperties> 
    10     </DataSource> 
    11   </DataSources> 
    12   <InteractiveHeight>29.7cm</InteractiveHeight> 
    13   <rd:DrawGrid>true</rd:DrawGrid> 
    14   <InteractiveWidth>21cm</InteractiveWidth> 
    15   <rd:GridSpacing>0.25cm</rd:GridSpacing> 
    16   <rd:SnapToGrid>true</rd:SnapToGrid> 
    17   <RightMargin>2.5cm</RightMargin> 
    18   <LeftMargin>2.5cm</LeftMargin> 
    19   <BottomMargin>1cm</BottomMargin> 
    20   <rd:ReportID>ec7ff1a2-d880-4ee5-b2e3-173f06885eec</rd:ReportID> 
    21   <PageWidth>21cm</PageWidth> 
    22   <DataSets> 
    23     <DataSet Name="MainBaseDataSet_viwPersons">  
    24       <Fields>          
    25       </Fields> 
    26       <Query> 
    27         <DataSourceName>cnsMainBase</DataSourceName> 
    28         <CommandText>SELECT * FROM dbo.viwPersons</CommandText> 
    29         <rd:UseGenericDesigner>true</rd:UseGenericDesigner> 
    30       </Query> 
    31       <rd:DataSetInfo> 
    32         <rd:DataSetName>MainBaseDataSet</rd:DataSetName> 
    33         <rd:TableName>viwPersons</rd:TableName> 
    34         <rd:TableAdapterName>viwPersonsTableAdapter</rd:TableAdapterName> 
    35         <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod> 
    36         <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod> 
    37       </rd:DataSetInfo> 
    38     </DataSet> 
    39   </DataSets> 
    40   <Code /> 
    41   <Width>6cm</Width> 
    42   <Body> 
    43     <ColumnSpacing>0cm</ColumnSpacing> 
    44     <ReportItems> 
    45       <List Name="list1">  
    46         <DataSetName>MainBaseDataSet_viwPersons</DataSetName> 
    47         <ReportItems> 
    48           <Textbox Name="PersonNameH">  
    49             <rd:DefaultName>PersonNameH</rd:DefaultName> 
    50             <Width>5.75cm</Width> 
    51             <Style> 
    52               <PaddingLeft>2pt</PaddingLeft> 
    53               <PaddingRight>2pt</PaddingRight> 
    54               <PaddingTop>2pt</PaddingTop> 
    55               <PaddingBottom>2pt</PaddingBottom> 
    56             </Style> 
    57             <CanGrow>true</CanGrow> 
    58             <Value>=Fields!PersonNameH.Value</Value> 
    59           </Textbox> 
    60         </ReportItems> 
    61         <Width>5.78968cm</Width> 
    62         <Height>0.63492cm</Height> 
    63       </List> 
    64     </ReportItems> 
    65     <Height>1cm</Height> 
    66     <Columns>3</Columns> 
    67   </Body> 
    68   <Language>en-US</Language> 
    69   <TopMargin>1cm</TopMargin> 
    70   <PageHeight>29.7cm</PageHeight> 
    71 </Report> 

    I would appreciate all and any advice/links/suggestions etc
    Thank you all for taking your time to help out

    Monday, March 9, 2009 8:44 AM