public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
SPR_POCompleted rpt = new SPR_POCompleted();
rpt.Site = this.Site;
return(rpt);
}
private void SPR_POCompleted_PrintScreen_Load(object sender, EventArgs e)
{
//---MYSQL CONNECTION
connection = new MySqlConnection(ConnectionStringManager.reicpomsConnection.ConnectionString);
connection.Open();
//---SELECT Statements
reicpomsds = new reicpomsDataSet();
//Data from PO Suppliers (Added DISTINCT for safety, I guess. To avoid ConstraintException)
string selectPOSuppliers = string.Format("SELECT DISTINCT supplier_t.* " +
"FROM supplier_t, po_t " +
"WHERE so_no IS NOT NULL " +
"AND po_t.supplier_id = supplier_t.supplier_id " +
"ORDER BY po_no DESC;");
adapter = new MySqlDataAdapter(selectPOSuppliers, connection);
adapter.Fill(reicpomsds, "supplier_t");
//Data from PO Customers (Added DISTINCT to avoid possible Constraint Exception)
string selectPOCustomers = string.Format("SELECT DISTINCT customer_t.* " +
"FROM customer_t, po_t " +
"WHERE so_no IS NOT NULL " +
"AND po_t.customer_id = customer_t.customer_id " +
"ORDER BY po_no DESC;");
adapter = new MySqlDataAdapter(selectPOCustomers, connection);
adapter.Fill(reicpomsds, "customer_t");
//Data from po_t
string selectCompletedPO = "SELECT * FROM po_t WHERE so_no IS NOT NULL ORDER BY po_no DESC;";
adapter = new MySqlDataAdapter(selectCompletedPO, connection);
adapter.Fill(reicpomsds, "po_t");
connection.Close();
//---INSTANTIATE CRYSTAL REPORT
SPR_POCompleted poc = new SPR_POCompleted();
poc.Load();
poc.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\\Purchase Orders - Completed\\Completed PO (" + currentDateTime + ").pdf";
poc.ExportToDisk(ExportFormatType.PortableDocFormat, filePath);
MessageBox.Show("A PDF file of this report on completed purchase orders can be found in \n:\\REIC Files\\Sales Performance Report & Summary\\Purchase Orders - Completed.");
CrystalReportViewer.ReportSource = poc;
}