Failed to print the multi-row dataset in XReports

hpardess · April 11, 2017, 7:12am

I have recorded more than one vital encounter in a visit. I want to print all the vitals encoutner in a tabluar format in a report. Therefore, I created an SQL Data Set which returns more than one row. Then i have set it as source for XReport but i get an error says “Subquery returns more than 1 row”

java.sql.SQLException: Subquery returns more than 1 row
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
    ...

dkayiwa · April 11, 2017, 7:28am

The problem is with your sql query. Your subquery which is used in a place that expects one row ended up returning more than one. Here is an example: “select * from patient where patient_id = (select subquery that should not return more than one)”

hpardess · April 11, 2017, 8:59am

Thanks, It was my query problem and I fixed it.

When i run the query from SQL Dataset Definition, it returns two rows. but when i run the XReport, it shows only one row.

dkayiwa · April 11, 2017, 9:58am

Can you reproduce it at modules-refapp.openmrs.org

hpardess · April 11, 2017, 10:30am

I can not login to modules-refapp.openmrs.org with following username & password, Username: Admin Password: Admin123

hpardess · April 19, 2017, 4:37pm

how to wrap the text in XReports. I have a value in XReports which is very long but how can I auto wrap when it is longer than page boundaries?

dkayiwa · April 21, 2017, 2:00pm

Can i look at a screenshot of the word that wraps?

hpardess · April 21, 2017, 5:39pm

I tested again and I observed that if we have a sentence then it wraps properly like this,

but if i have a single long word then it can not wrap the word if it goes beyond the border like this

hpardess · April 21, 2017, 5:53pm

Here is the result of my sql dataset is two records (more than one)

and in XReport I see only one record

same filter and conditions are applied to both reports.

dkayiwa · April 22, 2017, 8:42pm

Can you reproduce these here http://modules-refapp.openmrs.org/ such that i see them live in action?

hpardess · April 23, 2017, 5:16am

https://modules-refapp.openmrs.org/openmrs/xreports/reportParameter.page?reportId=1

dkayiwa · April 24, 2017, 4:39pm

@hpardess i just tried that link but it gives the default html preview of the reporting module.

hpardess · April 26, 2017, 9:37pm

In XReports v9, the default was Web preview but in XReports v10 it is changed . instead it is printed in html preview which is part of legacy UI.

Is the multiple rows printing fixed for Web preview/pdf?

dkayiwa · April 26, 2017, 9:49pm

You need to add the different renderers if you want to see them listed.

hpardess · April 27, 2017, 12:12am

I want to display the multi row data in report templates that I shared with you in my previous posts.

dkayiwa · April 27, 2017, 6:28am

OK. Set it up at modules-refapp.openmrs.org and i will show you how to.

hpardess · April 27, 2017, 10:32am

I can not design the report on server. I get following error,

dkayiwa · April 27, 2017, 8:56pm

@hpardess that was a bug in the legacyui module which i have fixed with https://issues.openmrs.org/browse/LUI-124 Can you try again?

hpardess · May 7, 2017, 9:34pm

following issue is not yet fixed. Therefore, I can not set the how the report should be rendered because by default the report is rendered in legacy UI.

dkayiwa · May 7, 2017, 10:25pm

Did you set any renderers? In particular the XReports (PDF) renderer?