Report query can not show all query

[andysusanto]

hai,

i am using ireport 3.1.1.  i found that report query can not hold long query because in report query there is not scrollbar

 

you can use my query to see in your development :

 

SELECT A.LOCKERTRANS_ID,A.LOCKERTRANS_FACILITY,A.LOCKERTRANS_TAXFASILITASSPA,A.LOCKERTRANS_JENISPAYMENT,A.LOCKERTRANS_ROOMPRICE,
A.LOCKERTRANS_ROOMDISC,A.LOCKERTRANS_TYPE,A.LOCKERTRANS_NO,A.LOCKERTRANS_PAYMENT,
A.LOCKERTRANS_PAYMENTINADVANCE,A.LOCKERTRANS_SERVICECHARGE,
A.LOCKERTRANS_INFO,DATE_FORMAT(A.LOCKERTRANS_DATEOUT,'%d-%m-%Y')as LOCKERTRANS_DATEOUT,
A.LOCKERTRANS_TIMEOUT,DATE_FORMAT(A.LOCKERTRANS_ROOMDATEIN,'%d-%m-%Y') LOCKERTRANS_ROOMDATEIN,
DATE_FORMAT(A.LOCKERTRANS_ROOMDATEOUT,'%d-%m-%Y') LOCKERTRANS_ROOMDATEOUT,
A.LOCKERTRANS_ROOMTIMEIN,A.LOCKERTRANS_ROOMTIMEOUT,A.LOCKERTRANS_ROOMTAX,A.LOCKERTRANS_NDAYS,
A.LOCKERTRANS_HOTEL_STATUS,B.LOCKER_NO,
C.ROOM_NO,C.ROOM_NAME,
D.USER_NAME,E.MEMBER_NO,DATE_FORMAT(E.MEMBER_EXPIRE_TO,'%d-%m-%Y') MEMBER_EXPIRE_TO,
SUM(F.DEPOSIT_VALUE) DEPOSIT
FROM LOCKERTRANS A
LEFT OUTER JOIN LOCKER B ON B.LOCKER_ID = A.LOCKERTRANS_LOCKERID
LEFT OUTER JOIN ROOM C ON C.ROOM_ID = A.LOCKERTRANS_ROOMID
INNER JOIN USER D ON D.USER_ID = A.LOCKERTRANS_CASHIERID
LEFT OUTER JOIN MEMBER E ON E.MEMBER_ID = A.LOCKERTRANS_MEMBERID
LEFT OUTER JOIN DEPOSIT F ON F.DEPOSIT_LOCKERTRANSID = A.LOCKERTRANS_ID
WHERE LOCKERTRANS_ID = $P!{LOCKERTRANS_ID}
GROUP BY A.LOCKERTRANS_ID,A.LOCKERTRANS_FACILITY,A.LOCKERTRANS_TAXFASILITASSPA,A.LOCKERTRANS_JENISPAYMENT,A.LOCKERTRANS_ROOMPRICE,
A.LOCKERTRANS_ROOMDISC,A.LOCKERTRANS_TYPE,A.LOCKERTRANS_NO,A.LOCKERTRANS_PAYMENT,
A.LOCKERTRANS_PAYMENTINADVANCE,A.LOCKERTRANS_SERVICECHARGE,
A.LOCKERTRANS_INFO,LOCKERTRANS_DATEOUT,
A.LOCKERTRANS_TIMEOUT,LOCKERTRANS_ROOMDATEIN,
LOCKERTRANS_ROOMDATEOUT,
A.LOCKERTRANS_ROOMTIMEIN,A.LOCKERTRANS_ROOMTIMEOUT,A.LOCKERTRANS_ROOMTAX,A.LOCKERTRANS_NDAYS,
A.LOCKERTRANS_HOTEL_STATUS,B.LOCKER_NO,
C.ROOM_NO,C.ROOM_NAME,
D.USER_NAME,E.MEMBER_NO,MEMBER_EXPIRE_TO
ORDER BY A.LOCKERTRANS_ID

Regards,

Andy Susanto

[asmrussel]

All your query is shown in my iReport

My version is 3.0.0

[andysusanto]

hai,

 

yes try to use ireport 3.1.1, only this version you can not all query  :)

 

Regards,

 

Andy Susanto

[mdahlman]

Wow, that's a nasty bug! Have you entered it in the tracker yet? Please enter it so that we are certain to fix it.

 

It's slightly less of a problem than it could be... since it correctly keeps your full query. You just can't see it visually. In fact you can even see it visually if you need to. Click the report to make it active. Then in the Report Properties pane there is a field for "Query Text". Click the "..." button there and you can see your full query. Granted, you see it in a non-formatted, non-colorcoded, not-testable, non-wordwrapping painful little text editor. But you can see it. ;-)

 

Regards,
Matt
Jaspersoft

[andysusanto]

hai,

today i just posted into Tracker with Category General

 

 

Regrads,

 

Andy Susanto