Viewing 1 post (of 1 total)
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.
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.
Please click your button and run PSRemoteSupport.
