How to add patient.ChartNumber to Daily Payments Report

This forum is for programmers who have questions about the source code.
Post Reply
dieutan
Posts: 10
Joined: Mon May 12, 2014 8:12 pm

How to add patient.ChartNumber to Daily Payments Report

Post by dieutan » Wed Jan 21, 2015 11:31 am

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

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: How to add patient.ChartNumber to Daily Payments Report

Post by allends » Wed Jan 21, 2015 12:20 pm

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

Code: Select all

+DbHelper.Concat("patient.LName","', '","patient.FName","' '","patient.MiddleI")+@") lfname,
add

Code: Select all

patient.ChartNumber,
Do that for both queryIns and queryPat.

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);
Allen
Open Dental Software
http://www.opendental.com

dieutan
Posts: 10
Joined: Mon May 12, 2014 8:12 pm

Re: How to add patient.ChartNumber to Daily Payments Report

Post by dieutan » Fri Jan 23, 2015 4:20 pm

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

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: How to add patient.ChartNumber to Daily Payments Report

Post by allends » Fri Jan 23, 2015 5:05 pm

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.
Allen
Open Dental Software
http://www.opendental.com

Post Reply