Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #31127
    roelofwielinga
    Participant

    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

    #32512
    Support
    Keymaster

    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!

    #32513
    roelofwielinga
    Participant

    That works like a charm!

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.