Click here to Skip to main content
16,020,381 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:
VB
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
Posted
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900