[Create a group band with ireport 3.7.1]

i found it. thanks

[Create a group band with ireport 3.7.1]

hai,

 

how can i create a group band with ireport 3.71 ?

 

Regards,

 

Andy Susanto

[CPU Usage 100%]

my application CPU usage 100%, every time a lot of use, how can I know the problem exists.

Tomcat and MySQL database applications in one box, and the computer uses 2 GB of memory. Use of 512 and Xms and Xmx 256M PermSize

only ten computer that connected to my application


I use:
JasperReport 3.7.1

tomcat 5.x

mysql 5.1

how can I find the bottleneck?

regards,

Andy Susanto

Post Edited by andysusanto at 07/14/2010 16:40

[Problem with subreport data source?]

hai,

 

i got this error too, when using a subreport. but this error i got after i upgrade to jasperreports-3.5.2

 

 

Regards,

 

Andy Susanto

[Create a report with CustomDatasource]

hai,

 

i solved my problem, and i can print my own report

 

 

Thanks,

 

Andy Susanto

[Create a report with CustomDatasource]

hai,

i would like to create a report with custom datasource. but i got a problem while compile my report.

I need enligment to solved my problem

TIA,

Andy Susanto

[Error writing to OutputStream writer]

Hai,

why this error raise ? and can i minimized this error ?

net.sf.jasperreports.engine.JRException: Error writing to OutputStream writer : Bill_Trans
    at net.sf.jasperreports.engine.export.JRHtmlExporter.exportReport(JRHtmlExporter.java:416)
    at mainapp.locker.transaksi.print.PrintOut.InputField(PrintOut.java:178)
    at mainapp.locker.transaksi.print.PrintOut.handleRequest(PrintOut.java:240)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:595)
Caused by: ClientAbortException:  java.net.SocketException: Connection reset by peer: socket write error
    at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:358)
    at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:434)
    at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:309)
    at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:288)
    at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:98)
    at sun.nio.cs.StreamEncoder$CharsetSE.implFlush(StreamEncoder.java:410)
    at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:152)
    at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:213)
    at net.sf.jasperreports.engine.export.JRHtmlExporter.exportReportToWriter(JRHtmlExporter.java:718)
    at net.sf.jasperreports.engine.export.JRHtmlExporter.exportReport(JRHtmlExporter.java:412)
    ... 21 more
Caused by: java.net.SocketException: Connection reset by peer: socket write error
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
    at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:737)
    at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:434)
    at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:349)
    at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:761)
    at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:126)
    at org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:570)
    at org.apache.coyote.Response.doWrite(Response.java:560)
    at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:353)
    ... 30 more

[how to minimize Error loading object from]

hai,

my aplication work properly. but today i got an error  like this one, how can i minimize this error and why this error raise

 

error message :

net.sf.jasperreports.engine.JRException: Error loading object from file : C:Program FilesApache Software FoundationTomcat 5.5webappshotelreportsBill_Bar.jasper
    at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:96)
    at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:68)
    at mainapp.transaksi.bar.transaksi.report.Bar_Order_Print.InputField(Bar_Order_Print.java:74)
    at mainapp.transaksi.bar.transaksi.report.Bar_Order_Print.handleRequest(Bar_Order_Print.java:153)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
Caused by: java.io.EOFException
    at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2228)
    at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2694)
    at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:761)
    at java.io.ObjectInputStream.<init>(ObjectInputStream.java:277)
    at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:91)
    ... 24 more

[Report query can not show all query]

hai,

today i just posted into Tracker with Category General

 

 

Regrads,

 

Andy Susanto

[How to upload customizer class to ireport?]

what version of ireport that your used ?,

you just copy your classes itu "WEB-INFclasses".  After that just put your package classes into Chart Properties

 

 

Regards,

 

Andy Susanto

[Report query can not show all query]

hai,

 

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

 

Regards,

 

Andy Susanto

[Report query can not show all query]

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

[printing jasper on the web]

hai,

 

 

i have a problem sometime print dialog from a web take several minute to display.

 

btw i am use javascript command like window.print()

is there any solution or an ide to solve that problem?

 

 

TIA,

 

andy susanto

[nodata Band]

hai kchaudhry,

 

your tips i already use. but i just want to know how to use nodata band.

 

nodata band to use automatic show the object that inside that band, i am right ?

 

 

Regards,

[nodata Band]

hai,

 

i try your suggestion to change it into All sections, no detail option but still it does not working at all

 

 

any ide ?

 

 

TIA,

[nodata Band]

hai,

 

i try your suggestion to change it into All sections, no detail option but still it does not working at all

 

 

any ide ?

 

 

TIA,

[nodata Band]

hai,

 

i would like to try a nodata band.

report properties -> more -> when no data i select no data section

 

 

but when i run the report my static text does not visible.

 

how to use that band ?

 

 

TIA,

[iReport doesn't work on my computer]

hai Jason,

 

 

can you post your information about your OS?

 

like what kind window that you use?, what version java ?

 

 

Regards,

[Unable to export jasper report in excel format]

StringBuffer sbFile = new StringBuffer("C:").append(File.separator).append(jenisLaporan).append(".xls");

JExcelApiExporter exporterAPIXLS = new JExcelApiExporter();

exporterAPIXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint);

exporterAPIXLS.setParameter(JExcelApiExporterParameter.OUTPUT_FILE_NAME, sbFile.toString());

exporterAPIXLS.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

exporterAPIXLS.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);

exporterAPIXLS.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

exporterAPIXLS.exportReport();

 

you can use my code to compile xls

 

Regards,

[parameter query]

hai,

 

yes you can do it just make sure the you already define the name of paremeter that you want.

 

if you want to check your parameter click View menu than

 

see the Parameter

 

 

Regards,

[Passing parameter from master report]

hai,

 

select properties of subreport then click subreport(other) put your parameter of subreport on the left side, the right side is master parameter

 

Regards,

[Change Date format like dd-MM-YYYY]

hai,

 

if you use field object, just click on tab "Text Field", click on button "Create" beside combobox pattern,

 

just pick want date format after that just edit the value of combobox like this "dd-MM-yyyy"

 

or type the dateformat you like.

[how to create a gantt chart]

hai,

 

can i create a gantt chart from ireport ?, if i look a jfreechart that lib can build a gantt chart.

 

But i cannot find how to create that gantt chart in ireport

 

 

need enlightment

[Subreport Not Appearing Version 0.5.0]

hai,

 

 

try your report seperate to see your report work correctly. between your masterreport and subreport

 

after that in subreport component on masterreport click tab subreport pick "use connection expression"

 

and tab subreport(other) put your subreport file (fullpath example c:developmentreportmysubreport.jrxml)

 

 

i hope this will help you

 

 

regrads,

[automatically report refresh]

hai,

 

you can combine with a javascript to refresh the report