private void CreateGrouped()
{
ReportComplex report = new ReportComplex(true, false);
DataTable table = RpProcSheet.GetGroupedTable(date1.SelectionStart, date2.SelectionStart, _listProvNums, _listClinicNums, textCode.Text, checkAllProv.Checked);
string subtitleProvs = ConstructProviderSubtitle();
string subtitleClinics = ConstructClinicSubtitle();
Font font = new Font("Tahoma", 9);
Font fontBold = new Font("Tahoma", 9, FontStyle.Bold);
Font fontTitle = new Font("Tahoma", 17, FontStyle.Bold);
Font fontSubTitle = new Font("Tahoma", 10, FontStyle.Bold);
report.ReportName = Lan.g(this, "Procedures By Procedure Code");
report.AddTitle("Title", Lan.g(this, "Procedures By Procedure Code"), fontTitle);
report.AddSubTitle("Practice Title", PrefC.GetString(PrefName.PracticeTitle), fontSubTitle);
report.AddSubTitle("Dates of Report", date1.SelectionStart.ToString("d") + " - " + date2.SelectionStart.ToString("d"), fontSubTitle);
report.AddSubTitle("Providers", subtitleProvs, fontSubTitle);
if (PrefC.HasClinicsEnabled)
{
report.AddSubTitle("Clinics", subtitleClinics, fontSubTitle);
}
QueryObject query = report.AddQuery(table, Lan.g(this, "Date") + ": " + DateTimeOD.Today.ToString("d"));
query.AddColumn(Lan.g(this, "Category"), 150, FieldValueType.String, font);
query.AddColumn(Lan.g(this, "Code"), 130, FieldValueType.String, font);
query.AddColumn(Lan.g(this, "Description"), 140, FieldValueType.String, font);
query.AddColumn(Lan.g(this, "Quantity"), 60, FieldValueType.Integer, font);
query.GetColumnDetail(Lan.g(this, "Quantity")).ContentAlignment = ContentAlignment.MiddleRight;
query.AddColumn(Lan.g(this, "Average Fee"), 110, FieldValueType.String, font);
query.GetColumnDetail(Lan.g(this, "Average Fee")).ContentAlignment = ContentAlignment.MiddleRight;
query.AddColumn(Lan.g(this, "Total Fees"), 110, FieldValueType.Number, font);
report.AddPageNum(font);
if (!report.SubmitQueries())
{
return;
}
FormReportComplex FormR = new FormReportComplex(report);
FormR.ShowDialog();
DialogResult = DialogResult.OK;
}
private void CreateIndividual()
{
ReportComplex report = new ReportComplex(true, false);
bool isAnyClinicMedical = false; //Used to determine whether or not to display 'Tooth' column
if (AnyClinicSelectedIsMedical())
{
isAnyClinicMedical = true;
}
DataTable table = new DataTable();
try {
table = RpProcSheet.GetIndividualTable(date1.SelectionStart, date2.SelectionStart, _listProvNums, _listClinicNums, textCode.Text,
isAnyClinicMedical, checkAllProv.Checked, PrefC.HasClinicsEnabled);
}
catch (Exception ex) {
report.CloseProgressBar();
string text = Lan.g(this, "Error getting report data:") + " " + ex.Message + "\r\n\r\n" + ex.StackTrace;
MsgBoxCopyPaste msgBox = new MsgBoxCopyPaste(text);
msgBox.ShowDialog();
return;
}
if (table.Columns.Contains("ToothNum"))
{
foreach (DataRow row in table.Rows)
{
row["ToothNum"] = Tooth.GetToothLabel(row["ToothNum"].ToString());
}
}
string subtitleProvs = ConstructProviderSubtitle();
string subtitleClinics = ConstructClinicSubtitle();
Font font = new Font("Tahoma", 9);
Font fontBold = new Font("Tahoma", 9, FontStyle.Bold);
Font fontTitle = new Font("Tahoma", 17, FontStyle.Bold);
Font fontSubTitle = new Font("Tahoma", 10, FontStyle.Bold);
report.ReportName = Lan.g(this, "Daily Procedures");
report.AddTitle("Title", Lan.g(this, "Daily Procedures"), fontTitle);
report.AddSubTitle("Practice Title", PrefC.GetString(PrefName.PracticeTitle), fontSubTitle);
report.AddSubTitle("Dates of Report", date1.SelectionStart.ToString("d") + " - " + date2.SelectionStart.ToString("d"), fontSubTitle);
report.AddSubTitle("Providers", subtitleProvs, fontSubTitle);
if (PrefC.HasClinicsEnabled)
{
report.AddSubTitle("Clinics", subtitleClinics, fontSubTitle);
}
QueryObject query = report.AddQuery(table, Lan.g(this, "Date") + ": " + DateTimeOD.Today.ToString("d"));
query.AddColumn(Lan.g(this, "Date"), 90, FieldValueType.Date, font);
query.GetColumnDetail(Lan.g(this, "Date")).StringFormat = "d";
query.AddColumn(Lan.g(this, "Patient Name"), 150, FieldValueType.String, font);
if (isAnyClinicMedical)
{
query.AddColumn(Lan.g(this, "Code"), 140, FieldValueType.String, font);
}
else
{
query.AddColumn(Lan.g(this, "Code"), 70, FieldValueType.String, font);
query.AddColumn("Tooth", 40, FieldValueType.String, font);
}
query.AddColumn(Lan.g(this, "Description"), 140, FieldValueType.String, font);
query.AddColumn(Lan.g(this, "Provider"), 80, FieldValueType.String, font);
if (PrefC.HasClinicsEnabled)
{
query.AddColumn(Lan.g(this, "Clinic"), 100, FieldValueType.String, font);
}
query.AddColumn(Lan.g(this, "Fee"), 80, FieldValueType.Number, font);
report.AddPageNum(font);
if (!report.SubmitQueries())
{
return;
}
FormReportComplex FormR = new FormReportComplex(report);
FormR.ShowDialog();
DialogResult = DialogResult.OK;
}