How to add patient’s DOB to the Invoice template?

[roelofwielinga]

I’ d like to create a database field in my template for the bill. This field needs to show the patient dob. I created an empty field and when i look between the optional fields to choose from, it seems like there is no field with patient.dob.
can you help me with this?
Thanks,
Roelof Wielinga

[Support]

Thanks for your post. Please follow these steps :-

[1] Click Reports & Templates, locate the “Invoice” report, right click on it and click EDIT SOURCE.

[2] Click the SQL Source tab at the top and then locate the following lines in the source :-

inv.patient_per_id as patient_per_id, @NAME:patientper as _patientname,

patientper.code as patientcode,

You need to change these lines by adding an extra field as follows :-

inv.patient_per_id as patient_per_id, @NAME:patientper as _patientname,

patientper.code as patientcode, patientper.dob as patientdob,

Now click OK to save the updated source code. This makes the patient’s DOB field available to the report.

[3] Locate the “Invoice” report again, right click on it and this time click DESIGN REPORT. You can now add a new label to the report and link it to the “patientdob” field which is now available.

Hope this helps!

[roelofwielinga]

That works like a charm!

[Author]

Posts