2006 IR Open Discussion

By: Raj - rajs1 Last page of 1st subreport PAGE_NUMBER=null 2003-03-20 04:21 My master report includes two sub report. The master report has page numbering defined in the Page Footer. I noticed that the last page of the first sub report always shows Page null of 8 (where 8 = total pages of the two combined reports). Is this a bug? or am I doing something wrong. All other pages have correct numbering. The page numbering XML in the master report is as follows: <pageFooter> <band height="20"> <!--- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Page Numbering~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --> <line> <reportElement x="0" y="0" width="515" height="0"/> <graphicElement stretchType="NoStretch"/> </line> <textField evaluationTime="Now"> <reportElement x="200" y="0" width="80" height="15"> </reportElement> <textElement textAlignment="Right"/> <textFieldExpression class="java.lang.String"> "Page " + String.valueOf($V{PAGE_NUMBER}) + " of " </textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="280" y="0" width="75" height="15"> </reportElement> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.String"> String.valueOf($V{PAGE_NUMBER}) </textFieldExpression> </textField> </band> </pageFooter> The master report has 2 sub reports defined as follows: <group name="firstsubrep" isStartNewPage="true"> <groupHeader> <band height="650"> <subreport isUsingCache="true"> <reportElement x="0" y="0" width="520" height="80" positionType="Float" isRemoveLineWhenBlank="true"> <printWhenExpression>new Boolean($P{FirstSubReportDataSource} != null)</printWhenExpression> </reportElement> <dataSourceExpression> $P{BookReportDataSource} </dataSourceExpression> <subreportExpression class="dori.jasper.engine.JasperReport"> $P{FirstSubReport} </subreportExpression> </subreport> </band> </groupHeader> <groupFooter> <band height="0"/> </groupFooter> </group> <group name="image" isStartNewPage="true"> <groupHeader> <band height="650"> <subreport isUsingCache="true"> <reportElement x="0" y="100" width="520" height="550" positionType="Float" isRemoveLineWhenBlank="true"> <printWhenExpression>new Boolean($P{SecondReportDataSource} != null)</printWhenExpression> </reportElement> <dataSourceExpression> $P{ImageReportDataSource} </dataSourceExpression> <subreportExpression class="dori.jasper.engine.JasperReport"> $P{SecondSubReport} </subreportExpression> </subreport> </band> </groupHeader> <groupFooter> <band height="0"/> </groupFooter> </group>

By: ryanwu - ryanwu export my created character to PDF ? 2003-03-17 22:53 I create a character (encoding is unicode) by true type maker progrom in windows 2000 then .. How can I show the charater by JasperReport throungh iReprot to export PDF?? By: Giulio Toffoli - gt78 RE: export my created character to PDF ? 2003-03-18 01:33 If your font is already installed, select "External TTF Font" as PDF Font name, and then you should see your font in the combo box labeled TrueType font. I hope this helps you Giulio By: ryanwu - ryanwu RE: export my created character to PDF ? 2003-03-18 10:32 How can I choice Pdf encoding in iReport? By: Giulio Toffoli - gt78 RE: export my created character to PDF ? 2003-03-18 13:38 You can specify the pdf encoding field by field in the element properties form. Giulio

By: Victor LAI - vcmlai How to export into HTML outputstream / byte[] 2003-03-18 09:33 Hi , I would like to export the JasperReport into HTML format and send back to browser directly, rather than export into the file. How ? Please help. By: Victor LAI - vcmlai RE: How to export into HTML outputstream / byte[] 2003-03-18 09:52 I just solve the problem using "JRHtmlExporter". Thanks

By: Rick Fusaro - rfusaro Lose line of text on overflow to next page 2003-02-07 11:45 I'm using version 0.4.4 of jasperreports. I am trying to create a letter that may or may not go to a second page depending on how much text is included. It works using the view and print functions but loses a line of text when I create a pdf. I've tried adjusting the size of summary band and no matter what height I give it a line is lost when it overflows to second page. I'm using isStretchWithOverflow="true" on the texField and positionType="Float" on the reportElement tags. I am using subreports for my header and footer. I have the body of the letter in the summary section. Does anyone have an idea on how I can get all the text to overflow to the second page? Thanks Rick By: Chuck Deal - cdeal RE: Lose line of text on overflow to next page 2003-02-10 08:43 I had this problem while using iText-0.92.jar. Switch to iText0.96.jar and see if that fixes the problem. By: Chuck Deal - cdeal RE: Lose line of text on overflow to next page 2003-02-10 13:48 Maybe there is a problem with the filling process for long text fields? How many lines can you successfully get to display? Are all of your margins set correctly? Does this text have newlines in it? If so, is the number of lines missing proportional to the number of newlines? I ask this last question because this was the specific problem that was fixed by changing to itext-0.96 (for me). I'm just tossing things out there, I'm hoping Teodor will have some ideas for you. By: Chuck Deal - cdeal RE: Lose line of text on overflow to next page 2003-02-10 13:51 Maybe there is a problem with the filling process for long text fields? How many lines can you successfully get to display? Are all of your margins set correctly? Does this text have newlines in it? If so, is the number of lines missing proportional to the number of newlines? I ask this last question because this was the specific problem that was fixed by changing to itext-0.96 (for me). I'm just tossing things out there, I'm hoping Teodor will have some ideas for you. By: Rick Fusaro - rfusaro RE: Lose line of text on overflow to next page 2003-02-10 13:31 Thanks Charles for your suggestion. I just tried using iText-0.96.jar by switching to version 0.4.5 of jasperreports, which included iText-0.96 and the problem is still happening. Any other ideas or suggestions? Thanks again Rick By: Teodor Danciu - teodord RE: Lose line of text on overflow to next page 2003-02-10 23:35 Hi, Can I see the XML file that poses the problem? You can modify the text file expression to include the long text sequence, so that I can run the report without a data source. teodord@hotmail.com Thank you, Teodor By: William Wong - takara5 RE: Lose line of text on overflow to next page 2003-03-17 12:21 I am having a similar problem, except I lose a line of text not only when converting to a pdf (I'm using Itext-0.96), but also when viewing and printing the JR document. My document stretches a variable (instructions) over 6 pages. First page renders fine, second page renders fine, but after that the following pages all lose one line at the top of the page that should be there. Here's a truncated sample of my code... <jasperReport name="WorkorderReport" pageWidth="595" pageHeight="790" columnWidth="540" columnSpacing="15" leftMargin="20" rightMargin="20" topMargin="10" bottomMargin="10"> <field name="WO_instructions" class="java.lang.String"> </field> <detail> <band height="770"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" x="0" y="0" width="555" height="770"/> <textFieldExpression class="java.lang.String"><![CDATA[$F{WO_instructions}]]></textFieldExpression> </textField> </band> </detail> </jasperReport> Can anyone please help? Thanks in advance! By: Teodor Danciu - teodord RE: Lose line of text on overflow to next page 2003-03-17 13:40 Hi, If you are using 0.4.5, could you please comment the line 441 in the JRFillTextElement class? Something like this: ... strpos += lastPosition; //if (lastPosition > 0) { ... I think this is the bug that I have spotted some weeks ago. If it is OK, the fix will come with the next version. Thank you, Teodor By: William Wong - takara5 RE: Lose line of text on overflow to next page 2003-03-18 07:48 Hi Teodor, Using 0.4.5, I commented out the IF STATEMENT, re-compiled and am happy to report, everything works perfectly now. May want to include this fix in the next version. Thanks so much! By: Teodor Danciu - teodord RE: Lose line of text on overflow to next page 2003-03-18 08:32 Hi, I'll do that. Thank you for testing. Teodor

By: Minimini - minimini Pdf have 0 page if 0 result return in query 2003-03-18 05:38 When I execute a query, if return zero result, the pdf file zero page and cannot be open with acrobat The query is: select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast($P{StartDate} as Date) and dt_date <= cast($P{StartDate} as Date) + cast('1 year' as Interval) order by dt_amount desc, dt_dn_id I am using tomcat under linux Pls tell me how to fix it By: Giulio Toffoli - gt78 RE: Pdf have 0 page if 0 result return in query 2003-03-18 07:42 Set the attribute whenNoDataType in report tag to a vlaue ather than "NoPages" (default) Giulio

By: Erich Kilmer - ekilmer Which visual JR development tool recommended? 2003-03-18 05:45 I have been doing report designs manually for a while now just to learn the tags and structures but now I want to try one of the visual JR tools to speed up the process. Which visual JR development tool does the group recommend and why? JasperEdit, the Eclipse tool, OpenReports or iReport? We are using IntelliJ so the Eclipse plugin is probably not for us. I have used the viewers that come with JR and they are useful but I would like a tool that is more drag and drop. Also which tool seems to be better supported with fix releases and docs? TIA

By: Minimini - minimini Error executing report query 2003-03-18 04:32 I am using postgresql 7.3.2 with jsp, these queries give me error select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast(<font color="#FF0000">'?'</font> as Date) and dt_date <= cast(<font color="#FF0000">'?'</font> as Date) + cast('1 year' as Interval) order by dt_amount desc, dt_dn_id select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast('?' as Date) and dt_date <= cast(? as Date) + cast('1 year' as Interval) order by dt_amount desc, dt_dn_id Can anyone pls tell me how to fix it? javax.servlet.ServletException: Error executing report query : [either one of the above sql] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:536) root cause javax.servlet.ServletException: Error executing report query : select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast('?' as Date) and dt_date <= cast('?' as Date) + cast('1 year' as Interval) order by dt_amount desc, dt_dn_id at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:533) at org.apache.jsp.pdf_jsp._jspService(pdf_jsp.java:91) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:536) By: Minimini - minimini RE: Error executing report query (omit above) 2003-03-18 04:35 I am using postgresql 7.3.2 with jsp, these queries give me error select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast('?' as Date) and dt_date <= cast('?' as Date) + cast('1 year' as Interval) order by dt_amount desc, dt_dn_id select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast(? as Date) and dt_date <= cast(? as Date) + cast('1 year' as Interval) order by dt_amount desc, dt_dn_id ? = $P{StartDate} which is a string Can anyone pls tell me how to fix it? javax.servlet.ServletException: Error executing report query : [either one of the above sql] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:536) root cause javax.servlet.ServletException: Error executing report query : select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast('?' as Date) and dt_date <= cast('?' as Date) + cast('1 year' as Interval) order by dt_amount desc, dt_dn_id at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:533) at org.apache.jsp.pdf_jsp._jspService(pdf_jsp.java:91) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:536) By: Minimini - minimini RE: Error executing report query 2003-03-18 04:46 Even this sql not work : select dn_id, dn_name, dn_phone, dn_fax, dn_addr1, dn_addr2, dn_addr3, dt_amount from donor, donation where dn_id = dt_dn_id and dt_date >= cast('2003-03-18' as date) and dt_date <= cast('2003-03-18' as date) + cast('1 year' as interval) order by dt_amount desc, dt_dn_id; By: Minimini - minimini RE: Error executing report query 2003-03-18 04:57 pls omit the second reply, no problem with that sql, but why the first 2 don't work By: Minimini - minimini RE: Error executing report query 2003-03-18 05:04 I delete the ' around ? and the qeury problem is solved

