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