Private Sub SingleStudent() ReportViewer1.ProcessingMode = ProcessingMode.Local ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reporting/Report38.rdlc") Dim dsCustomers As Customers = GetData("SELECT dbo.MonthlyFeeGenrate.*, dbo.School_Info.* FROM dbo.MonthlyFeeGenrate CROSS JOIN dbo.School_Info where MonthlyFeeGenrate.registration_id = '" & getcurrentinfo.Text & "' AND MonthlyFeeGenrate.Fee_Month = '" & getmonth.Text & "'AND MonthlyFeeGenrate.Fee_Year = '" & getyear.Text & "' AND MonthlyFeeGenrate.School_id = '" & schoolID.Text & "'AND MonthlyFeeGenrate.Received_Fee = '0'") Dim datasource As New ReportDataSource("DataSet1", dsCustomers.Tables(0)) ReportViewer1.LocalReport.DataSources.Clear() ReportViewer1.LocalReport.DataSources.Add(datasource) End Sub
GetData("SELECT dbo.MonthlyFeeGenrate.*, dbo.School_Info.* FROM dbo.MonthlyFeeGenrate CROSS JOIN dbo.School_Info where MonthlyFeeGenrate.registration_id = '" & getcurrentinfo.Text & "' AND MonthlyFeeGenrate.Fee_Month = '" & getmonth.Text & "'AND MonthlyFeeGenrate.Fee_Year = '" & getyear.Text & "' AND MonthlyFeeGenrate.School_id = '" & schoolID.Text & "'AND MonthlyFeeGenrate.Received_Fee = '0'")
GetData
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)