how to set rdlc report tablix to show record in one page

See more:

VB

hi all,

i am in trouble to solve this.

i want to show the report in the manner in which the tablix column 1 record should continue in the

same page in column 2.

LIKE THIS:

column1      column 2

1                      6

2                     7

3                     8

4                     9

5                     10

and if their is space in the page just continues.

and if not go to next page.

i am filling my report with this code:

Conn.Open()
Dim sReportDataSource As New ReportDataSource
Dim drow As DataRow
Dim row As DataRow = Nothing
Dim DS As New DataSet
Dim dt As New DataTable
DS.Tables.Add("tblstudentsregistrationBA")
drow = dt.NewRow
'ADD THE COLUMNS TO THE TABLE
With DS.Tables(0).Columns
                      .Add("BA_I_roll_number", Type.GetType("System.String"))

End With
For Each dr As DataGridViewRow In DGVfinal.Rows

    row("BA_I_roll_number") = dr.Cells("rollnumber").Value.ToString

    DS.Tables(0).Rows.Add(row)
Next
'Create a report parameter for the sales order number
sReportDataSource.Name = "DataSet1"
sReportDataSource.Value = DS.Tables(0)
RDLCreportview.ReportViewer1.LocalReport.ReportPath = Application.StartupPath & "\Reports\classsubjectlistBA.rdlc"
RDLCreportview.ReportViewer1.LocalReport.DataSources.Add(sReportDataSource)
Dim rpEmployeeSSN As New ReportParameter()
rpEmployeeSSN.Name = "course"
rpEmployeeSSN.Values.Add(" Course :- " & cmbcourse.Text & "")

'Set the report parameters for the report
Dim parameters() As ReportParameter = {rpEmployeeSSN}
RDLCreportview.ReportViewer1.LocalReport.SetParameters(parameters)

RDLCreportview.ReportViewer1.SetDisplayMode(DisplayMode.PrintLayout)
RDLCreportview.ReportViewer1.RefreshReport()
DS.Dispose()
DS = Nothing
RDLCreportview.ShowDialog()
RDLCreportview.Dispose()
Conn.Close()

SOME one suggest me to use two tablix with expression:

the expression i used in first tablix: =iif(rownumber(nothing)<30,Fields!BA_I_roll_number.Value,"")

but it is not giving result
for second the expression used: =iif(rownumber(nothing)>=30,"",Fields!BA_I_roll_number.Value)
kindly help me for this.

thanks in Advance