private void Submit_btn_Click(object sender, EventArgs e)
{
SqlConnection cnn;
string connectionString = null;
string sql = null;
connectionString = ConfigurationManager.ConnectionStrings["coonstring"].ConnectionString;
cnn = new SqlConnection(connectionString);
cnn.Open();
sql = "SELECT BillNo,Date,Grandtotal,BrannchName,Location,PhoneNo FROM Tbl_Sales inner join Tbl_BranchMaster on Tbl_BranchMaster.BranchId=1 where Tbl_Sales.Date between'" + From_dateTimePicker.Text + "'and '" + To_dateTimePicker.Text + "'";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
SalesReportDataSet ds = new SalesReportDataSet();
dscmd.Fill(ds);
// MessageBox.Show(ds.Tables[1].Rows.Count.ToString());
cnn.Close();
SalesCrystalReport objRpt = new SalesCrystalReport();
objRpt.SetDataSource(ds.Tables[1]);
SalesReportViewer.ReportSource = objRpt;
SalesReportViewer.Refresh();
}
private void ShowReport()
{
var settings = services.GetSettings();
switch (ReportType)
{
case ReportType.History:
HistoryCrystalReport report = new HistoryCrystalReport();
report.SetDataSource(DataSource);
viewer.ReportSource = report;
report.DataDefinition.FormulaFields["Company"].Text = FormulaFieldBuilder(settings.Company);
report.DataDefinition.FormulaFields["Address"].Text = FormulaFieldBuilder(settings.Address);
report.DataDefinition.FormulaFields["TIN"].Text = FormulaFieldBuilder(settings.TIN);
report.DataDefinition.FormulaFields["ProgramAndVersion"].Text = FormulaFieldBuilder(Properties.Settings.Default.ProgramVersion);
report.DataDefinition.FormulaFields["Serial"].Text = FormulaFieldBuilder(Properties.Settings.Default.SN);
report.DataDefinition.FormulaFields["Min"].Text = FormulaFieldBuilder(Properties.Settings.Default.MIN);
report.DataDefinition.FormulaFields["DateCovered"].Text = FormulaFieldBuilder(this.DateCovered);
report.DataDefinition.FormulaFields["Username"].Text = FormulaFieldBuilder(Properties.Settings.Default.Username);
ReportDocument = report;
this.Text = "History Report";
break;
case ReportType.DetailedTransactionSummaryReport:
DetailedTransactionCrystalReport detailedreport = new DetailedTransactionCrystalReport();
detailedreport.SetDataSource(DataSource);
viewer.ReportSource = detailedreport;
detailedreport.DataDefinition.FormulaFields["Company"].Text = FormulaFieldBuilder(settings.Company);
detailedreport.DataDefinition.FormulaFields["Address"].Text = FormulaFieldBuilder(settings.Address);
detailedreport.DataDefinition.FormulaFields["TIN"].Text = FormulaFieldBuilder(settings.TIN);
detailedreport.DataDefinition.FormulaFields["ProgramAndVersion"].Text = FormulaFieldBuilder(Properties.Settings.Default.ProgramVersion);
detailedreport.DataDefinition.FormulaFields["Serial"].Text = FormulaFieldBuilder(Properties.Settings.Default.SN);
detailedreport.DataDefinition.FormulaFields["Min"].Text = FormulaFieldBuilder(Properties.Settings.Default.MIN);
detailedreport.DataDefinition.FormulaFields["DateCovered"].Text = FormulaFieldBuilder(this.DateCovered);
detailedreport.DataDefinition.FormulaFields["Username"].Text = FormulaFieldBuilder(Properties.Settings.Default.Username);
ReportDocument = detailedreport;
break;
case ReportType.Sales:
SalesCrystalReport salesreport = new SalesCrystalReport();
salesreport.SetDataSource(DataSource);
viewer.ReportSource = salesreport;
salesreport.DataDefinition.FormulaFields["Company"].Text = FormulaFieldBuilder(settings.Company);
salesreport.DataDefinition.FormulaFields["Address"].Text = FormulaFieldBuilder(settings.Address);
salesreport.DataDefinition.FormulaFields["TIN"].Text = FormulaFieldBuilder(settings.TIN);
salesreport.DataDefinition.FormulaFields["ProgramAndVersion"].Text = FormulaFieldBuilder(Properties.Settings.Default.ProgramVersion);
salesreport.DataDefinition.FormulaFields["Serial"].Text = FormulaFieldBuilder(Properties.Settings.Default.SN);
salesreport.DataDefinition.FormulaFields["Min"].Text = FormulaFieldBuilder(Properties.Settings.Default.MIN);
salesreport.DataDefinition.FormulaFields["DateCovered"].Text = FormulaFieldBuilder(this.DateCovered);
salesreport.DataDefinition.FormulaFields["Username"].Text = FormulaFieldBuilder(Properties.Settings.Default.Username);
ReportDocument = salesreport;
break;
case ReportType.CashlessReport:
CashlessCrystalReport cashless = new CashlessCrystalReport();
cashless.SetDataSource(DataSource);
viewer.ReportSource = cashless;
cashless.DataDefinition.FormulaFields["Company"].Text = FormulaFieldBuilder(settings.Company);
cashless.DataDefinition.FormulaFields["Address"].Text = FormulaFieldBuilder(settings.Address);
cashless.DataDefinition.FormulaFields["TIN"].Text = FormulaFieldBuilder(settings.TIN);
cashless.DataDefinition.FormulaFields["ProgramAndVersion"].Text = FormulaFieldBuilder(Properties.Settings.Default.ProgramVersion);
cashless.DataDefinition.FormulaFields["Serial"].Text = FormulaFieldBuilder(Properties.Settings.Default.SN);
cashless.DataDefinition.FormulaFields["Min"].Text = FormulaFieldBuilder(Properties.Settings.Default.MIN);
cashless.DataDefinition.FormulaFields["DateCovered"].Text = FormulaFieldBuilder(this.DateCovered);
cashless.DataDefinition.FormulaFields["Username"].Text = FormulaFieldBuilder(Properties.Settings.Default.Username);
ReportDocument = cashless;
break;
case ReportType.RegularParker:
RegularParkerReport regular = new RegularParkerReport();
regular.SetDataSource(DataSource);
viewer.ReportSource = regular;
regular.DataDefinition.FormulaFields["Company"].Text = FormulaFieldBuilder(settings.Company);
regular.DataDefinition.FormulaFields["Address"].Text = FormulaFieldBuilder(settings.Address);
regular.DataDefinition.FormulaFields["TIN"].Text = FormulaFieldBuilder(settings.TIN);
regular.DataDefinition.FormulaFields["ProgramAndVersion"].Text = FormulaFieldBuilder(Properties.Settings.Default.ProgramVersion);
regular.DataDefinition.FormulaFields["Serial"].Text = FormulaFieldBuilder(Properties.Settings.Default.SN);
regular.DataDefinition.FormulaFields["Min"].Text = FormulaFieldBuilder(Properties.Settings.Default.MIN);
regular.DataDefinition.FormulaFields["DateCovered"].Text = FormulaFieldBuilder(this.DateCovered);
regular.DataDefinition.FormulaFields["Username"].Text = FormulaFieldBuilder(Properties.Settings.Default.Username);
ReportDocument = regular;
break;
case ReportType.AuditTrail:
AuditTrailReport audit = new AuditTrailReport();
audit.SetDataSource(DataSource);
viewer.ReportSource = audit;
audit.DataDefinition.FormulaFields["Company"].Text = FormulaFieldBuilder(settings.Company);
audit.DataDefinition.FormulaFields["Address"].Text = FormulaFieldBuilder(settings.Address);
audit.DataDefinition.FormulaFields["TIN"].Text = FormulaFieldBuilder(settings.TIN);
audit.DataDefinition.FormulaFields["ProgramAndVersion"].Text = FormulaFieldBuilder(Properties.Settings.Default.ProgramVersion);
audit.DataDefinition.FormulaFields["Serial"].Text = FormulaFieldBuilder(Properties.Settings.Default.SN);
audit.DataDefinition.FormulaFields["Min"].Text = FormulaFieldBuilder(Properties.Settings.Default.MIN);
audit.DataDefinition.FormulaFields["DateCovered"].Text = FormulaFieldBuilder(this.DateCovered);
audit.DataDefinition.FormulaFields["Username"].Text = FormulaFieldBuilder(Properties.Settings.Default.Username);
ReportDocument = audit;
break;
}
viewer.Show();
viewer.RefreshReport();
}
