void calReport() { XtraRepSummaryLedger obj_Rpt = new XtraRepSummaryLedger(); SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet(); string strquery = String.Format("SELECT PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName,COALESCE(SUM(TaxPayable), 0) Assessment, COALESCE(SUM(PaymentAmount), 0) Payment, COALESCE(SUM(TaxPayable), 0) - COALESCE(SUM(PaymentAmount), 0) Differences FROM dbo.ViewPayerLedger GROUP BY PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName ORDER BY RevenueOfficeName asc"); using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString)) { connect.Open(); _command = new SqlCommand(strquery, connect) { CommandType = CommandType.Text }; _command.CommandTimeout = 0; responses.Clear(); _adp = new SqlDataAdapter(_command); _adp.Fill(responses); connect.Close(); } if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 1) { // obj_Rpt.xrLabel10.Text = string.Format("As At: {0:dddd, d MMMM,yyyy} ", DateTime.Now); obj_Rpt.Report.DataSource = responses; obj_Rpt.Report.DataMember = responses.Tables[0].TableName; ASPxWebDocumentViewer1.OpenReport(obj_Rpt); } }
void calReport() { var varyear = Session["Fromyear"].ToString(); var varto = Session["Toyear"].ToString(); var revenuename = Session["Revenuename"].ToString(); XtraRepSummaryLedger obj_Rpt = new XtraRepSummaryLedger(); SqlCommand _command; SqlDataAdapter _adp; System.Data.DataSet responses = new System.Data.DataSet(); string strquery = String.Format("SELECT PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName,COALESCE(SUM(TaxPayable), 0) Assessment, COALESCE(SUM(PaymentAmount), 0) Payment, COALESCE(SUM(TaxPayable), 0) - COALESCE(SUM(PaymentAmount), 0) Differences FROM dbo.ViewPayerLedger WHERE RevenueOfficeName='{0}' AND AssessmentYear BETWEEN {1} AND {2} GROUP BY PayerUtin, PayerName, RevenueOfficeID,RevenueOfficeName ORDER BY RevenueOfficeName asc", revenuename, varyear, varto); using (SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["Registration2ConnectionString"].ConnectionString)) { connect.Open(); _command = new SqlCommand(strquery, connect) { CommandType = CommandType.Text }; _command.CommandTimeout = 0; responses.Clear(); _adp = new SqlDataAdapter(_command); _adp.Fill(responses); connect.Close(); } if (responses.Tables[0] != null && responses.Tables[0].Rows.Count > 0) { obj_Rpt.xrLabel9.Text = string.Format("Tax Assessments & Payments"); obj_Rpt.xrLabel10.Text = string.Format("Tax Office - Taxpayers Summary "); //xrLabel11 obj_Rpt.xrLabel11.Text = string.Format("From: {0} To: {1}", varyear, varto); obj_Rpt.Report.DataSource = responses; obj_Rpt.Report.DataMember = responses.Tables[0].TableName; ASPxWebDocumentViewer1.OpenReport(obj_Rpt); } }