Viewing 3 posts - 1 through 3 (of 3 total)
Viewing 3 posts - 1 through 3 (of 3 total)
- You must be logged in to reply to this topic.
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
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!
That works like a charm!