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;
}
