Display column sum in ASP.Net RDLC Report using C# and VB.Net

makumbi
 
on Mar 23, 2022 08:27 AM
1030 Views

Please help i wanted to get the grand total of the list below in RDLC report.

The value fee in the code below is passed from the webpage as a parameter value. i wanted to use that value and get the overall total i tried the sum value function but is gives me empty textbox.

No. Account Name Class Charge
1 1 AHURIRA EBENEZER P1 40000
2 23 AINEMBABAZI THALMA ETHEL P1 40000
3 32 BWANGO AALIYAH P1 40000
4 28 ITUNGO MANUELLA P1 40000
5 11 KARUNGI RABIB SALIM P1 40000
6 36 KYOBUTUNGI DORIS P1 40000
7 22-00039 MAKUMBI SULAIMAN P1 40000
8 24 MUKASA SWAIBU P1 40000
9 26 MUSIIME JORDAN P1 40000
10 22-00040 MUSOKE RASHID P1 40000
11 20 MUZIRAGA FABIAN P1 40000
12 38 NABAASA JOELLEN P1 40000
13 13 NABAASA JOELLEN P1 40000
Private Sub Report()
    'Dim dt As DataTable = GetData(DateTime.Parse(txtFrom.Text), DateTime.Parse(txtTo.Text))
    ' Try
    ' ReportViewer1.ProcessingMode = ProcessingMode.Local
 
    Dim fee As String = Request.QueryString("formfee")
    Dim classr As String = Request.QueryString("class")
    Dim intake As String = Request.QueryString("intake")
    Dim froms As String = Request.QueryString("From")
    Dim Tos As String = Request.QueryString("Tos")
    ReportViewer1.ProcessingMode = ProcessingMode.Local
    Dim dt As DataTable = GetData()
    ' If dt.Rows.Count > 0 Then
    'do stuff
    'gBox("dddd")
    'End If
 
    'calls the GetDate function which receives the from date and todate ,which are fetched from textboxs.
    Dim dt2 As DataTable = GetSPResult2022()
    Dim rds As New ReportDataSource("DataSet1", dt)
    'load the dataset and the datatable to reportDataSource.
    ReportViewer1.Visible = True
    'bind the reportDataSource with the report.
    ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/StudentCollection.rdlc")
    'Dim rpt As ReportParameter() = New ReportParameter() {New ReportParameter("From", froms), New ReportParameter("To", Tos), New ReportParameter("Fee", fee)}
    'just to display in textboxes from date and to date ,pass the parameters  .
    'Note:the first parameter of the ReportParameter() should be same as parameter in the report.rdlc
 
    Dim param As ReportParameter() = New ReportParameter(2) {}
    param(0) = New ReportParameter("Fees", fee)
    param(1) = New ReportParameter("Intake", intake)
    param(2) = New ReportParameter("Class", classr)
    ' param(0) = New ReportParameter("param2", Textbox2)
 
    '  ReportViewer1.LocalReport.DataSources.Clear()
 
    ReportViewer1.LocalReport.DataSources.Clear()
    ReportViewer1.LocalReport.SetParameters(param)
    'ReportViewer1.LocalReport.SetParameters(rpt)
    ReportViewer1.LocalReport.DataSources.Add(rds)
    ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DataSet2", dt2))
    ReportViewer1.LocalReport.Refresh()
 
    ' Catch ex As Exception
    'End Try
End Sub

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download