private void butMissing_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; Font font = new Font("Tahoma", 9); Font fontTitle = new Font("Tahoma", 17, FontStyle.Bold); Font fontSubTitle = new Font("Tahoma", 10, FontStyle.Bold); ReportComplex report = new ReportComplex(true, false); report.ReportName = "Missing"; report.AddTitle("Title", "XCharge Transactions From " + date1.SelectionStart.ToShortDateString() + " To " + date2.SelectionStart.ToShortDateString(), fontTitle); report.GetTitle("Title").IsUnderlined = true; report.AddSubTitle("SubTitle", "No Matching Transaction Found in Open Dental", fontSubTitle); QueryObject query; DataTable dt = XChargeTransactions.GetMissingPaymentsTable(date1.SelectionStart, date2.SelectionStart); query = report.AddQuery(dt, "Missing Payments", "", SplitByKind.None, 1, true); //Valid entries to count have result code 0 query.AddColumn("Transaction Date/Time", 170, FieldValueType.String, font); query.AddColumn("Transaction Type", 120, FieldValueType.String, font); query.AddColumn("Clerk ID", 80, FieldValueType.String, font); query.AddColumn("Item#", 50, FieldValueType.String, font); query.AddColumn("Pat", 50, FieldValueType.String, font); query.AddColumn("Credit Card Num", 140, FieldValueType.String, font); query.AddColumn("Exp", 50, FieldValueType.String, font); query.AddColumn("Result", 50, FieldValueType.String, font); query.AddColumn("Amount", 60, FieldValueType.Number, font); query.GetColumnHeader("Amount").ContentAlignment = ContentAlignment.MiddleRight; Cursor = Cursors.Default; if (!report.SubmitQueries(true)) { return; } // display report FormReportComplex FormR = new FormReportComplex(report); //FormR.MyReport=report; FormR.ShowDialog(); }
private void butExtra_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; Font font = new Font("Tahoma", 9); Font fontTitle = new Font("Tahoma", 17, FontStyle.Bold); Font fontSubTitle = new Font("Tahoma", 10, FontStyle.Bold); ReportComplex report = new ReportComplex(true, false); report.ReportName = "Extra Payments"; report.AddTitle("Title", "Payments From " + date1.SelectionStart.ToShortDateString() + " To " + date2.SelectionStart.ToShortDateString(), fontTitle); report.GetTitle("Title").IsUnderlined = true; report.AddSubTitle("SubTitle", "No Matching X-Charge Transactions for these Payments", fontSubTitle); QueryObject query; DataTable dt = XChargeTransactions.GetMissingXTransTable(date1.SelectionStart, date2.SelectionStart); query = report.AddQuery(dt, "Extra Payments", "", SplitByKind.None, 1, true); query.AddColumn("Pat", 50, FieldValueType.String, font); query.AddColumn("LName", 100, FieldValueType.String, font); query.AddColumn("FName", 100, FieldValueType.String, font); query.AddColumn("DateEntry", 90, FieldValueType.Date, font); query.AddColumn("PayDate", 90, FieldValueType.Date, font); query.AddColumn("PayNote", 210, FieldValueType.String, font); query.AddColumn("PayAmt", 70, FieldValueType.Number, font); query.GetColumnHeader("PayAmt").ContentAlignment = ContentAlignment.MiddleRight; query.GetColumnDetail("PayAmt").ContentAlignment = ContentAlignment.MiddleRight; Cursor = Cursors.Default; if (!report.SubmitQueries(true)) { return; } // display report FormReportComplex FormR = new FormReportComplex(report); //FormR.MyReport=report; FormR.ShowDialog(); }