Open Dental Forum

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

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:

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

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.