pandeysk_13 0 Newbie Poster

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