private void btnViewReport_Click(object sender, EventArgs e) { if (cbVessel.Text.Equals(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.cboDefaultText)) MessageBox.Show(this, "Please choose vessel", "Information"); else if(etVoy.Text.Trim().Length == 0) MessageBox.Show(this, "Please fill voy", "Information"); else if (pickerATD.Value.Date > DateTime.Now.Date) MessageBox.Show(this, "ATD must be lower from today", "Information"); else { string query = CreateSelectQueryAndParameters(); if (!query.Contains("Column")) { MessageBox.Show("No selection to display!"); return; } objReportContainer = new RptContainer(); try { SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString); SqlDataAdapter da = new SqlDataAdapter(query, VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString); ShippingMainDataSet ds = new ShippingMainDataSet(); da.Fill(ds, "CONTAINER"); objReportContainer.SetDataSource(ds); crystalReportViewerContainer.ReportSource = objReportContainer; } catch (SqlException sqlEx) { MessageBox.Show(sqlEx.Message); } catch (Exception Ex) { MessageBox.Show(Ex.Message); } } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RptContainer rpt = new RptContainer(); rpt.Site = this.Site; return rpt; }