Hello Daniel! I wonder if you can help me out with this. I have tried all I can but no luck.
And this is what I pasted in the designer:
<?xml version="1.0" encoding="UTF-8"?>what exact problem are you currently facing? @alagoa
I want to be able to print out labels but cant get it to work. It will be nice to get a step by step advice on how to do it. Thanks
Can you share your SQL Query via pastebin.com?
Thanks. Here is the SQL query https://pastebin.com/UV7tk5rJ
https://pastebin.com/CG30Uqm5 is the content of the xml file i tried opening in xreports designer that failed
Can you start by fixing your sql query? Ensure that you can run it directly in MySQL without any errors.
Ok. Thanks
Can’t get theSQL query below to work on MYSQL console. I am probably missing something as I don’t have a clue. I was hoping to get a query to paste and get it to work. I got this example from openmrs wiki https://wiki.openmrs.org/display/docs/How+to+create+a+Patient+Clinical+Summary+using+Reporting+Module Thanks
SELECT given_name, family_name, birthdate, gender,
( SELECT identifier FROM patient_identifier WHERE patient_identifier.patient_id = :person AND identifier_type=1 AND voided=0) as identifier1,
( SELECT identifier FROM patient_identifier WHERE patient_identifier.patient_id = :person AND identifier_type=2 AND voided=0) as identifier2,
( SELECT identifier FROM patient_identifier WHERE patient_identifier.patient_id = :person AND identifier_type=3 AND voided=0) as identifier3
FROM person, person_name
WHERE person.person_id = :person AND person_name.person_id = :person AND person.voided=0 AND person_name.voided=0 ORDER BY person_name.person_name_id DESC LIMIT 1;
Does it work if you replace every instance of :person with the actual value?
It is no longer throwing errors on mysql with below: SELECT given_name, family_name, birthdate, gender, (SELECT identifier FROM patient_identifier WHERE patient_identifier.patient_id = given_name AND identifier_type=1 AND voided=0) as identifier1, (SELECT identifier FROM patient_identifier WHERE patient_identifier.patient_id = family_name AND identifier_type=2 AND voided=0) as identifier2, (SELECT identifier FROM patient_identifier WHERE patient_identifier.patient_id = gender AND identifier_type=3 AND voided=0) as identifier3 FROM person, person_name WHERE person.person_id = given_name AND person_name.person_id = family_name AND person.voided=0 AND person_name.voided=0 ORDER BY person_name.person_name_id DESC LIMIT 1
All I need on the label is given name, family name, birthdate and gender.
However, still having errors
What errors?
What do I put in the designer? Is there a manual on the how to use the designer?Thanks
Are you looking for this? https://wiki.openmrs.org/display/docs/XReports+Module+Report+Designer
I did. But still can’t see how to.
How to do what?