By: ryanwu - ryanwu How do I set the relative path to subreport 2003-03-17 22:44 how can I set the relative path to subreport in my main report by iReport.. ex: <subreportExpression class="java.lang.String"><![CDATA[ "Report2_1.jasper" ]]></subreportExpression> ?? like above setting doesn't work By: Giulio Toffoli - gt78 RE: How do I set the relative path to subreport 2003-03-18 01:31 open the subreport elemet properties and go to tab named subreport 2. Giulio

By: Mark Wu - wuhy I am a newbie to Jasper report 2003-03-16 21:12 Dear All: I am trying to find a reporting tool for my project. I think Jasper report is good, but I have the following concerns, can anyone help me to figure it out: 1. My project is kind of 3-tier structure, some data relationship is not build on DB level, it build on AP level, can Jasper report combine with my own business logical API to be the data source, instead of use direct DB connection. How can I do it? Any example exist? 2. Some reports need more complex expression. I already have some API to do this, can I call my own API from jasper XML configuration file. How can I do it? Any example exist? 3. Does there exist any report designer with Jasper report? 4. Does any one use the Jasper report on commercial project, would you please kindly share your experience. 5. How does the Jasper report compare to other reporting library, like JClass, Style Report or Jreport? I am not only a newbie to Jasper report, but also a newbie to 3-tier structure. Maybe some of my description are not so suitable. Please also correct me. Thanks, Best Regards, Mark By: Bernd Proissl - berndproissl RE: I am a newbie to Jasper report 2003-03-16 21:38 1. yes. search the examples for interface JRDataSource (or similar) 2. yes, maybe you need some wrapper class. there are examples, you can use Java expressions in the XML file 3. yes, search this forum 4. yes, works perfectly, Teodor is very helpful and you can fix specific problems on your own because you have the sources and the licensee to do so 5. a link to a comparison has been posted here some time ago By: Mark Wu - wuhy RE: I am a newbie to Jasper report 2003-03-17 19:24 Hi Bernd: Thanks, I got it. And I already review those material that you provide. it is really helpful. I think, I need to test those example by myself to know more. About the comparison, I already read them. It only compare about JFreeReport & JasperReport, Crystal Report. How about compare to Style Report & JReport, does there any articals mention about them? Thanks. Mark

By: steven buschman - sbusch1 xmlspy 2003-03-10 17:54 I apologize in advance for being an XML newbie. I have over 50 different reports to design and seem convinced JasperReports is the way to go (I made a big mistake and purchased Crystal Reports). However, designing these reports seems very time consuming. So it's worth it for me to buy the best XML editor available.I heard good things about xmlspy (about $400). Thanks. By: Teodor Danciu - teodord RE: xmlspy 2003-03-11 00:42 Hi, Maybe you should consider using a GUI tool for JasperReports. This way, you'll have little to do with manually editing XML content. You can choose one from here: http://sourceforge.net/forum/forum.php?forum_id=186065 I hope this helps. Teodor By: steven buschman - sbusch1 RE: xmlspy 2003-03-11 13:42 Hi, I've already played with JasperEdit and JasperDesign. At the risk of sounding critical, both appear to be works in progress, whereas (at the risk of sucking up) JasperReports is ready for prime time (I sell a medical product, so I need to be fairly conservative). For me, JasperReports primary appeal is not price (half lie - Crystal Reports isn't an option, because of per desk licensing fees), but because it's very powerful (hopefully, it's fast for a 50 page report). Strictly by chance, I've been using iText alone for about 10 months, not because of price (half lie again) and I feel that I couldn't have finished my application without it, open source or not So back to a GUI, it's worth it for me to have the best because time to market is a zillion times more important than price (I'm one of those rare birds who's willing to pay $$$ for open source, especially when it's used for a commerical purpose). So, if you honestly think these packages are better than xmlspy, then I'll take your word for it, but if you think otherwise, or you know of an alternative XML editor, I'd appreciate your suggestions. I'd like to add that the person doing the editing probably won't be a programmer, so ease of use is VERY important. Thanks. By: Edgar Dollin - edollin RE: xmlspy 2003-03-17 18:31 iReports is decent at layout. You still need an ant task to run the report to get the classpath and parameters correct. Edgar

By: Giulio Toffoli - gt78 iReport 0.0.9 released! 2003-03-17 14:06 Thanks for Dominique Gallot, a new release of iReport is now available. A lot of new and very cool features. - Added light gray border to ImageElement - Added light red border on band overflow - Set tab order on Properties Windows - Set tab order on Report properties Windows and on most windows - Will ask to save unsaved report --- Bug 645285 - Copy & Past works for all common fields ( transparency, ... ) --- Bug 682186 - Field description was not loaded ! -- Bug 675794 - Field parameter windows and parameter/field/variable window start in the center of the screen. - Support for multi selection properties editing... - Added ContextMenu in report form .. Send to Back, to Front , properties - the latest seleted tab in the properties element is now selected if possible. - Short cut to open a sub report -- Request ??? - Added support for cmd line arguments -f file can open several files now ! -h show this Support for the old cmd line arguments kept! - Added support for compatibility with jasper report version before 0.4.5, via compatibility form - Will use a CDATA in the XML file only when needed. - Properties file 'expressions.properties' Added. Entries in this file will be added in the expression editor ! http://ireport.sourceforge.net Giulio By: Jeff Campbell - jeffcampbell RE: iReport 0.0.9 released! 2003-03-17 14:37 When is this going to be able to work on other operating systems other than just Windows? By: Giulio Toffoli - gt78 RE: iReport 0.0.9 released! 2003-03-17 14:47 I'm working on, but the process of port is slow. The bottelneck is my few free time. The real author of all new features in the win32 version of iReport is Dominique, that without prejudgments is continuing to develop on the original version written in VisualJ++. I'll release some screenshotsof the pure java version soon to hold height the interest about this topic. Thanks for your question. Giulio

By: Giulio Toffoli - gt78 A tutorial about subreports using iReport 2003-03-17 14:09 Shailesh Kadam has written a good tutorial on howto use subreport with iReport. Take a look at http://ireport.sf.net/docs.html where the tutorial is available for download. Enjoy! Giulio

By: Minimini - minimini Bug in version 0.4.5? 2003-03-17 03:51 Hello teodord, I got the following exception under winxp when I execute: JasperRunManager.runReportToPdfFile(reportFile.getPath(), parameters, getConnection()); my db is ms access xp and driver is sun.jdbc.odbc.JdbcOdbcDriver Pls tell me how to fix it, thanks. ******************************************************** java.sql.SQLException: ResultSet is closed at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6502 ) at sun.jdbc.odbc.JdbcOdbcResultSet.getStatement(JdbcOdbcResultSet.java:4 231) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.jav a:217) at dori.jasper.engine.JasperRunManager.runReportToPdfFile(JasperRunManag er.java:105) at donortest.main(donortest.java:19) NESTED BY : java.sql.SQLException: ResultSet is closed at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6502 ) at sun.jdbc.odbc.JdbcOdbcResultSet.getStatement(JdbcOdbcResultSet.java:4 231) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.jav a:217) at dori.jasper.engine.JasperRunManager.runReportToPdfFile(JasperRunManag er.java:105) at donortest.main(donortest.java:19) NESTED BY : dori.jasper.engine.JRException: Error closing ResultSet or Statement for report data source : donorrank at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:390) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.jav a:217) at dori.jasper.engine.JasperRunManager.runReportToPdfFile(JasperRunManag er.java:105) at donortest.main(donortest.java:19) Caused by: java.sql.SQLException: ResultSet is closed at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6502 ) at sun.jdbc.odbc.JdbcOdbcResultSet.getStatement(JdbcOdbcResultSet.java:4 231) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381) ... 4 more By: Teodor Danciu - teodord RE: Bug in version 0.4.5? 2003-03-17 11:25 Hi, There is a patch for this here: http://sourceforge.net/tracker/index.php?func=detail&aid=681655&group_id=36382&atid=416705 I will be included in the next version. Thank you, Teodor

By: Minimini - minimini catencate null string in textfield 2003-03-17 05:04 I create a textfield with expression $F{a} + $F{b} + $F{c} a,b,c are string that can be null, I want the JR to display blank when they are null. The expression above give me nullnullnull in the report. i have try: ($F{a}==null)?"":$F{a} + ($F{b}==null)?"":$F{b} + ($F{c}==null)?"":$F{c} but got compile error about incompatible types Anyone can help me about this, thanks By: Minimini - minimini RE: catencate null string textfield (Omit it) 2003-03-17 05:09 Oh, I miss out the () for each ($F{a}==null)?"":$F{a} I solve the problem now By: Minimini - minimini RE: catencate null string textfield (Omit it) 2003-03-17 05:09 Oh, I miss out the () for each ($F{a}==null)?"":$F{a} I solve the problem now

