public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptBalanceSheets rpt = new rptBalanceSheets();
rpt.Site = this.Site;
return(rpt);
}
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();
}
}