public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CreditVoucherByExpenserystalReport rpt = new CreditVoucherByExpenserystalReport();
rpt.Site = this.Site;
return rpt;
}
public void Read(string srr)
{
//SqlConnection conn = new SqlConnection(this.connectionString);
//SqlCommand comm = new SqlCommand("dbo.UspCreditVoucherExpenseWiseReport", conn);
//comm.CommandType = CommandType.StoredProcedure;
//comm.Parameters.Add("@Expense", SqlDbType.VarChar, 50);
//comm.Parameters["@Expense"].Value = comboBox1.Text;
//SqlDataAdapter adap = new SqlDataAdapter();
//DataSets.CreditVoucher dataset = new DataSets.CreditVoucher();
//Reports.CreditVoucherByExpenserystalReport crp = new Reports.CreditVoucherByExpenserystalReport();
//try
//{
// conn.Open();
// adap.SelectCommand = comm;
// adap.Fill(dataset, "DataTable1");
// crp.SetDataSource(dataset);
// crystalReportViewer1.ReportSource = crp;
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message.ToString());
//}
//finally
//{
// conn.Close();
//}
this.reportQuary = dateTimePicker1.Text + " to " + dateTimePicker2.Text;
string query = "";
query = "Select * From TbDailyExpense Where ExpenseDate BETWEEN '" + dateTimePicker1.Value.Date + "' AND '" + dateTimePicker2.Value.Date + "' AND Expense = @Expense Order By ExpenseDate";
if (query != "")
{
SqlConnection conn = new SqlConnection(this.connectionString);
SqlCommand comm = new SqlCommand(query, conn);
comm.Parameters.Add("@Expense", SqlDbType.VarChar, 50);
comm.Parameters["@Expense"].Value = comboBox1.Text;
SqlDataAdapter adap = new SqlDataAdapter();
DataSets.CreditVoucher dataset = new DataSets.CreditVoucher();
CreditVoucherByExpenserystalReport crp = new CreditVoucherByExpenserystalReport();
try
{
conn.Open();
adap.SelectCommand = comm;
adap.Fill(dataset, "DataTable1");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}
crp.SetDataSource(dataset);
ParameterValues v = new ParameterValues();
ParameterDiscreteValue dv = new ParameterDiscreteValue();
dv = new ParameterDiscreteValue();
dv.Value = this.reportQuary;
v.Add(dv);
crp.DataDefinition.ParameterFields["report_query"].ApplyCurrentValues(v);
crystalReportViewer2.ReportSource = crp;
}
}