Dear Everyone,
How to add patient.ChartNumber column to "Daily Payments Report" sheet?
I can add a patient.ChartNumber to SQL query, and a column to FormRpWriteOffSheet.cs using SetColumn but I don't know how to add the column to Daily Payments Report sheet.
I tried to edit PaymentRDL.txt file but I got following errors:
System.NullReferenceException: Object reference not set to an instance of an object.
at OpenDental.FormRpPaySheet.butOK_Click(Object sender, EventArgs e) in e:\work\OpenDental_12_4\OpenDental\Forms Reports\FormRpPaySheet.cs:line 537
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at OpenDental.UI.Button.OnClick(EventArgs ea) in e:\work\OpenDental_12_4\OpenDental\UI\Button.cs:line 153
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Thanks in advance,
Dennis
How to add patient.ChartNumber to Daily Payments Report
Re: How to add patient.ChartNumber to Daily Payments Report
If you are willing to update to our beta version of 15.1 when it is released then this will be much easier to implement.
In 15.1, in FormRpPaySheet in the butOK_Click method, after this line
add
Do that for both queryIns and queryPat.
Next, add this line:
After both instances of this line:
In 15.1, in FormRpPaySheet in the butOK_Click method, after this line
Code: Select all
+DbHelper.Concat("patient.LName","', '","patient.FName","' '","patient.MiddleI")+@") lfname,
Code: Select all
patient.ChartNumber,
Next, add this line:
Code: Select all
query.AddColumn("Chart Number",80,FieldValueType.String,font);//(The 80 may need to change to some other value based on the column width
After both instances of this line:
Code: Select all
query.AddColumn("Patient Name",150,FieldValueType.String,font);
Re: How to add patient.ChartNumber to Daily Payments Report
Hi Allen,
Thanks for the information. I don't have plan to use the beta version yet. I'm using 12.4.
Is there any way to add the patient.ChartNumber column from version 12.4?
Regards,
Dennis
Thanks for the information. I don't have plan to use the beta version yet. I'm using 12.4.
Is there any way to add the patient.ChartNumber column from version 12.4?
Regards,
Dennis
Re: How to add patient.ChartNumber to Daily Payments Report
I am sure there is a way to add in those columns, but I am not familiar enough with the old framework used to generate that report to give you any helpful hints.
https://technet.microsoft.com/en-us/lib ... .105).aspx This link may be helpful with figuring out the RDL syntax used to generate this report.
Overall, adding this column to this report could be very difficult or very easy, but I am sure that it will require a very strong understanding of the RDL Report Framework if you want to accomplish it.
Good luck.
https://technet.microsoft.com/en-us/lib ... .105).aspx This link may be helpful with figuring out the RDL syntax used to generate this report.
Overall, adding this column to this report could be very difficult or very easy, but I am sure that it will require a very strong understanding of the RDL Report Framework if you want to accomplish it.
Good luck.