public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SPR_PQPending rpt = new SPR_PQPending(); rpt.Site = this.Site; return(rpt); }
private void SPR_PQCompleted_PrintScreen_Load(object sender, EventArgs e) { //---MYSQL CONNECTION connection = new MySqlConnection(ConnectionStringManager.reicpomsConnection.ConnectionString); connection.Open(); //---SELECT Statements reicpomsds = new reicpomsDataSet(); //Data from PQ Customers (Need the DISTINCT, else will result to ConstraintException) string selectPQCustomers = string.Format("SELECT DISTINCT customer_t.* " + "FROM customer_t, pq_t, po_t " + "WHERE pq_t.pq_no NOT IN (" + "SELECT po_t.pq_no " + "FROM po_t " + "WHERE pq_t.pq_no = po_t.pq_no) " + "AND pq_t.customer_id = customer_t.customer_id " + "ORDER BY pq_t.pq_no DESC;"); adapter = new MySqlDataAdapter(selectPQCustomers, connection); adapter.Fill(reicpomsds, "customer_t"); //Data from pq_t string selectPendingPQ = string.Format("SELECT DISTINCT pq_t.* " + "FROM pq_t, po_t " + "WHERE pq_t.pq_no NOT IN(" + "SELECT po_t.pq_no " + "FROM po_t " + "WHERE pq_t.pq_no = po_t.pq_no) " + "ORDER BY pq_t.pq_no DESC;"); adapter = new MySqlDataAdapter(selectPendingPQ, connection); adapter.Fill(reicpomsds, "pq_t"); connection.Close(); //---INSTANTIATE CRYSTAL REPORT SPR_PQPending pqp = new SPR_PQPending(); pqp.Load(); pqp.SetDataSource(reicpomsds); //Added a code snippet in app.config file. If else, will result to a System.IOFileNotFoundException error. //---EXPORT TO PDF string currentDateTime = DateTime.Now.ToString("yyyy-MM-dd hhmmtt"); string filePath = "C:\\REIC Files\\Sales Performance Report & Summary\\Price Quotations - Pending\\Pending PQ (" + currentDateTime + ").pdf"; pqp.ExportToDisk(ExportFormatType.PortableDocFormat, filePath); MessageBox.Show("A PDF file of this report on pending price quotations can be found in \nC:\\REIC Files\\Sales Performance Report & Summary\\Price Quotations - Pending."); CrystalReportViewer.ReportSource = pqp; }