private void btnPriview_Click(object sender, EventArgs e) { if (radioAll.Checked == true) { SqlConnection connection = ConnectDB.GetSqlConnection(); // string query = "select Groups,Ledgers,Address,Mobile,SUM(Credit)-SUM(Debit) as Balance from Accounts where Date <= Convert(DateTime,'" + To.Text + "',103) group by Groups,Ledgers,Address,Mobile"; string query = "select a.Groups,SUM(a.Credit)-SUM(a.Debit) as Balance,L.Ledgers,L.Address,L.Mobile from Accounts a inner join Ledgers L on a.Ledgers_ID=L.LNo where (Convert(Datetime,a.Date,103) between Convert(Datetime,'" + From.Text + "',103) and Convert(Datetime,'" + To.Text + "',103)) group by a.Groups,L.Groups,L.Ledgers,L.Address,L.Mobile HAVING SUM(a.Credit)-SUM(a.Debit) <>0 order by L.Ledgers"; SqlDataAdapter ad1 = new SqlDataAdapter(query, connection); string query1 = "select * from Company"; SqlDataAdapter ad = new SqlDataAdapter(query1, connection); DSBalanceSheet DS = new DSBalanceSheet(); ad1.Fill(DS, "Accounts"); ad.Fill(DS, "Company"); rptBalanceSheets cr = new rptBalanceSheets(); //cr.SetDataSource(DS); cr.SetDataSource(DS); Print f2 = new Print(); f2.Show(); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition1; ParameterFieldDefinition crParameterFieldDefinition2; // ParameterFieldDefinition crParameterFieldDefinition3; //ParameterFieldDefinition crParameterFieldDefinition4; ParameterValues crParameterValues1 = new ParameterValues(); ParameterValues crParameterValues2 = new ParameterValues(); // ParameterValues crParameterValues3 = new ParameterValues(); //ParameterValues crParameterValues4 = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue(); ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue(); // ParameterDiscreteValue crParameterDiscreteValue3 = new ParameterDiscreteValue(); //ParameterDiscreteValue crParameterDiscreteValue4 = new ParameterDiscreteValue(); crParameterDiscreteValue1.Value = From.Text; crParameterDiscreteValue2.Value = To.Text; //crParameterDiscreteValue3.Value = txtDueAmount.Text; //crParameterDiscreteValue4.Value = txtPaid.Text; crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; crParameterFieldDefinition1 = crParameterFieldDefinitions["From"]; crParameterFieldDefinition2 = crParameterFieldDefinitions["To"]; //crParameterFieldDefinition3 = crParameterFieldDefinitions["Due Amount"]; //crParameterFieldDefinition4 = crParameterFieldDefinitions["Paid"]; crParameterValues1 = crParameterFieldDefinition1.CurrentValues; crParameterValues2 = crParameterFieldDefinition2.CurrentValues; //crParameterValues3 = crParameterFieldDefinition3.CurrentValues; //crParameterValues4 = crParameterFieldDefinition4.CurrentValues; crParameterValues1.Add(crParameterDiscreteValue1); crParameterValues2.Add(crParameterDiscreteValue2); //crParameterValues3.Add(crParameterDiscreteValue3); //crParameterValues4.Add(crParameterDiscreteValue4); crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1); crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2); f2.crystalReportViewer1.ReportSource = cr; f2.crystalReportViewer1.Refresh(); } if (radioRanged.Checked == true) { SqlConnection connection = ConnectDB.GetSqlConnection(); // string query = "select Groups,Ledgers,Address,Mobile,SUM(Credit)-SUM(Debit) as Balance from Accounts where Date <= Convert(DateTime,'" + To.Text + "',103) group by Groups,Ledgers,Address,Mobile"; string query = "select a.Groups,SUM(a.Credit)-SUM(a.Debit) as Balance,L.Ledgers,L.Address,L.Mobile from Accounts a inner join Ledgers L on a.Ledgers_ID=L.LNo where a.Groups='" + cmbGroups.Text + "' and (Convert(Datetime,a.Date,103) between Convert(Datetime,'" + From.Text + "',103) and Convert(Datetime,'" + To.Text + "',103)) group by a.Groups,L.Groups,L.Ledgers,L.Address,L.Mobile HAVING SUM(a.Credit)-SUM(a.Debit) <>0 order by L.Ledgers"; SqlDataAdapter ad1 = new SqlDataAdapter(query, connection); string query1 = "select * from Company"; SqlDataAdapter ad = new SqlDataAdapter(query1, connection); DSBalanceSheet DS = new DSBalanceSheet(); ad1.Fill(DS, "Accounts"); ad.Fill(DS, "Company"); rptBalanceSheets cr = new rptBalanceSheets(); //cr.SetDataSource(DS); cr.SetDataSource(DS); Print f2 = new Print(); f2.Show(); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition1; ParameterFieldDefinition crParameterFieldDefinition2; // ParameterFieldDefinition crParameterFieldDefinition3; //ParameterFieldDefinition crParameterFieldDefinition4; ParameterValues crParameterValues1 = new ParameterValues(); ParameterValues crParameterValues2 = new ParameterValues(); // ParameterValues crParameterValues3 = new ParameterValues(); //ParameterValues crParameterValues4 = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue(); ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue(); // ParameterDiscreteValue crParameterDiscreteValue3 = new ParameterDiscreteValue(); //ParameterDiscreteValue crParameterDiscreteValue4 = new ParameterDiscreteValue(); crParameterDiscreteValue1.Value = From.Text; crParameterDiscreteValue2.Value = To.Text; //crParameterDiscreteValue3.Value = txtDueAmount.Text; //crParameterDiscreteValue4.Value = txtPaid.Text; crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; crParameterFieldDefinition1 = crParameterFieldDefinitions["From"]; crParameterFieldDefinition2 = crParameterFieldDefinitions["To"]; //crParameterFieldDefinition3 = crParameterFieldDefinitions["Due Amount"]; //crParameterFieldDefinition4 = crParameterFieldDefinitions["Paid"]; crParameterValues1 = crParameterFieldDefinition1.CurrentValues; crParameterValues2 = crParameterFieldDefinition2.CurrentValues; //crParameterValues3 = crParameterFieldDefinition3.CurrentValues; //crParameterValues4 = crParameterFieldDefinition4.CurrentValues; crParameterValues1.Add(crParameterDiscreteValue1); crParameterValues2.Add(crParameterDiscreteValue2); //crParameterValues3.Add(crParameterDiscreteValue3); //crParameterValues4.Add(crParameterDiscreteValue4); crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1); crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2); f2.crystalReportViewer1.ReportSource = cr; f2.crystalReportViewer1.Refresh(); } }