vb.net repeat data on RDLC report horizontally then vertically

Abanoub Zak 36 Reputation points
2022-03-07T13:58:17.107+00:00

I was using crystal report on vb.net application to create this report
CrystalReportSample
So if the user what to print 26 labels he can on A4 Paper Uncountably I wasn't able to achieve that on RDLC My code is Simple I have table called Temp with 5 Strings values and I populate it as the following:

Dim DT As New DataTable  
    DT.TableName = "Temp"  
    DT.Columns.Add("BarcodeId", Type.GetType("System.String"))  
    DT.Columns.Add("BarcodePrice", Type.GetType("System.String"))  
    DT.Columns.Add("BarcodeLabel", Type.GetType("System.String"))  
    DT.Columns.Add("CurrencyType", Type.GetType("System.String"))  
    DT.Columns.Add("Store", Type.GetType("System.String"))  
    DT.Clear()  
    For i = 1 To 1  
    DT.Rows.Add(Label4.Text, Price.Text, Item_NameTextBox.Text, combobox1z, Main.Companylabel2.Text)  
    Next  
    ReportViewer1.Invoke(Sub() ReportViewer1.LocalReport.DataSources.Clear())  
    ReportViewer1.Invoke(Sub() ReportViewer1.LocalReport.ReportPath = "D:\AZFTSAIO\AZFTS\RDLC Reports\Report2No.rdlc")  
    ReportViewer1.Invoke(Sub() ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", DT)))  
    ReportViewer1.Invoke(Sub() ReportViewer1.RefreshReport())  

Now the Problem is I'm not able to repeat the data based on rows number. I need the page to hold 44 labels 4 horizontally * 11 vertically

Developer technologies | VB
{count} votes

1 answer

Sort by: Most helpful
  1. Jiachen Li-MSFT 34,231 Reputation points Microsoft External Staff
    2022-03-08T06:39:03.327+00:00

    Hi @Abanoub Zak ,
    You can modify your report by referring to the solution in the questions below.
    Create Employee Card By Reporting Services
    Multi Column Report - printing Across and then Down
    Or use Tablix control.
    https://www.grapecity.com/blogs/how-to-create-a-label-report-using-tablix
    Best Regards.
    Jiachen Li

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.