Viewing 1 post (of 1 total)
  • Author
    Posts
  • #31143
    clinicoffice_user
    Participant

      How can I create a working Layout report for Clinical notes? The problem is not the lay-out as well as the source.
      I now have the following SQL created:
      SQL Source

      select sess.id, sess.notes4,

      (patientper.firstname||' ' || (case when (patientper.middlename is not null and patientper.middlename <> '')
      then cast(patientper.middlename || ' ' as varchar(100)) else cast('' as varchar(100)) end)||patientper.lastname) as naam, patientper.lastname, patientper.address1,
      patientper.postcode, patientper.towncity,
      patientper.dob, cast(patientper.dob as DATE) as geboorte,

      patientper.code as patientcode

      from per as patientper
      left join sess on (patientper.id=sess.per_id)

      SQL Source 2
      Empty

      SQL options

      Favourites=
      frmEditorPatient=id|patientper_id
      frmEditorCas=id|cas_id
      frmEditorSess=id|id

      When I am in the Report designer I get result, but when I am in Clinical notes and select one session I don’t get a result for this report.
      So I want to use this new Layout Report (via the button Print) in Clinical Notes and create a report which prints all that is in the field sess.notes4.
      Please advise.

    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.