By: ajay kumar - ajaykumar NoSuchFieldError: CHARACTER_ENCODIN 2003-03-10 22:25 hi! iam getting the following error while iam trying to print the report in CVS format from my servlet..iam sending the error log...can u tell me where i went wrong ???please go through the error and my servlet code.. CHARACTER_ENCODING java.lang.NoSuchFieldError: CHARACTER_ENCODING at dori.jasper.engine.export.JRCsvExporter.exportReport(JRCsvExporter.java:153) at com.fgs.sdpx.reportservlet.TradeCoReporter.service(TradeCoReporter.java:197) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1416) at allaire.jrun.session.JRunSessionService.service(../session/JRunSessionService.java:1082) at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1270) at allaire.jrun.servlet.JRunNamedDispatcher.forward(../servlet/JRunNamedDispatcher.java:39) at allaire.jrun.servlet.Invoker.service(../servlet/Invoker.java:84) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1416) at allaire.jrun.session.JRunSessionService.service(../session/JRunSessionService.java:1082) at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1270) at allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDispatcher.java:89) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1552) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1542) at allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:364) at allaire.jrun.http.WebEndpoint.run(../http/WebEndpoint.java:115) at allaire.jrun.ThreadPool.run(../ThreadPool.java:272) at allaire.jrun.WorkerThread.run(../WorkerThread.java:75) and my code is below: if(format.equals("cvs")) { try{ res.setContentType("application/vnd.ms-excel"); System.out.println("Inside xls loop"); System.out.println("file input to xls exporter:"+reportFile.getPath()); JasperReport jasperReport = JasperManager.loadReport(reportFile.toString()); JasperPrint jasperPrint = JasperManager.fillReport(jasperReport,parameters,con); dori.jasper.engine.export.JRCsvExporter exporter = new dori.jasper.engine.export.JRCsvExporter(); ByteArrayOutputStream csvReport = new ByteArrayOutputStream(); exporter.setParameter(dori.jasper.engine.JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(dori.jasper.engine.JRExporterParameter.OUTPUT_STREAM, csvReport); //System.out.println("after output file name"+reportFile1.toString()); //exporter.setParameter(dori.jasper.engine.export.JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporter.exportReport(); byte[] bytes=csvReport.toByteArray(); res.setContentLength(bytes.length); ServletOutputStream ouputStream = res.getOutputStream(); ouputStream.write(bytes, 0, bytes.length); ouputStream.flush(); ouputStream.close(); }catch (JRException e){System.out.println(e.getException());} } By: Teodor Danciu - teodord RE: NoSuchFieldError: CHARACTER_ENCODIN 2003-03-16 02:40 Hi, What version of JasperReports are you using? The CSV exporter was introduced in 0.4.3, but there is a version mismatch between the JRCsvExporter class and the JRExporterParameter class. Are you somehow using the JRCsvExporter class with an earlier version of JasperReports? This could happen if you manually copy the classes. Thank you, Teodor

By: Erich Kilmer - ekilmer JasperReport to JasperPrint without fill? 2003-03-14 11:54 What is the best way to get from a JasperReport to JasperPrint without filling with a result set? This would be used mainly for printing and debugging problems like the one I am having with rectangles.

By: Outey Ky - chhunak parameter within ' ' 2003-03-05 12:50 This part of my query.... AND GEDI_REGULATORY_TRANSACTION.TRAN_DATESENT >= TO_DATE('$P{predate1}','dd-mon-yyyy') How do I replace the single quote where I have my parameter as $P{predate1}, and I need the single quote wrap around because the parameter is a date from input field or else I get a sql error in jdbc. By: Dejan - dnikolov RE: parameter within ' ' 2003-03-05 23:32 try to follow parameter with ' and dont write ' in query. value of your parameter to have ' '. for example '12-12-2002' By: Dejan - dnikolov RE: parameter within ' ' 2003-03-06 02:41 try to follow parameter with ' and dont write ' in query. value of your parameter to have ' '. for example '12-12-2002' By: Outey Ky - chhunak RE: parameter within ' ' 2003-03-11 08:11 thank you....I understand what you're suggesting.I was also able to do this and got the same result... replace GEDI_REGULATORY_TRANSACTION.TRAN_DATESENT >= TO_DATE('$P{predate1}','dd-mon-yyyy') with this GEDI_REGULATORY_TRANSACTION.TRAN_DATESENT >= $P{predate1} thanks...I was just looking for an escape character and still keep the TO_DATE with ' ', but it's harder to build '' in your parameter. Thanks. By: Teodor Danciu - teodord RE: parameter within ' ' 2003-03-13 13:59 Hi, Not sure if the predate1 parameter is a Date or a String. Anyway, note that parameters can be used in the SQL query also using this syntax $P!{}. This is for dynamically supplying portions of the query and not usual parameters. Check the "query" sample to understand this syntax. I hope this helps. Teodor

By: Ruben Misrahi - rnmisrahi Invalid Cast 2003-03-06 14:36 After I make a design with iReport I get a compilation error: <I> Note: sun.tools.javac.Main has been deprecated. C:JavaTestJasperReportsdemosamplesjasperPO.java:167: Invalid cast from java.lang.Integer to java.lang.String. value = (java.lang.String)(((java.lang.Integer)field_PURCHASE_ORDER_ID.getValue())); <I/> Is this a bug? If so, does it belong to iReport or Jasper? Is there a way around it? Thanks By: Teodor Danciu - teodord RE: Invalid Cast 2003-03-13 13:43 Hi, You are trying to display an Integer into a text field who's expression class is String. Check the "class" attribute of the <textFieldExpression> tag. I hope this helps. Teodor

By: Adrian Jetzer - tripletuned Jasper in WebServer (Tomcat) 2003-03-09 23:52 Hi there! I've found some postings about this topic, but I couldn't find a good solution. I try to run Jasper in a Tomcat server. I access Jasper via a WebService (JAX-RPC). The problem is, that Jasper can't find it's own classes. (Package dori.jasper.engine not found in import. import dori.jasper.engine.*;) I'm able to run the whole thing, when I set the property: System.setProperty("jasper.reports.compile.class.path", "c:/JavaLib/jasperreports-0.4.5.jar"); But I'm not satisfied with that. I want, that Jasper Recognize it's classLoader automaticly, so that I don't need the command above. Something like: JasperManager.setClassLoader(this.getClassLoader) .... Or something like this. Greetings, Adrian By: Teodor Danciu - teodord RE: Jasper in WebServer (Tomcat) 2003-03-13 13:27 Hi, It is not really about JasperReports not finding its own classes, but rather about supplying the the Java compiler with the correct classpath it needs in order to compile the report expression class. If you place JasperReports in the classpath of the JVM instance that compiles the reports, you won't need to use the "jasper.reports.compile.class.path" system property as the engine uses the "java.class.path" system property by default. I hope this helps. Teodor

By: Jakub Posiada?a - qtaster Problem with page break on pages>1 2003-03-13 04:00 Hello everybody I think Jasper has problem with proper page breaking. It breaks second ( also 3rd 4th ... ) page to early, leaving about 10% of page blank while bottomMargin=0. My report contains big parts of static text. (xml with my report below). I've tried to divide this text into few smaller textFields, but this gave no result. I'm using JR v. 0.4.4 and itext 0.96. Had anyone similar problem? Any suggesions Thanks for help. Kuba <?xml version="1.0" encoding="windows-1250"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="potw_zal_lok" columnCount="1" printOrder="Vertical" pageWidth="595" pageHeight="842" columnWidth="495" columnSpacing="15" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="0" isTitleNewPage="false" isSummaryNewPage="false" whenNoDataType='BlankPage'> <queryString> <![CDATA[ SELECT 1 FROM dual ]]> </queryString> <title> <band height="0"> </band> </title> <pageHeader> <band height="0"></band> </pageHeader> <columnHeader> <band height="0"> </band> </columnHeader> <detail> <band height="822"> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" x="0" y="53" width="555" height="0"> </reportElement> <textElement textAlignment="Left"> </textElement> <textFieldExpression class="java.lang.String"> "? 1n"+ "1.xxxxxxxxxxxx xxxxxxx xxxxxxxxxxxxx nx xxxxnxxxx xxxxxxxnxxx x xxxxxxxx xxxxxnxxxxnxxxx nxnxxxxxxx xxxxx xxxxxxx x xxxxxxxxx xxxxxxx xx xxxxxNxxx, xxxnxxx xxxxx xxxxxxxxxx, x xxxxxnxxxxnxxx nx xxxxx xxxxxxxx xxxxx xxxxxxx, xxx .............................................................................., nx nxxxxxxxx xNxNxxx, nx xxxnxxx xNxxxxx, xxx xxxxxxxxx xxxxxxxxxx, xxxnxxx xxxxx xxxxxxxxxx xxxx xxxxxxxx xxxxxxx xxxxnxxxxnxx xxxxxxxxxxxx, xxxxxxxxxxnxx xxxxxxx,"+ " xxxxxx xx xxxxxx xxxxxxnxxxxx, xxxxxxxxxxnxx nx xxxxx. n"+ "2.xxxxxxxxxxxx xxxxxxxxxxx xxx xxxxxxxnxx xxxxxx x xxxxxnxx xx 14 xnx xx xnxx xxxxxxxx xxxxx.n"+ "4.xxxxxxxxxxxxx xxxxxxxxx, xx xxnx nxxxxxx xxxxxxx, xxxxxnx xxxx xxxxxxxx xxxxxxx, xxx x xxxx xxxxxxxxxxnxx xxxxxxx, xxnxxx xxxNxx xx xxxxxNxxxxxNxx.n"+ "5.xxxxxxxxxxxxx xxxx xxxxxxxxxnx xx xxxxxxx xxxxxxx xxxxxx xx x xxnx nxxxxxx xxxxxxx.n"+ "6.x xxxxnxx x xxx. 1 xxxxx xxxxxxxxn"+ "xxxxxxxxxxxxxxNxx xx xxxx xxxxxnxxxxnx nx xxxxxxx xxnx nxxxxxx xxxxxxxn"+ "xxxxxxxxxx xx xxxx xxxxxnxxxxnx nx xxxxxxnxx xxxxxx xxxxxxxxxx xx, xx + xx, n"+ "xxxxxxxxx xx xxxx xxxxxnxxxxnx nx xxxxxxnxx xxxxxxx xxxxnxxxxnxx xxxxxxxxxxxx xxxxxxx,n"+ "xxxxxxxxxxNxxxxx xx xxxx xxxxxnxxxxnx nx xxxxxxnxx xxxxxxxx ,n"+ "xxxxxxxxxxxNxxx xx xxxx xxxxxnxxxxnx nx xxxxxxnxx xxxxxxxx xxxxxxxxxxxx,n"+ "xxxxxxxxxx xx xxxx xxxxxnxxxxnx nx xxxxxxnxx xxxxxxxxxxnxx nx xxxxx xxxxxxxxxxxxx.n"+ "7.xxNxxxxx6xxxxxxxxxxxxxx xxxxxxxxxnx xxxx xx xxxxxxx xxxxxxxxn"+ "xxxxxxxxxxxxxx xx nx xxxxxxnxx xxxxxx xxxxxxxxxx xx, xx + xx, n"+ "xxxxxxxxxxxxx xx nx xxxxxxnxx xxxxxxx xxxxnxxxxnxx xxxxxxxxxxxx xxxxxxx,n"+ "xxxxxxxxxxxxxx xx xxxxxxxx ,n"+ "xxxxxxxxxxxNxxxxxx xx xxxxxxxx xxxxxxxxxxxx,n"+ "xxxxxxxxxxxxxx xx nx xxxxxxnxx xxxxxxxxxxnxx nx xxxxx xxxxxxxxxxxxx.n"+ "8.xxxxxxxxx xxxxx xxxxxxx x xxxxxxxxx nxx xxxnxxx xxxxx xxxxxxxx xxxx xxxxxxx xxxxxxxxxxxxxxxx xxx nx xxxxxxxxx x xxxxxxxnxx xxx.12 xxxxxx x 20 xxxxx 2001x. x xxxxxxxx xxnxxxxnxxxx. n"+ "xxxxxxxxxxxNxxxxxxxxxxxxxxxxxxnxxxxnxxnxxxxxxxxnxx xxxxxxxx xxxxxxxxxxxx,n"+ "xxxxxxxxxx xx xxxx xxxxxnxxxxnx nx xxxxxxnxx xxxxxxxxxxnxx nx xxxxx xxxxxxxxxxxxx.n"+ "7.xxNxxxxx6xxxxxxxxxxxxxx xxxxxxxxxnx xxxx xx xxxxxxx xxxxxxxxn"+ "xxxxxxxxxxxxxx xx nx xxxxxxnxx xxxxxx xxxxxxxxxx xx, xx + xx, n"+ "xxxxxxxxxxxxx xx nx xxxxxxnxx xxxxxxx xxxxnxxxxnxx xxxxxxxxxxxx xxxxxxx,n"+ "xxxxxxxxxxxxx xx xxxxxxxx ,n"+ "xxxxxxxxxxxNxxxxxx xx xxxxxxxx xxxxxxxxxxxx,n"+ "xxxxxxxxxxxxxx xx nx xxxxxxnxx xxxxxxxxxxnxx nx xxxxx xxxxxxxxxxxxx.n"+ "8.xxxxxxxxx xxxxx xxxxxxx x xxxxxxxxx nxx xxxnxxx xxxxx xxxxxxxx xxxx xxxxxxx xxxxxxxxxxxxxxxx xxx nx xxxxxxxxx x xxxxxxxnxx xxx.12 xxxxxx x 20 xxxxx 2001x.n"+ " x xxxxxxxx xxnxxxxnxxxx. n"+ " ? 2n"+ "1. xxxxxxxxxxxxx xxxxxxxxxxx xxx xxxxxxxxxxx xxxxx xxxxxxxnxxx xxxxxxx xxxxxxnxx nx xxx xxxxxxxnx x xxxxxx.n"+ "2. xxxxxxxxxxxxx xxxxxxnxx xxxxxxxxxxxx xx xxxxxxxnxx xxxxxxx nx xxxxxnxx xxnxxxx , x xxxx xxxxxxxxxxnxx xxxxx xxxxxxxxxxxx xxxxnxxxx,n"+ " xxxxnxx x ? 1 xxx.1.n"+ " ? 3n"+ "1. x xxxxxxxxxxxxxxxxxxnxx xnxxxxx x xxxxxx xxxx xxxxxxxxxxnxx x xxxxxxxx xxxxx xxxxxxxxxx xxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxx xxxxxxx xxxxxxx xx xxxxxxxxxxxxxn"+ " xxxxxx x xxxxxxxxx 30 xx xxxxxnxx xxxxxxxxxxx xxxxxxxx n"+ " xxxxxx, x xxxxxx xxxx xxxxxxx nxx xxxxxxx xxnxxxxxxnxx xnx xxxxxxxx x xxxnxx xxxxxxx.n"+ "2. xxxxxxxxxxxxx xxxxxxxxxnx xxxx xx xxxxxxx nx xxxxx xxxxxxxxxxxx xxxxxxxx xx xxxxx xxxxxnxnxxx xxxxxxx x xxxxxxxxx xxxxxxxxxxxxxNxxx x xxxxx xxxxxxx.n"+ "3. xxxxxxxx, x xxxxxxx xxxx x xxx. 1 x 2 nxnxxxxxxxx xxxxxxxxx xxxxxxxnx xxxx x xxxxx xxxxxxxxxnxxx xxxxxxxxxxxxnx xxxxxxx x nxx xxxxxxxxx xxxxxxxx x xxxxxxxxxn"+ " xxxxxxxxxx xxxxxxxxxxnxxx xxxxxxxxxx xxxxx.n"+ "? 4n"+ "1. xxxxxxxxx xxxxx xxxxxxx, xxxxx xxxxxxxxxnx xxxx xxxxxx xxxxxxxxxxxxx, xxxxnxx x xxxxxxxxxx xxxxxxxxxxxxxxxNxxx xxx, xxxxxxxxx nxxxxnxxx xxnxxxx xx xxxxn"+ " xxxxx xxxxxxxxxnxx xxxxxxxxxx xxx x xxxxxxxx xxxxxxxxxxxxxNxxx xxx, xxxxnxx xxxnxxx xxxxxxxx xxxxxxxxxxxNxx xx xxxxxNxxxxxxxxx.n"+ "2. x xxxxxxxxx xxxxxxnxxxxnxx xxxxnnxxx xxxxxxxxx xxxxx xxxxxxx, x xxxxxx xxxx xxxxxxx, xxxxxxxnx xxxx x xxxxxxx x xxxxxxnxx xxxxxxxxxxxx xxxxxxnxxxxnxx.n"+ "? 5n"+ "1. xxxxxxxxxxxxx xxxxxxxxxxx xxx xxxxnxx xxxxxx xxx xxxxxxxxxx x xxxxxxxxxxx x xxxxxxxx xxxxxxxxnxxx xxxxxx xxxxxxxxxxxxxxxxxx xx xnxx xxxxxxx,n"+ " x xxxxxnxx xx xxxxxxNxxxxxxxxx xnxx xxxxxxx xxxxxxxx nx xxxxxnxx xxxxxxxxxxxx nx xxxxxnxx xNxxxxxxxx. xxxxxxxxxxnxxx xxxxxx xxxx xxxxxxxnx xxxxxxn"+ " xxxxx xxxxxxxxxxxx xxxx xxxxxxx x xxxxxnxx xxxxxxxnxx x nxnxxxxxxx xxxxxxx.n"+ "2. xNxxxxx6xn"+ "3. xx xxxxxn xxxxxx xxxx xxxxxxxxxxxxxxxxxxxxx xxxxxxxxx xxx xxxx xxxxxx xxxxxxx nx xxxxxnxx xxxxxxxxxxxx.n"+ "4. x xxxxxxxxx, xxx xxxxxn xxxxxx nxxxxnxxxx xxxxxxxxxxxx xxxxxxxx nx xxxxx xxxxxxxx xxxnx xx xxxxx, xxxxxn xxn xxxxxx x xxxxxxxxx xnxx xxxxxxxx xx xxx xxxxxnxx.n"+ "? 6n"+ "1. xxxxxx xxxx xxxxxxnxxxxnx xxxxxx xxxxx xxxxnnxx, xxxxxxnxx xx xxxxxxxxxxxxx x xxxxxxxxxxxx x xnxx xxxxxxxx xxxxx xxxxxxx xxxxxxnxxxxnxx xxxxxxxx xxxxxxxxnxxx xxxxxxxnxxx xxxxx .x n"+ " 1. xxxxxxnxxxxnxx xxxxxxx x xnxx xxxxxxxnxx xxxxx xxnxxx xxxxxxxx x x.x.n"+ " 2. x xxxxxxxxx xxxxxxnxxxxnxx xxxxxxx xx xxxxnnxx xxxxx xxxxxnxxxxx, x xxxxxxx xxxxnxx xxxxx xxxxxxxx xxxxx xxxxxnxxxxx xxxx xxxx xxxxnxx x xxxxxxxxxx n"+ " xx xxxxnx xxxxxxxxxxxx xxxx xxxxxnxxxxxx Nxx, n"+ " xx xxxxnx xxxxxxx xxxxxx xxxxxxxxxxxxx, xxxxxxnxxx xxxxx xxxxxxx Nxx,n"+ " xx xxxxnx xxxxxx xxxxx, xxxxxxxxxxxx xxxxxxnxxxxnxx xxxxx xxxxxxxxnxxxxxx,n"+ " xx xxxxxxxxxnxx nxxxxx, xxxxxxxxnxx xxxxxxxxxxxxxx xxxxxxxxx xxxxnxxx, xxxxxnxxnxx xxxxxxx xxxxxxxxxxxxx xxxxxxxx xxxxx nx xxxxxx xxnxxxxnxxxnxx xxxxxxxxxxxx.n"+ " x xxxxxxxxx xxxxxxnxxxxnxx xxxxxxx xx xxxxnnxx xxxxx xxxxxnxxxxx, xxxxxnxxnxx xxxxxxxxxxxxx x xxxxxnxxnxxx xxxxxxxnxxxx, xxxxxxnxx xxxxxxxxxxxx xx xxxnxxxxxnnxx xxxxnx xxxxxxxxx x xxxxxx xxxxx xxxxxxnxxxxnxx xxxxxxx xxx xxnxxxxnxxxx xxxxxxxxxxnxx xxxxx. n"+ "2. xxxxxxx xx xxxxxnx xx xxxxx xxxxxxxxnxx x xxxxxxx, xxxxxxxxx xx xnxx xxxxxxx xxxxxxx xx xnxx xxxxxxxxxxxxxxx xxxx xxxxxxxxx xxxxxx. n"+ "3. xxxx nxxxxxxnxx xxxxxxx xxxxxxxxx xxx, xx xxx xxxxx 360 xnx, x xxxxxxx 30 xnx.n"+ "4. x xxxxxxxxx nxxxxxxxxxxnxx xxxxx xxxxxxxxxxxxx xxxxnxxx xxxxxxxnxx xxxxxxx xxx x xxxxx xxxxxxxnxx xxxxxnxxxx xxxxxx xxxxxxx x xxxxxx xxxxxnxx xxxxnx xxxxxxxx xxxnxxxxxnx x xxnxnxxxxx xxxxxxxxxxxxx, xxxxxxxxxxxx xxxx xxxxnxx xxxxnx xxxxx xxxxxnxxxxx. xxxxnx xxxxx xxxxxnxxxxx x xxxxxxxxxx xxxxxx nxx xxxxxx xxxxxxxxxxxx 5,0 xxnxxxx xxxxxnxxxxxx. n"+ "5. x xxxxnxx xxxxxxxxx xxxxxxnxxxxnxx xxxxxxx, x xxxxxx xxxx x xxx. 1. xxx. 2. x xxx. 4 xxxxxxxxxxxx xxxxxxxxxx nx xxxxxx xxxxxxxxxxxxx x xxxxxxxxxxxx, xxxxxxxxxxx xxxnxxxxxnxx xxxxxxxxxxxxx nxxx xxxxxnxxxxx xxxxxx xxxxxxx.n"+ "? 7n"+ "1. xxxxxxxxxxx xxxxnx xxxxx xxxxxxnxxxxnxx xxx xxxxxxx xxnxxx xxxxxxxxxxxxx x xxxx xxxxxxxnx xxxxnxx xx xxxxxx xxxxxxxxxxnxx xxxxxxnxx nx xxxxxxnxxx xx xxxxxx x 20 xxxxx 2001x x xxxxxxxx xxnxxxxnxxxx xxx. x. Nx 100 x 18.09.2001x., xxx. 1081xn"+ "2. x xxxxxxxxx xxxxxxnxxxxnxx xxxxnnxxx xxxxxxxxxxx xxxxnx xxxxx xxxxxnxxxx, x xxxxxx xxxx xxxxxxx, xxxxxxxnx xxxx x xxxxxxx x xxxxxxnxx xxxxxxxxxxxx xxxxxxnxxxxnxx.n"+ "? 8n"+ "1. xxxxxxnxx xx xxx. 97 xxxxxx x xnxx 29 xxxxxnxx 1997 x. xxxxx xxnxxxx xxx. x. Nx 140 xxx.939x xxxxxxxxxxxxx xxxxxxxxx, xx x xxxxxxxx xxxxxxxx, xxxxxxxxxxxxx xxxxxxnxx xxxxxxxxxxxx xx xxxxxxxxxxnxx xxx xxxxxx xxxxxxxxx xnxxxxxxxx x xxxxxxxxxxxxx. xxxxxxxxxxxx xxxxnxxnx xxxx xxxxxxx x xxxxxxxxx xxxxxnxxx xxnxxxxx xxxxxxxnxx xx xxxxxnxxxxx xxxxxx x xnxx 29.08.1997x. x xxxxx xxnxxxxx x xxxxxxxxxx xxnxxxxxxxxx x xxxxxx x xxxxxnxx xxnxxx xxxxxxxxx x xnxx 29.08.1997x.n"+ "? 9n"+ "1. xxxx xxxxxxxxxxxnxx xxxxxx xxxxxxxnxxx xxxxxxx xxxx x xxxxxxxxx xxxx xnnxxx xxxxxxxx xxxxxxxxxxxx xxnxxxxxxxxx x nxnxxxxxxx xxxxx xxxxxxxxxxxxx xxxxnxxxx nx xxxxx xxxxxxxxxxxx nx xxxx xxxxx xxxxxxxxxnxx, xx xx xxxxxxxxxxx xxxxxxxxxnxx xxxxxxxxxx xxxxxxxx xxxxxxxxxxxx nxxxxxxxxxx xxxxxxxxxxxnxxx n"+ " xxxxxxxxxxxxxxnxx xxxxxxx nx xxxxxxxxxxxnxx, nx xxxxxxxx xxxxxxxnxxx x ? 10 nxnxxxxxxx xxxxx,n"+ " xxxNxxxxx6xn"+ " xxxNxxxxx6xn"+ " xxxxxxx xx xxxxxxxnxx xxxxxxxxxxxxxxxx x xxxxxxx xxxxxxxxxxnxx x xxxxxx xx xxxxx xxxxxxxx,n"+ " xxxxxxxx xxxxnx xn xxxnxx nxx nx xxxxxnxx, xxxxxxxnx xxxxxx xxxxxxxxxxxxxx n"+ " xxxNxxxxx6xn"+ "2. x xxxxxxxxx xxxxnxxxxnxx xxxxxxxxxxxnxx x xxxxxxx xxxxxxxxxxxxnxx xxxxnxx x xxx.1 xxx. xx, xxxxxxxxxxxxx xxxxxxxxxnx xxxx xx xxxxnxnxx xxxxxxxxnxxxx xxxxx x xxxxxxxx xxxxxxxxxxxnxx xxxxxxx.n"+ "3. Nx xxxxnxx xxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxnx xxxx xx xxxxnxxxxnxx x xxxxxnxx 30 xnx xxxxxxxxxxx xxxxxxxxxxxnxx xxxxxxx x xxxxxxxxxx n"+ " 1x nxx xxxxxxxxnxx xxxxnxxx xxxxxxxnxx xxxxxxx,n"+ " 2x xxxxxxxnxx xxxxxnxxxx xxxxxx xxxxxxx x xxxxxx xxxx xxxxxxxx xxxxxxxxxx xxxxxxxxxxxxx,n"+ " 3x xxx xxxxxxx xxxxnxxxxnxxx xxxxxxxxxxxx xxxxxxx xxnxxxxxxxx xxx xxx xxx xxxxx xxnxxxxxxnxx xxx xxx xxxxxxxx,n"+ "4. xxxxnx xxxxx, xxxxxxxxxx xxxx xxxxxxx xxxxxxxxxxxnxx xxxx xxx xxxxnxnx nx xnxxxxx xxxxxxxxxxxxx, xxx xxxxnxxxx, xx nxx xxxxxnxx xxxxxxxnx xxxxxx xxxxxxx xxxx x xxxxxxxxx.n"+ "5. xxxxxxxxxxxxx xxnxxx xxxxxx xxxxnxxxxnxx, xxxxnx x xxxxnxxnxx xxxxxxxxxxxnxx xxxxxxxnxxx xxxxxxx x x xxxxxxxxx xxnxxxxxnxx xxx xxxxx xxxxxxxxxxxx, xxxxxxxxxxxxx xxxxxxxxxxx xxx xx xxx xxxxxx.n"+ "6. xxxxxxxxxxxxx nxnxxxxxxx xxxxxxxxxx, xx xxxxxxxxxxxnxx xxxxnxxxxnx xxxxnxx x xxx. 1 xxx. xx x xx nxnxxxxxxxx xxxxxxxxx xxxxxxxxx xxxx xxxxxxxxx xxxxxx xxxnxxxxxxxnx x xxxxxxxxx xxxx xxxxxx xxxxxnnx, xxxxxxx, xxxxnx, xxxxxxxxxxx xxx xnxxxxxxxnxxnxx xx xxxxnxx xxx xnxxxxxxxx.n"+ "7. xxxxxxxxxxxxx xxxxxxxxx, xx xxxxxx xxxx xxxx xxxxxxnx xxxxnxxxxx x xxxx xxxxxxxxxxxnxxxx xxxxnxxxxnxxx xxxxnxx x xxx.1 xxxxxx xxxnx xxxx xx xxxxxxxxx xnnxxx xxxxxxxxxxxx x xxxxxxxx xxxx xxxxxxxx.n"+ "8. xxxxx xxxx xxxxxxxxxxnxx nxnxxxxxxx xxxxx xxxxxxxxxxxxx nxx xxxx xxx xxxxx xxxxxxxxxxxx xxxxnxxxx xxxxnxxxx xxxxxxx nx xxxxx xxxxxxx.n"+ "? 10n"+ "1. xxxxnxx x ? 9 xxx. 1 xxx. 1 xxxxxxxxxxxxx xxxxxxx xxxxxxxxxxxnxx xxxxxx xxxxxxx xxxx xxxxxxxxx xnnxxx xxxxxxxx x xxxxxx nxnxxxxxxx xxxxx xxxxxxx xxxxnxxxxxnxx x xxxx nxnxxxxxxx xxxxx xxxxx xxxxnxxxx xxxxxxx nx xxxxxxxxxxxx xxx xxxxnxxxx xxxxxxxxxxxxx xxxxxnxx xxxxx xxxxxxxxxxxx xxxxxnxxx xxxxxxxxxnxx x xxxxxxxxx xxxxnxxxxxnxx xxxxx xxxxnxxxx xxxxxxx.n"+ "2. xxxxxxxxxxxx xx xxxxx xxxxxx xxxxxxxxxnxx x xxxxxxxxx xxxxnxxxxxnxx xxxxx xxxxnxxxx x xxxxxxxxx nxxxxxxnxx xxxxxnxxxxx nxnxxxxxxx xxxxx xxx xxxxxxxnxx xxxxxnxxxx xxxxxx xxxxxxx, x xxxxx x xxxxxxxxx xxx xxxxxxx x xxxxxxxnxx xxxxxxx xxxxxx xxxxxxx nx nxxxxxxxxxxxxx, nxxxxxnxxx xxx xxxxxxxx xxnxxx xxxxxxxxxnxxx xxxxxxxxxxxx.n"+ "3. xxxxxnxx xxxxxxxxxnxx x xxxxxxxxx xxxxnxxxxxnxx xxxxx xxxxnxxxx xxxxxxx xxxx xxxxxxxnx x xxxxxx xxxxxxxnxx xxxxxxxxxxxxx, x x xxxxxxxxx, xxx xxxxxxxxxxxxx nxx xxxnx xxxxxxxx xxxxxxxxxnxx x xxxx xxnx, x xxxxxx xxxxxnxx xxxx xxxxxxxxxnxx x xxxx xxxxxx, xx xxxx xxx xn xxxxxnxx x xxxx xxxxxxx. n"+ "4. xxxxxxxxxxxxx xxxx xxxxxxxxxnx xxxxx xxxxxxxxxxxx xxxxxxxxxxxxnx xxxxxx nx xxxxxnx xxxxxnxx xxxxxxxxxxxx x xxxxxnxx xxxxxxxnxx x xxxxxnxx.n"+ "5. xxxxxxxxxxxxnx xxxxxx xxxxxxxxxxxx xxxx xxxxxxxxx xxx xxxx xxxxxx xxxxx xxxxxxnxxx xxnxnxx. n"+ "6. x xxxxxxxxxxn"+ " xx xxx xxxxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxxnx xxxxxx, xxxxxxxxxnxx xxxxxxxx xxxxxxxxxxxx nxxxxxxxx xx xxxxxxxxx xxxxxxxx xxxxxxx x xxxxxx xxxx xxxxxxxxxxxxnxx. xxxxxxx xxxxxxx xxxxxx xxxxxxxnx nx xxxxxxxxx xxxxnx xxxxnxnxx xxxxx xxxxxxxnxxxx xxxxxxxxxxxnxxx xxxxx xxxxxxxxxxxx,n"+ " xx xxx xxxxxxxxxxxx xxxxxxxxx xxxxxxxxxxxxnx xxxxxx, xxxxxxx xxxxxxx xxxxxxxxxxxxx xxxxxxxxx xxxxxxnx xxxxxx nx xxxxxxxxx xxxxnx xxxxxxxnxxxx xxxxxxxxxxxnxxx xxxxx xxxxxxxxxxxx, nxxxxxxxx xxxxxxxxxnxx xxxxxxxx xxxxxxxxxxxx nxxxxxxxx xx xxxxxxxxx xxxxx xxxxxxnxx xx xxxxxxxxx, xxxnxxxxxxnxx x xxx x xxxxxx xxnxxxxxnx xxxxx xxxxxxxxxxxx xxxxxxnx x xxxxxxxxxx xxxxxxx x xxxx xxxxxxxxx.x xxxxxxxxxxxxx xxxxxxxxx, xx nxnxxxxxxx xxxxxxx nxxxxxxxxxnxxx xxxnxxxxnxxxxx nx xxxxx xxxxxxxxxxxx xx xxxxxxxxx xxxxxxxxxxxxnxxx xxxxxxx x xxxxxnxx xxxxxx. xxxxxxxxxxxx xxxxxnxx xxxxxxxxx xxxxxxxxxxxxx, xxx xxxxxxxx x xxxxxxxxxnxx x xxxxxxxxx xxxxnxxxx xxxxxxx, xxx xxxxxxxxx xxxxxxxnx xxxnxxxxnxxxxx xx xxxxxxxxx xxxxxxx, xxxx xxxx xxxxx nxxxxx xx xxxxxxxxxxxx.n"+ " xx xxx xxxxx xxxxnx, x xxxxxx xxxx x xxx xx xxx xxxxx xxxxxxnx xx xxxxxxxxx, xxxnxxxxxxnx x xxx x xxxxxx xxnxxxxxnx xxxxx xxxxxxxxxxxx xxxxxxnx x xxxxxxxxxx xxxxxxx x xxxx xxxxxxxxx, x xxxxxx xxxx x xxx xx nxx xxxxxxx x xxxxxxx xxxxxxxxxnxxxx, xxxxxxxxxxxx xxxx xxxxxxxxx xxxxxxxxxx xxxxxx xxxxxxxxxnxxxx x xnnxxx xxxxxxxxxxxx, xxxxxxx xxxxxxxxxxxxx, xxxx xxx nx xxxxxx xxxxxxxxxnxx xxxxxxxx.n"+ "7. xxxxx xxxx xxxxxxxxxxnxx nxnxxxxxxx xxxxx xxxxxxxxxxxxx nxx xxxx xxx xxxxx xxxxxxxxxxxx xxxxnxxxx xxxxnxxxx xxxxxxx nx xxxxx xxxxxxx.n"+ "? 11n"+ "xxxxxxxxxxxxx nxnxxxxxxx xxxxxxxxxxx xxx xxxxxx nx xxxxnx xxxxx xxxxxxxx xxxnnxxxx xx xxx xxxxxxxnxx xxxxxxnxxx x xxxnxxxxnxxxx x xxxxxx xxxxxxnxx xxxxx xxxxxxxxxxxxx xxnxxxxnx x xxxx xxxxxxxnxx xxxxxxxxxxxx xxxxnxxxnxx xxxx x nxnxxxxxxx xxxxx xx xxx xxxxxxxxnxx xxxxxxxxxnxx x xxxxxxxxxxxnxxx xxxx nxxxxxxxxxnxx xxxxnxxxx xxxxxxxxxxxx xxxxx xxxnxxxxnxxxxx x xxxxxx xxxxnxxxnxx xxxxxxxxx xxxnnxxxx, xxxxx xxxxxxxxxxxxx xxxxxxxxxnx xxxx xxxxnxx xxxxnxx x nxnxxxxxx xxxxx.n"+ "? 12n"+ "1. xx xxxxxx nxxxxxxxxxnxx x xxxxxnxx xxxxxxxnxx x xxxxxnxxxxxxx xxxxx, x xxxxxx xxxx x ? 5 xxx. 1, xxxx xxxxxxxxxxx xxxxxxx xxxx xx xxxxx xxxnxxxxxxx nxxxxxxxxx xxxx xxxxxxxxxxx xxxxxxx, xx xxxxx xxxxx xxxxnxxnxx nxxxxxx xxx x xxxxxxx xxxxxxx xxxxxx xxxxx xxxxxnxxxxx xxx nxxxxnxxxx xxxxxxxxxnxxxnxxx, xxxnxx xxxxxx xxxxxxnxxxxnxx xxxxxxx xxxxxxxxxnxx x 75xn"+ "2. x xxxxxxnxx xxxxxxxxxx x xxxxxxx xxxxxxx xxxxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxxx x xxxnxxxxnxxx xxxxxxxxxxxx nx xxxxxx.n"+ "3. Nxxxxnxxxx xxxxxxxxxxxx x xxxxxx nxxxxxxxxnxxx xxxxxxx xxxxxxxxxnx xx x nxxxxxxxxxxx xxxxxnxxxxx xxxxxx xxxxxx, xxxxxx xxxxxxxxxnx xxxx xxxxxx xxxx xx xxxxnxxx, xxxxxxx nxxxxxxnx xx xxxx xxxxxxxx xxxxxxx xxxxxxxxxnxx, nxxxxnx xxxxxxxxxxxx xxxxxxxx, xxxxxxx xx xxxxxxxnxx xxxxxxxxxnxxxnxxx, xxxxxxx xxxxxxx, xxxxx nxxxxxxxxnxxx xxxxxxxn"+ "? 13n"+ "1. x xxxxxxxxx xxxxxnxxxxxxx xxxxxx xxxxxxx xxx xxxxxx xxxxxxx x xxxxxx xxxnxxxxxxx xx nxxxnxxx 5 xxx xxxxxxxxxxxxxxxxxxxxxx, xxxxxxxxxxxx, nx xxxxxxxxx xxxxxnxx xxxxxxxxxx xxxxxxxxxxxxx, xxxxxxxxx nxxxxxxnx x xxxx xxxxxxx xx nxxxxnxxx xx xxxxxxxnx xxxxx xxxxxxxxnxx x xxxxxxx. x xxxxxxxxx, xxx xxxxxnxxxxxx xxxxxx xxxxxxx xxxxxx xxxxxxx, xxxxxxxxxxxx, nx xxxxxxxxx xxxxxnxx xxxxxxxxxx xxxxxxxxxxxxx, xxxxxxxxx x xxxxxxx xxxxxxxxxxxxx nxxx xxxxxnxxxxx xxxxxx xxxxxxx.n"+ "2. xxxxxxxxxxxxx xxxxnxxn xxxxnxxxx xxxxxnxxxxxxx xxxxxx xxxxxxx xxx xxxxxx xxxxxxx x xxxxxnxxx xnxxxxnxx xxx xxxxxxxnxxx x ? 3 nxnxxxxxxx xxxxx. x xxxxxxxnxx xxxxxxx xxxxxxx nxxxxxxnxxx xxxxxxx xx nxxxxnxxx xx xxxxxxxnx xxxxx xxxxxxxxnxx x xxxxxxx nxxxxxxxx xxxx xxxxxxxnxxnxx xxxxxxnxxx x nxnxxxxxxx xxxxxx xxxxxnx xxxxxx xxxxxnxx xxxx.n"+ "3. xxxxxnx xxxxxxxxxx, x xxxxxx xxxx x xxx. 1, xxxxxxxxxxxxx xxxxxxxxxnx xxxx xxxxxxxxxx xxxxxxxxxxxx xx nxxxnxxx 7 xnx xxxxx xxxxxnxx xxxxnxnxx xxxxxnxxxxxxx xxxxxx.n"+ "4. xxxxxnxxxxxx xxxxxx xxxxxx xxx xxxxxxx xxxxxxx xxx xxxxxxnxxxx xxxxxnxx xxxxxnxx xxxxxxxxxx, x xxxxxx xxxx x xxx. 1 xxxxxx xxnxnx xxxxx xxxxxxxxxxxx xxxx xxxxnxxnxx xxxxxxxxnxx xxxxx xxxxxnxx xxxxxxxnxxxx xxxxxx xxx xxxxxnxx xxxxx xxxxxxxxxxxxx xnnxx xxxxxxxxxx.n"+ "5. xx xxxnnxxxx xxxxxxxxxxxx xxxxxxxnx x xxx.1 xxxxxxnx xx xxxxxxxxxnxxx nxxxxx xxxxxnxxxxxx xxxxx, xxnxxxxxxx x xxxxxnxxxxxxx xxxxxx xxxxxx xxxxxxx, xxxxxxxxxxxx xxxxxxx xxxxxx x xxxxxxxxx 50 xx. xxxxxnxx xxxxxxxx xxxxxxxxxxxxx.n"+ "? 14n"+ "1. xxxxxxxxxxxx xx xxxxx xxxxxxxxxxnxx xxxxx xxxxxxx x xxxxxxx xxx x xxxxxx, xxx xxxxxxxxxxxxx xxxxxx x xxxxxx x xxxxxxx xxxxx xxxnxxx xxx xxxxxxx x xxxxxx xxxxxnxx xxxxx xxxxxxxxxxxx xx xxxxxxx nxx xxxxxxxxxx xxxxxxxxxx x xxxxxnxx 7 xnx xx xxxx xxxxxxxnxx xxxxxnxx.n"+ "2. x xxxxxxxxx xxx xxxxxxxxxxxxx nxx xxxxnxxx, x xxxxxnxx 7 xnx xx xnxx xxxxxxxx nxnxxxxxxx xxxxx, xxxxxxnxxx xxxxxxxxxxxx, xxxxxxxxxxxx xx xxxxx, x xxxxxxx x nxxxxxxnxxx xxxxx xxxxxxxxxxxxx xxxxxnxxx xxxxxnxxxxx nxnxxxxxxx xxxxx, xx xxxxxxxxnxx xx nxnxxxxxxx xxxxx. n"+ "3. xxxxxxxxxxxx xxxx xxxxxxxxxxxx nxnxxxxxx xxxxx x xxxxxxx xxx x xxxxxx xxxnxxx x xxxxxxxxx xn"+ " xx xxx xxxxxnxx xxxxnxxnx, xx xnxxxxxxxx xxxxnx xx xnxxxxx xxxxxxxxxx xxx xxxxxxnxx, nx xxxxxxxxx xxxxxxx xxxxxxx xxxxxxx x xxxxxxxnxx xxxxxxx xx nxxxxxxxxxxx,n"+ " xx xxxxxxxxxnxx, xx xxxxnxx xxxxxxxnxx xxxxxxx nxx xxxxxxx xxxxxxxxnx xxx x xxxxx xxxxxxxnxx xxxxxnxxxx xxxxxx xxxxxxx x xxxxxx xxxx xxxxxxxx xxxnxxxxxnxxxxnxnxxxxx xxxxxxxxxxxxx,n"+ " xx xNxxxxx6xnxx xxxxnxxxnxx xxx nxxnxxxxxxxxx xxxxnxxxnxx xxxxxxxxxx xxnxxxxxxxxx x xxxxx xxxxxxxxxxxxnxx xxxxxx xxxxxxxx,n"+ " xx xxx xxxxxxxxxxxxx nxx xxxxnx xxxxxxxxxxx xxxxxxxxxxxnxx, x xxxxxx xxxx x ? 9 xxx. 3.n"+ "4. xx xxxxxxx xxxxxx xxxxxxxxxxnxx nxnxxxxxxx xxxxx xxxx xxxxx xxxxxxx xxxx xx xxxxxxxxxx xxxxxxxxx x xxxxxxxx xxxxx xxx xxxxxxxnx xxx xxxxxxxxxxx xxxxxx.n"+ "5. x xxxxxxxxx xxxxxx x xxxxxxx xxxxxxx x xxxxxxxxxxxx xxxx xxxxxxxxxxx xxxxxxxxxxxnxx xxxxxxx xxxxxxnx x nxnxxxxxxx xxxxxx. xxxx xxxxxxxxxx xxxxx xx xxxxxxxxxxxnxx xxxxxxxxxxxx xxxxxxxxxxx xxxxx xxxxxx xxxxxnxxxx, xxxxxxx xxxx xxxxxxx xxxxxxxxnxx xxxxxxxxxxxnxx xxxxxxx. x xxxxxxx x xxx xxxxxxxxxxxxx nxx xxxx xxxxx xx xxxxxxxxxxxx, xxx xxxxx xxxxxxxxxxxx xxxxxxxxnxx xxxxxxxxxxxxxx xxxxxxxxxxxnxx xxxxxxxxxx xnnx xxxxxxxxxxxnxx xxx x xnnxx xxxxxnxxxx.n"+ "6. xxxxx xxxxxxxxxxnxx nxnxxxxxxx xxxxx xxxxxxxxx xxxxxxxx xxx. 75 xxxxxx x xnxx 29 xxxxxnxx 1997 x. x xxxxx xxnxxxx. Nx xxxxx xxxxxxxx nxnxxxxxxx xxxxx xxxxx xxxxxxxxxxnxx xxnxxx 30 xnx.n"+ "7. xxxxxxxxxxxx xxxxx xx xxxxxxx xxxxxxxxx xxx xxxxxxx xxxxxxxxxx xxxxxxxxxxxxx x xxxnxxxxnxxx xxxxxxxxxxxx x xxxxxxxxxxnxx xxxxx xxxxxxx xxxxxx xxxxxxnxx xx xxxxxxxx xxxxxxxnxx nx xxxxx xxxxxxnx xxxxx xxxxxxxxxxxxx, xxxxx xxxxxnx xxxxx xxxxxxxxxxxx nx xxxxxnx xnxnx xxxxxxxxxxxx xxxxx xxxxxxxxxxxxx xxxxxxxxnx xxxx xxxx xxxxxxxnx. xx xxxx xxxxxxxnxx xxxxx xxx xxxx xxxxxxx xxxxxx xxxxxxxxxx xxxxnxxxxxxx xxxxxx nxx xxxxxxxnxx xxxxxxxxx xxxxxxnxx, xxxxxnxx xxx xxxxxnx xnxnx xxxxxxxxxxxx xxxxx xxxxxxxxxxxxx x xxxxxxxxxxxx.n"+ "? 15n"+ "1. xxxxxxxxxxxxx x xxxnxxxxnx xxxxxxxxxxxx xxxxxxxxxxx xxx nxxxxxxxxnxx xxxxxxxxxx xxxxxxxxxxxx x xxxxnxxx nxxxxxxx, xxxxxx x xxxxxxx xxxxx. x xxxxx nxxxxxxxnxxnxx xxxx xxxxxxxxx xxxxxxxxxxxxx xxxx x xxxxxxxxxxxxxx xxxxxxxxxx xxxx xx xxxxxxxx xxnxxxx xxxx xxxxxx.n"+ "2. xxxx xxxxxxnx nx xxxxx xxxxxxnx x xxxxxx xxx xxxxxnxx xxxxx xxxxxxxxxxxxx xxxxnxx x xxx. 1 xxxxxnx xxxxxx xx xxxxxxxnx xxx xxxxnxxxx xxxxxxxnxx xxxxx xxxxxxxxxxxx xxxxxxxxxxnxx xxxxx xxxxxx.n"+ "3. x xxxxxxx xxxxxxxxxxnxx xxxxx xxxxxxx xxxxxxxxxxxx xxxxxxxxx xxxxx xxxxx xxnxxxxx xxxnx xxxxxxxxxxxnxx xxxx xxxxxxnxx xxxxnxxxx xxxxxxxxxxxxx x xxxnxxxxnxxx xxxxxxxxxxxx xx xxxxxnxxxx xxxxxx xxx xxxxxxxxxxxx xxxxxxx xxxx x xxxxxxxxx.n"+ "? 16n"+ "1. xxxxxxxxxxxxx xxxx, xxx xxxxnxx xxxxxxxnx, xxxxxxxx xx nxnxxxxxxx xxxxx x xxxxxnxx 3 xnx xx xnxx xxxxxxxx xxxxx.n"+ "xxxxxn xx xxxxxxxxnxx xx xxxxx xxxx xxxxxxxnx, xxxxxx xxxxxxxxxxxxx xxxxx xxxx xxxxxxx xxxxx xxx xxxxxxnxx nx xxxxxxx xxxxx xxxxxxxxxx xxxxxxx xx xxxxxxxnxxnxxx xxxxxxxxxxxx xxxxxnx xxxxxxxxxnxx x xxxxxxxxnxx xx xxxxx, xxxxnxx xx xxxxxx xxxxxxxxnxx xxxxxxxxxxxxx x xnxx xxxxxxxnxx nxnxxxxxxx xxxxx.n"+ "2. x xxxxx xxxxxxxxxnxx xxxxxxx xxxxx xxxxxxx xxxxxnx xx xxxxxxxxnxx xx xxxxx xxxxxxxxnxx xxxxx xxx xxxxxxxnx, xxxxxx xxxxxxxxnxx xxxxxnxx xxxxxxnx xxxxxxxxxxxx xxxxnxx x xxxxxxxxxnxxx x xxxxxxxxnxx xx xxxxx.n"+ "3 .xxxxxxxxxxxxx xxxxxxxxx, xx x xxxxx xxxxxxxx nxnxxxxxxx xxxxx xxxxxxxx xxxx xxxxxxxxxnxx x xxxxxxxxnxx xx xxxxx.n"+ "? 17n"+ "xxxxxxxxxxxxx xxxxxxnxx xxxxxxxxxxxx xx xxxxxxxxxxnxx xxxxxxxxxxxxxxxxx x xxxxxxx xxxxxxxxxxnx xxxxxx xxxxxx x xxxxxxxxxxxxx xxxxxxxxxxx xxxxx xxxxxxx xxxx xnxxxxxxxx x xxxxnxxxnxxx xxxxxxxx xxx xxxxxxxxxxxx x xxxxxxx xxx xxx xxxxx x xxxnxxxxnxxx xnnxxx xxxxxxxnxxxxxxx xxxxxxnxxx x xxxxnxnxxx nxnxxxxxxx xxxxx, x xxxxxxxx xxxxx nx xxx xxxxnxnxx xxx nx xxxnxxnxx xxxxxxnxxx xxxxxxxxxxxx.n"+ "? 18n"+ "1. xxxxxxxxxxxx nxx xxnxxx xxxxxxxxxxxxnxxxx x xxxxxx nxx xxxxnxnxx xxx nxxnxxxxxxxxx xxxxnxnxx xxxxx xxxxxxxxx xxxxxxx, x x xxxxxxxxnxxxx x xxxxxx xxxxxxx, xx xxxx x xxxxxnxxx xxxxxxx xxxxxxx. xxxx xx xxxxxxxxxxxx nxx xxxxxxxxx nx xxxxx xxxxx xxxxxxnxxxx x xxxxxx xxxxxxxxxnxx x xxxxxnxx xx xxxxxxxx, x xxxxxx xxxxxxxxxxxxx xxxxxx xxxxx x nxxxxxx xxxxxx xxx xxxxxx.n"+ "2. xnxxxxxnxx xxxxxxxxxx x xxxxxx, x xxxxxx xxxx x xxx. 1 xxx xxxnxxx xxxxxx, xnxxxxxxnxx xxxx xxxxxxxxnxx xxxxxxx, nxx xxxxxxxxxx xxxxxxxxx xxxxxnxxxx xxxxxx nxxxxnxxxx xxxxx xxxxxxxxxxxx.n"+ "3. x xxxxxxxxx xxxxxnx xxxxxxx x xxxxxx xxxxxnxxx xxxxxxxxxxxxx xxxxxxxxxxx xxx xx xxxxnxxxxnxx xxxxxxxxxxxnxx, x xxxxxx xxxx x ? 9 xxx. 1 xxx. xx x xx nx nxxxx xxxxxxxxx.n"+ "? 19n"+ "xx xxxxxxx xxxxxxx xxxxxxxxxxxx xxxxxxxx xxxxxxnx xxxx xxxxxxxxxx xxxx xxxxxxx, x nxxxxxnxx xxxxnxxx xxxxxx nxxxxxxxnxxx xxx xxxxxxxxxxxx x xxxxxxx xxx xxxnxxxx xxxxxn xx xxxxnxnxx xxxxxxx.n"+ "? 20n"+ "x xxxxxxx x xxxxxxxxxx xxxxxx x xxxxxnxx xxnxxx xxxxxxxxx x xnxx 29 xxxxxnxx 1997 x. xxxxxxxxxxxxx xxxxxx xxxxx nx xxxxxxxxxxnxx xxxxxx xxnxxx xxxxxxxxx xxxxx xxxxxxxxxxxx x xxxxnxxxxxxxxx xxnxxx xxxxxxxxx xxxx xxxxxxxnxx xxx x nxnxxxxxxx xxxxx. xxxxxxxxxxxxx xxxxxxxxxxx xxxxx xxxxxx xx xxnxxx xxxxxxxxx xxxx xxxxxxxxnxx xxx. n"+ "? 21n"+ "xxxxxxxx xxxxnx xxxxx xxxxxxxx xxxxx xxx xxxxn x xxxxxx xxxxxnxx xxx xxxxxxx nxxxxxnxxxx x xxxxxxxxxnx xxxx xnxxxxxx, x xxxxxxxxx xxxxnx xxxxxxnxxxxnxx xxxxxxx, xxxxxxxnxxx x ? 6 xxx. 1 x xxxxxxxxx xxxxxxnxxxxnxx xxxxxxx xx xxxxnnxx xxxxx xxxxxnxxxxx xxx xx xxxxxxx nx xxxxxnxxnxx xxxxxxxnxxxx xxxxxxxnxxx x ? 6 xxx. 4, x xxxxx xxxxxxnxx x xxxx xxxxxxxnxxxxxxx xxxxnxxx xxxxxnxxxxxx xxxxxx xxxxxxx, x xxxxxx xxxx x ? 5 xxx. 1.n"+ "? 22n"+ "xxxxxxxxxxxxx xxxxxxxxx, xx xxxxxx xxxxx nx xxxxnxxxxxnxx xxxxx xxxxxxxxxxxx xxxxxxxxxnxxxx x nxnxxxxxxx xxxxx xxxxxxx nx xxxxx xxxxxxx. Nx nxxxxxx xxxxxxxxxnxxxx xxxxxxxxxx xxxxx xxxxxxxxxnxxxx xxxxxxxxxxxx x xxxxxx 49x100 xxxxxxx xxxx xxxxxxxx xxxxx xxxxxxxxxxxxx xx x nxnxxxxxxx xxxxx. n"+ "? 23n"+ "xxxxx xxxxxxxxx xx xxxxxxxxxxnxx xxxnxxxxnxxx xxxxxx, x xxxxx x xxxxxxxxxnxx x nxxxnxx xxxxxxxx xxxxnxxnxxxx xxxx xxx xxxxxxxx xxx xxxxxxxx xxxxxxxxxxxx.n"+ "? 24n"+ "x xxxxxxxx nxxxxxxxxxxxnxxx nxnxxxxxx xxxxx xxxx xxxxxxxxxnxx xxxxxxxx xxxxxx x xnxx 29 xxxxxnxx 1997 x. xxxxx xxnxxxx x xxxxxxx xxxxxnxxx xxxx xnnx xxxxxxxxnxx xxxxxxxxxxxx xxxxxxxx xxxxx. x xxxxxxxxx xxxxxnxxnxx xxxxxxxnxxxx xxxxxnxxxxx nxnxxxxxxx xxxxx x xxxxxnxxxxnxxxx xxxxxxxxxnxx xxxxxxxxxxxxxx xxxxxxxxx xxxxx, xxxxxxxx xx xxxxxxxx, xxxxxxnxxxx xxx xxxxxxxxx xxxxxxx xxxxxnxxxxnxx nxnxxxxxxx xxxxx, xxxx xxxx xxxxxxxxx xxxxxnxxxxnxx xxxxx xxxxxxxxx x xxxx.n"+ "? 25n"+ "xxxxx nxnxxxxxx xxxxxxxxxnx xxxxxxx x xxxxx xxxnxxxxxxxxxxx xxxxxxxxxxxxx xx xxxnxx xxx xxxxxx xx xxxxn.n" </textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" x="0" y="55" width="555" height="0"> </reportElement> <textElement textAlignment="Left"> </textElement> <textFieldExpression class="java.lang.String"> "KONIEC KONIEC KONIEC KONIEC KONIECnnnnnnnnnnnnnn" </textFieldExpression> </textField> </band> </detail> </jasperReport> By: Teodor Danciu - teodord RE: Problem with page break on pages>1 2003-03-13 12:47 Hi, The bottom page space comes from the y="53". When a page break occurs, the engine prints on the next page only the elements that did not fit on the previous (those that still have some content to display). It does not place your text element at the original y offset (53 pixels lower), but rather starts with it right away, at the beginning of the band overflow. I think this is OK. The problem is that those 53 pixels are "cut" from the overall band height and result in a 53 pixels high space at the bottom. I'm not saying this is perfect for everybody, but most of the time, bands are not so large and with the next band starting on the same page, it does not result in white space regions. You can solve your problem by placing the static text at y="0". To make it for the original offset in the first page, you can use other report bands. Even dummy report band itroduced by dummy groups. There are some explanations in the tips and tricks area. I hope this helps. Teodor By: Jakub Posiada?a - qtaster RE: Problem with page break on pages>1 2003-03-13 13:26 Hi Teodor Thank You for explanation. But my report is a little bit more complicated, static text is preceded by variable length text so I can't simply place static text at y=0, but now when I know why it happens I can make report more like I want it to be. Thanks again. Kuba

By: Kees Kuip - keeskuip Alignment of column with string and number. 2003-03-12 04:09 Hello, I have a column with values that could be a String or could be a Number. I would like the alignment to be left-adjusted if it is a String and right-adjusted if it is a Number. Is this possible ? Kees. By: Kees Kuip - keeskuip RE: Alignment of column with string and numbe 2003-03-12 04:43 It would be nice to have the following : An object JRFieldValue which could be returned from the method getFieldValue() (from interface JRDataSource). This object holds the value but also properties like alignment, foregroundcolor, backgroundcolor etc. Kees. By: Teodor Danciu - teodord RE: Alignment of column with string and number. 2003-03-13 13:06 Hi, The only solution (at least for the moment) is to switch between two different text fields using their <printWhenExpression> like explained here: http://jasperreports.sourceforge.net/tips.tricks.html#formatting I hope this helps. Teodor

By: Chonsiu - chonsiu Make CrossTab Report 2003-03-12 22:24 Hi ~ I'm a newcomer of reporting tools......now trying to use JasperReport but have no idea how can I make crosstab report with it......Does anybody can help me ? Thx..... By: Teodor Danciu - teodord RE: Make CrossTab Report 2003-03-13 12:58 Hi, The bad news is that JasperReports does not support crosstab reports yet. I hope it will do it soon. Thank you, Teodor

By: manoj sadangi - forgemanoj can input data will text file or xml 2003-03-13 08:15 I am evaluating jasper for my project. we have some batch jobs which will run and produce the data in a xml format. so my question is wether I can populate the data from xml file to jasper directly(I dont need jdbc access) By: Teodor Danciu - teodord RE: can input data will text file or xml 2003-03-13 12:51 Hi, You need to create a custom JRDataSource to parse your XML data, so that JasperReports could make sens of it when filling the report. Check the "datasource" sample to see how to create custom data sources. I hope this helps. Teodor

By: Murali S - shivamurali jasper.compile.classpath !! help !! 2003-03-10 22:15 Hi am using jasper in the web layer. My requirement is i dont want to specify the compile class path. Does jasper allows this ?? Thanks shivamurali

By: manoj sadangi - forgemanoj can input data will text file or xml 2003-03-13 08:14 I am evaluating jasper for my project. we have some batch jobs which will run and produce the data in a xml format. so my question is wether I can populate the data from xml file to jasper directly(I dont need jdbc access)