2002 JI Open Discussion

By: chris gamble - cgamble Barcode Font shows in PDF, but not JRViewer 2003-02-17 09:51 I have managed to print a barcode on my report by putting the barcode font in the same directory as the jasper file and setting the field correctly. This works perfectly for the PDF exports, but my report needs to print directly from Jasper (either by printing or sending a JRViewer derived class.) Anyone have suggestions on what I may be missing? Attached is the pertinent piece of my xml design. There is not report font defined, but I have tried it as well with similar to worse results (at times the font would not show in the pdf either). <font fontName="./code39.ttf" pdfFontName="./code39.ttf" size="16" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Cp1252" isStrikeThrough="false" /> Thanks, By: Teodor Danciu - teodord RE: Barcode Font shows in PDF, but not JRViewer 2003-02-17 12:35 Hi, The "fontName" attribute should be a physical or a logical font name. So, it is not about specifying a path on disk. The font has to be installed on your system and you specify only its name. On Windows for example, installing a font is equivalent to copying the TTF file into the WindowsFonts directory. Check the Java documentation for details about how to work with fonts. I hope this helps. Teodor By: chris gamble - cgamble RE: Barcode Font shows in PDF, but not JRView 2003-02-17 14:57 I have installed the Barcode int /winnt/fonts and changed the report design to only include: <font fontName="code39.ttf"> Now, the barcode displays in iReports, in the PDF, but not when printed directly or showing through JRViewer. Any other ideas where I may be going wrong. (I did follow up the path of Java Fonts -- leading me to also copy it to jre/lib/fonts -- but it did not help either.) Any thoughts? By: acajax - liufenghuixue RE: Barcode Font shows in PDF, but not JRViewer 2003-05-15 03:01 But ,on unix? By: chris gamble - cgamble *sigh* 2003-02-17 15:00 I seem to be without my brain. I went into winnt/fonts, and looked for the file. The installed name of my font was "Code 39" not code39.ttf etc. Im now fixed, and thanks for the information (and the reporting engine too .. its great!) By: Ruben Misrahi - rnmisrahi RE: *sigh* 2003-12-16 09:47 Funny. I had the same problem, but "installing" the font in Widnows/Fonts didn't help. The only thing that solved my problem was including the Fonts directory in the Required Library paths in my application.

By: Mark Simmons - bdmarr Upgrade to itext 1.01 jar causes error 2003-12-02 13:39 I just upgrade the itext jar from .96 to 1.01 and now get this error: ExceptionConverter: java.io.IOException: The document has no pages. Anybody seen this? By: Mark Simmons - bdmarr RE: Upgrade to itext 1.01 jar causes error 2003-12-02 13:42 Here is the detailed error: ------ ExceptionConverter: java.io.IOException: The document has no pages. at com.lowagie.text.pdf.PdfPages.writePageTree(Unknown Source) at com.lowagie.text.pdf.PdfWriter.close(Unknown Source) at com.lowagie.text.pdf.PdfDocument.close(Unknown Source) at com.lowagie.text.Document.close(Unknown Source) at dori.jasper.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:345) at dori.jasper.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:262) at dori.jasper.engine.JasperExportManager.exportReportToPdf(JasperExportManager.java:187) at dori.jasper.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:201) at org.apache.jsp.SRIreportgenerator_jsp._jspService(SRIreportgenerator_jsp.java:1687) 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:210) 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:256) 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:171) at org.apache.catalina.core..... By: Gregory A. Swarthout - gswarthout RE: Upgrade to itext 1.01 jar causes error 2003-12-02 16:06 You cannot upgrade iText from v0.96 and still have it work with JasperReports. This has been mentioned many times. By: Teodor Danciu - teodord RE: Upgrade to itext 1.01 jar causes error 2003-12-03 03:12 Hi, I'll fix this in the next version, to be released soon. Thank you, Teodor By: Mark Simmons - bdmarr RE: Upgrade to itext 1.01 jar causes error 2003-12-16 06:21 Teodor - thank you for your attention to this. The fdf merge capability of the itext 1.01 version is needed in my application so I would rather not revert back to itext .96 version... Thanks for your attention to this. By: Teodor Danciu - teodord RE: Upgrade to itext 1.01 jar causes error 2003-12-16 06:46 Hi, The 0.5.1 release is not yet official, but on the CVS repository at sourceforge, the fix is already in place. Thank you, Teodor

By: Dariusz Filipski - darekf Saving java file Compiling problem 2003-12-12 11:41 Hello! During XML compilation under tomcat web application we've got such exception: dori.jasper.engine.JRException: Error saving expressions class file : /chroot/tomcat/KontrolaCL.java Is it nessesery that jasper writes files during compilation? How to set directory where this files shoud be placed? Best regads Darek Filipski By: Teodor Danciu - teodord RE: Saving java file Compiling problem 2003-12-12 12:09 Hi, You can set the "jasper.reports.compile.temp" system property as explained here: http://jasperreports.sourceforge.net/quick.how.to.html#compile But if you are in Web environment, then it would be better to use a report compiler that does not create files on-the-fly, such as the JRBshCompiler. This compiler class can be used directly to transform a JasperDEsign object into a JasperReport object or you can set the "jasper.reports.compiler.class" and continue to use the JasperCompileManager. I hope this helps. Teodor By: Dariusz Filipski - darekf RE: Saving java file Compiling problem 2003-12-16 03:32 Hello, It works great. Thank you for your help! Best regards Darek Filipski

By: Dariusz Filipski - darekf Full XML definition in logs when using Log4J 2003-12-12 07:35 Hello! We're using JasperReports in www application which uses Log4J for logging. When we set log level to "DEBUG" compilation of XML report definition puts a lot of logs into our logfile. Those logs contains information about compilation each line of XML. How can we turn off logging by jasper? Best regards Darek Filipski By: Teodor Danciu - teodord RE: Full XML definition in logs when using Lo 2003-12-12 07:41 Hi, It is not JasperReports who outputs those logs. It is probably the Jakarta Digester component or the XML parser. You have to use the log4j.properties file to filter out the messages you don't want to see. I hope this helps. Teodor By: Dariusz Filipski - darekf RE: Full XML definition in logs when using Log4J 2003-12-12 08:35 Hello! Thank you for your answer. Can you get me a little example how to do this? Best regards Darek Filipski By: Dariusz Filipski - darekf RE: Full XML definition in logs when using Log4J 2003-12-16 03:31 Ok, I've done it :) It should ble something like that: <logger name="org.apache.commons.beanutils"> <level value="OFF"/> </logger> <logger name="org.apache.commons.digester.Digester.sax"> <level value="OFF"/> </logger> <logger name="org.apache.commons.digester.Digester"> <level value="OFF"/> </logger> Thank you for your help! Best regards Darek Filipski

By: Albert Chan - albertchan how to create subreport using Java API? 2003-12-15 12:03 Hi, I tried to include a report that just has static text. I want to include this in a main report. Here is my code snippet: -------------------------------------------------- JasperDesign jDesign = new JasperDesign(); // setup jDesign.setOrientation(JRReport.ORIENTATION_LANDSCAPE); .... // add parameter JRDesignParameter jParamSubreport = new JRDesignParameter(); jParamSubreport.setName("subreport"); jParamSubreport.setValueClass( new JasperReport(jDesign, null).getClass() ); jDesign.addParameter(jParamSubreport); // Detail band JRDesignBand jDetailBand = new JRDesignBand(); // add a Subreport JRDesignSubreport jSubreport = new JRDesignSubreport(); jSubreport.setUsingCache(true); jSubreport.setRemoveLineWhenBlank(true); // set Subreport connection JRDesignExpression jSubreportConnExp = new JRDesignExpression(); jSubreportConnExp.addParameterChunk( JRParameter.REPORT_CONNECTION ); jSubreportConnExp.setValueClass(java.sql.Connection.class); jSubreport.setConnectionExpression(jSubreportConnExp); // set Subreport expression JRDesignExpression jSubreportExp = new JRDesignExpression(); jSubreportExp.addParameterChunk( "subreport" ); jSubreportExp.setValueClass( new JasperReport(jDesign, null).getClass() ); jSubreport.setExpression(jSubreportExp); jDetailBand.addElement(jSubreport); jDesign.setDetail(jDetailBand); .... -------------------------------------------------- When running my Java app, I got this error: -------------------------------------------------- Dec 15, 2003 11:37:46 AM org.apache.commons.digester.Digester fatalError SEVERE: Parse Fatal Error at line 1 column -1: Character conversion error: "Unconvertible UTF-8 character beginning with 0xac" (line number may be too low). org.xml.sax.SAXParseException: Character conversion error: "Unconvertible UTF-8 character beginning with 0xac" (line number may be too low). -------------------------------------------------- Any suggestions? Thanks, al

By: Tuan Le - lesoft A weird XLS bug (7E0345 --> 1.7977E+308) 2003-12-15 10:49 In our Excel report we have one String field that displays our company job code, and the Excel report returns all the job code correctly with the exception of any job code starting with 1Exxxx. For example, in database, job code is 7E0345 in Excel output, job code is 1.7977E+308 It seems that whenever we have a job cod starting with 1E, JasperReport/Excel converts it into an expontial value. How do we prevent that to happens? The job code is a field of type String. Thanks, Tuan

By: Felipe Goikoetxea - kfelipe null of 2 paging problem 2003-12-11 08:37 Hi folks, I am using JR 0.5.0 and groups with subreports. When the group gets started in the second page, the footer paging text says "null of 2". After that one everything seems ok. ie: "2 of 2". I also have a problem with one of the subreports which its band is length="300" and I haven?t been able to split it between 2 pages. It always shows the whole detail section of the subreport in a fresh new page, even if I set the isSplitAllowed attribute to true. Any help would be really appreciated. Thanks in advance, Felipe By: Teodor Danciu - teodord RE: null of 2 paging problem 2003-12-13 11:00 Hi, I think this happens only when the first detail band does not fit on the first page and forces a page break. (If it occurs inside a subreport, it is about the first page of the subreport) Can you confirm me that this "Page null of N" problem appears only when the first detail band does not fit on the first page? Thank you, Teodor By: Felipe Goikoetxea - kfelipe RE: null of 2 paging problem 2003-12-15 00:41 Hi Teodor, As far as I know you are right (I?ve made some testing to solve this issue). I haven?t seen it in a second, third ... page and neither when the subreport detail was the one which produced the overflow. Best regards, kfelipe. By: Teodor Danciu - teodord RE: null of 2 paging problem 2003-12-15 01:15 Hi, A fix for this is available in the CVS repository at sourceforge. Thank you, Teodor

By: jayalakshmi - jayashaki Bottom Line of the table-Automatic generation 2003-12-14 22:21 Hello everybody, I am generating the reports in Tabular format in all the three html,excel,pdf formats using Jasper. For crating table i have used the Graphic elelment called LINE instead of RECTANGLE. I want the bottom line of the table to be automatically generated when last record of each page has been populated, kindly help me to get the solution, Thanx.

By: jayalakshmi - jayashaki Column Header Problem 2003-12-14 20:31 Hi all, I am generating reports (in Tabular format)in pdf,excel,html formats.The problem i found was, while the record goes on increasing, the contents moves to the second page, in pdf i got the table but without column header, in excel,html the column header is coming but the top line of the table is missing, I don't know how to rectify this,Is this a problem in Allignment? Kindly help me to get a solution. Thanx.

By: jayalakshmi - jayashaki Horizontal lines are not visible 2003-12-10 01:48 While drawing a table in XML for creating reports with vertical and horizontal coulmns,in excel, html the horizontal line between two vertical lines are not coming.The outer box of the table is coming, but if there is any horizontal lines between the vertical lines inside the box it is not coming.Instead of doing with lines, i have tried out with rectangle also, but when the vertical line touches the lower bottom of the rectangle it is not visible.Kindly help me regarding this . By: Teodor Danciu - teodord RE: Horizontal lines are not visible 2003-12-10 08:09 Hi, Make sure your lines do not cross or overlap each other. The so-called grid exporter like the HTML and the XLS exporter do not know how to handle ovelapping elements. This is because we cannot put two different elements in the same grid cell. Thank you, Teodor By: Mark Denchy - mdenchy RE: Horizontal lines are not visible 2003-12-13 12:53 I can definitely confirm that this would correct the problem. I had experienced the exact same issue dumping to screen and PDF. I seems that staying away from Rectangles with grid-work and using Lines, is a happier solution. teodord - <b>You Rock!</b>

By: pandu - pandu16 The page number is null on the first page 2003-10-13 14:27 I am working on subreports, i have created 4 groups and placed the subreports in those groups. I used the page footer to include textfeild with the "Page " + String.valueOf( $V{PAGE_NUMBER} ) + " of " evaluation time is "now". The page number is null on the first page, but in the subsequent pages it prints the page number. Can anyone suggest why on the first page the page number is null? Appericate you help. Thanks Pandu By: Teodor Danciu - teodord RE: The page number is null on the first page 2003-12-13 10:52 Hi, I think this happens only when the first detail band does not fit on the first page and forces a page break. (If it occurs inside a subreport, it is about the first page of the subreport) Can you confirm me that this "Page null of N" problem appears only when the first detail band does not fit on the first page? Thank you, Teodor

By: Steven Blough - stevenblough Possible problem with page numbering 2002-12-06 06:42 I think I may have encountered a problem with page numbering. When the group footer breaks to a new page the page number does not increase but the following page is the correct number again. Example: 1/16, 2/16, 3/16, 3/16, 5/16, 6/16,? The page numbering is correct except for when only the group footer is spanned to a new page. Thanks Steven Blough By: Steven Blough - stevenblough RE: Possible problem with page numbering 2002-12-09 10:15 I am using version 0.4.4 Thanks Steven Blough By: Steven Blough - stevenblough RE: Possible problem with page numbering 2002-12-09 10:13 Teodor I replicated this problem in the data source example by changing the city group to isStartNewPage=true and by adding additional data in the customdatasource.java. I also emailed the code to you. The problem occurs on page 4 of the pdf. Thanks Steven Blough By: Teodor Danciu - teodord RE: Possible problem with page numbering 2003-01-30 00:47 Hi, The 0.4.5 version should solve this problem. Thank you, Teodor By: Teodor Danciu - teodord RE: Possible problem with page numbering 2002-12-07 01:19 Hi, Do you display the page number on the page footer? What version of JasperReports are you using? Could you supply me with an example? teodord@hotmail.com Thank you, Teodor By: pandu - pandu16 page number is null on the first page, 2003-10-13 14:25 I am working on subreports, i have created 4 groups and placed the subreports in those groups. I used the page footer to include textfeild with the "Page " + String.valueOf( $V{PAGE_NUMBER} ) + " of " evaluation time is "now". The page number is null on the first page, but in the subsequent pages it prints the page number. Can anyone suggest why on the first page the page number is null? Appericate you help. Thanks Pandu By: Teodor Danciu - teodord RE: page number is null on the first page, 2003-12-13 10:51 Hi, I think this happens only when the first detail band does not fit on the first page and forces a page break. (If it occurs inside a subreport, it is about the first page of the subreport) Can you confirm me that this "Page null of N" problem appears only when the first detail band does not fit on the first page? Thank you, Teodor

By: PK - koldaman Groups with subreports 2003-06-16 05:44 Hi Theodor, I beg you for an advice. I am composing a report made of 10 groups. Each group contains a subreport. Each subreport can have various height (because of isPrintWhenDetailOverflows="true"). How can I fix each of subreport (group) to be visible whole - it can not be divided into 2 pages. I tryed all known tricks with isStartNewPage="true" and minHeightToStartNewPage="" (I can not use it, because I have no clue about the height of subreport). Thank you for any advice. By: Teodor Danciu - teodord RE: Groups with subreports 2003-06-16 08:09 Hi, Try this: https://sourceforge.net/forum/message.php?msg_id=2061465 Thank you, Teodor By: PK - koldaman RE: Groups with subreports 2003-06-16 09:39 Hi Teodor, thank you for your quick answer. I went through all forum (also the chain you mentioned above) but thats the think I can not use. Each my subreport can have height either 100 or 300 or whatever. I can not specify the minHeightToStartNewPage, because I simply do not know how it will look like. Is there any other trick to solve my "problem"? I am realy getting sick of this - however JasperReports are great. By: Teodor Danciu - teodord RE: Groups with subreports 2003-06-16 09:51 Hi, It does not matter if you don't know the height of the subreport. It is not about that. In that message I have already indicated a fixed height that is base on the page size, not the subreport size. I hope this helps. Teodor By: PK - koldaman RE: Groups with subreports 2003-06-17 00:27 Hi, unfortunately it metters to me that I do not know the height :) because my point is to fit as many groups on page as possible and if it does not fit, put it in to another. When I specify group with minHeightToStartNewPage="600" for example, report spreads to 4 pages instead of 2 and every group is on the page alone filling quarter of the page height. This is what I am struggling with for 3 days and can not find the answer... :( PS: I also noticed strange behaviour of page counting. When report says "put this group on other page" the page with evaluationTime="Now" returns "null" instead of "1". So I get "Page null of 2". But this does not matter to me, I need to solve the problem above mainly :) Thanks for you patience By: Teodor Danciu - teodord RE: Groups with subreports 2003-07-07 12:49 Hi, You could put your group into a subreport and then use the new "isSplitAllowed" flag for the band that contains your subreport in the master report to prevent it from splitting when it does not fit entirely on the current page. Try the new 0.5.0 version. Thank you, Teodor By: Teodor Danciu - teodord RE: Groups with subreports 2003-12-13 10:44 Hi, I think this happens only when the first detail band does not fit on the first page and forces a page break. (If it occurs inside a subreport, it is about the first page of the subreport) Can you confirm me that this "Page null of N" problem appears only when the first detail band does not fit on the first page? Thank you, Teodor

By: Chuck Deal - cdeal Page Number Problem 2003-04-11 10:02 I feel like I have seen the answer to this problem before, but I can't find it. In my case I have a report that generates 2 pages. On the first page, it displays "Page: null of 2", but on the second it displays "Page: 2 of 2". What am I missing? I do not have a detail section, but I do have multiple groups. (The report represents one record and it is easier to work with the fields when they are in groups) Here is the XML for the PageFooter section. Code: Page: $V{PAGE_NUMBER} of $V{PAGE_NUMBER} [/code] What am I missing? By: Heinz Haeussler - ecd-haeussler-h RE: Page Number Problem 2003-04-15 23:46 I have the same problem in the pagefooter with 0.4.6. It appears only if a groups starts a new page because of his minHeightToStartNewPage-Attribute. Heinz By: Teodor Danciu - teodord RE: Page Number Problem 2003-04-11 13:52 Hi, What version of JasperReports are you using? Thank you, Teodor By: William Wong - takara5 RE: Page Number Problem 2003-08-06 08:06 I am having the same page numbering problem and am using multiple groups as well. The PAGE_NUMBER = null problem only occurs when a group starts a new page. I am also using JasperReports 0.5. Does anyone know of a quick-fix to this problem? By: Chuck Deal - cdeal RE: Page Number Problem 2003-04-14 06:43 Sorry, forgot to mention that. JasperReports 0.4.5 I does this behavior both in the JasperViewer and in the exported PDF. By: Teodor Danciu - teodord RE: Page Number Problem 2003-12-13 10:41 Hi, I think this happens only when the first detail band does not fit on the first page and forces a page break. (If it occurs inside a subreport, it is about the first page of the subreport) Can you confirm me that this "Page null of N" problem appears only when the first detail band does not fit on the first page? Thank you, Teodor By: Sohan Kasula - skasula RE: Page Number Problem 2003-09-25 12:58 Does anyone know how to fix this "page null of X" problem ? Thanks in advance. Post edited by: tcloonan, at: 2006/08/18 21:41

By: Peter Kohlendorfer - kohlendorfer Miscalculation of page number 2003-05-26 06:20 When placing multiple groups with dynamic visibility (printWhen expression) on one page it can happen that the layout exceeds one page. In that case JR does not calculate the page number for the first page resulting in "Page null of 2" on the first page of a report. Does anybody know how to avoid this? Thanks, Peter By: Sohan Kasula - skasula RE: Miscalculation of page number 2003-09-25 13:04 Does anyone have a solution to this problem? thanks. By: Teodor Danciu - teodord RE: Miscalculation of page number 2003-12-13 10:40 Hi, I think this happens only when the first detail band does not fit on the first page and forces a page break. (If it occurs inside a subreport, it is about the first page of the subreport) Can you confirm me that this "Page null of N" problem appears only when the first detail band does not fit on the first page? Thank you, Teodor

By: Joanne Corless - jocorless Failure to compile as a java class in Struts 2003-12-10 09:58 Hi, I've read all the samples and documentation and think I must be a bit thick but I am having trouble getting my ReportManager class to compile reports. The error I am getting is : 2003-12-10 12:33:20,928 DEBUG [org.apache.tomcat.util.threads.ThreadPool] Getting new thread data 2003-12-10 12:33:36,661 ERROR [sTDERR] D:jboss-3.2.2RC4inaudit_trail.java:4: package dori.jasper.engine does not exist 2003-12-10 12:33:36,801 ERROR [sTDERR] import dori.jasper.engine.*; 2003-12-10 12:33:36,801 ERROR [sTDERR] ^ 2003-12-10 12:33:36,811 ERROR [sTDERR] D:jboss-3.2.2RC4inaudit_trail.java:5: package dori.jasper.engine.fill does not exist 2003-12-10 12:33:36,811 ERROR [sTDERR] import dori.jasper.engine.fill.*; 2003-12-10 12:33:36,811 ERROR [sTDERR] ^ 2003-12-10 12:33:36,881 ERROR [sTDERR] D:jboss-3.2.2RC4inaudit_trail.java:17: cannot resolve symbol 2003-12-10 12:33:36,881 ERROR [sTDERR] symbol : class JRCalculator 2003-12-10 12:33:36,881 ERROR [sTDERR] location: class audit_trail 2003-12-10 12:33:36,881 ERROR [sTDERR] public class audit_trail extends JRCalculator 2003-12-10 12:33:36,881 ERROR [sTDERR] ^ 2003-12-10 12:33:36,881 ERROR [sTDERR] D:jboss-3.2.2RC4inaudit_trail.java:24: cannot resolve symbol 2003-12-10 12:33:36,881 ERROR [sTDERR] symbol : class JRFillParameter 2003-12-10 12:33:36,881 ERROR [sTDERR] location: class audit_trail 2003-12-10 12:33:36,881 ERROR [sTDERR] private JRFillParameter parameter_REPORT_CONNECTION = null; 2003-12-10 12:33:36,881 ERROR [sTDERR] ^ 2003-12-10 12:33:36,891 ERROR [sTDERR] D:jboss-3.2.2RC4inaudit_trail.java:25: cannot resolve symbol 2003-12-10 12:33:36,891 ERROR [sTDERR] symbol : class JRFillParameter 2003-12-10 12:33:36,921 ERROR [sTDERR] location: class audit_trail 2003-12-10 12:33:36,921 ERROR [sTDERR] private JRFillParameter parameter_REPORT_PARAMETERS_MAP = null; 2003-12-10 12:33:36,921 ERROR [sTDERR] ^ 2003-12-10 12:33:36,921 ERROR [sTDERR] D:jboss-3.2.2RC4inaudit_trail.java:26: cannot resolve symbol 2003-12-10 12:33:36,921 ERROR [sTDERR] symbol : class JRFillParameter 2003-12-10 12:33:36,921 ERROR [sTDERR] location: class audit_trail 2003-12-10 12:33:36,921 ERROR [sTDERR] private JRFillParameter parameter_REPORT_DATA_SOURCE = null; 2003-12-10 12:33:36,921 ERROR [sTDERR] ^ I simply just don't understand why I should get this problem as the jasper jar is in the WEB-INFlib directory of the webapp as well as being in the lib directory of the server in JBOSS. The code I am using is : String pathToFile = getFilePath(reportName); System.setProperty("jasper.reports.compile.temp", ApplicationProperties.getProperty("compiledReportDir")); JasperCompileManager.compileReportToFile(pathToFile); The path to the file is on my local drive as this is similar to how the report xml files are loaded within the production system. The idea is to allow users to be able to upload, compile and publish reports to other users based on user privileges. This will be run from within a workflow application built on struts. Therefore I need a java class that can have a struts action wrapper. Any clues as to my problem will be much appreciated Regards Jo Corless By: Honghai Zhang - haroldzhang RE: Failure to compile as a java class in Struts 2003-12-10 10:26 I have the same problem when I try to compile reports in a struts app deployed on Weblogic Server v6.1 By: Tom - tomage RE: Failure to compile as a java class in Struts 2003-12-10 15:29 Hi, Be sure to also set the classpath for the compilation: System.setProperty("jasper.reports.compile.class.path", reportClasspath); Tom By: Joanne Corless - jocorless RE: Failure to compile as a java class in Struts 2003-12-11 03:08 I've tried adding the classpath using an absolute reference but this doesn't seem to make any difference. Does it have anything to do with application context? I've noticed that both the relevant examples I've looked at (the Servlet and the JSP) both run the compile from within an application context whereas I will be compiling reports located in an external (to the Server) directory. Regards Jo Corless By: Tom - tomage RE: Failure to compile as a java class in Struts 2003-12-11 08:25 Hi Jo, I have been using an absolute reference. Here is the entry from my properties file: jasper.reports.compile.class.path=Q:SIMPLETRADE2libjasperreports-0.5.0.jar Tom By: Joanne Corless - jocorless RE: Failure to compile as a java class in Struts 2003-12-12 08:13 Thanks Guys for all your help, typically it was a stupid mistake that was causing my problem, I wasn't referencing the jar file correctly, I was only pointing to its directory rather than the file itself Jo Corless

By: jayalakshmi - jayashaki Field,Page Wrapping,Title of the page 2003-12-12 02:31 While creating reports with the use of XML, 1)I want the column header should continue in the second page also, i have written the code,in Excel,html i am getting the column header but in pdf it is not coming,is it may due to some allignment problem? 2)If the number of records grows in the database then automatically the table should grown to accept the change, what should i do for this? 3)To draw the table i have used the graphic element "LINES" so the table closes by a line which i have given the position(y-Coordinate), but i want the bottom line of the table should be automatically generated after when the last record is populated in each page.

By: Ryan Fruit - rfruit data from the next data row while rendering 2003-12-11 17:05 I have a report that I need data from the next row to complete the current row. Here's what I mean: row 1 - X , (X-Y) row 2 - Y , (Y-Z) row 3 - Z , ... As you can see I need the data from the next row in the result set to render the current row of the report. In Java I could do a next() on the ResultSet, get the data, then call previous() to reset it. Is there a way to get at data in future rows in Jasper reports? Any help would be greatly appreciated. By: Carlos Costa e Silva - carloscs RE: data from the next data row while rendering 2003-12-11 18:08 Implement your own JRDataSource or JRRewindableDataSource. You can then create in the datasource an artificial column row_3 that returns the calculated result.

By: Tom - tomage Format and data type in exporters 2003-12-11 14:58 I am finding the need to know the data type and format when I am coding exporters. For instance when making a cell in Excel I might want to apply various formats. This information is available for text expressions when filling a report, but not when exporting. Is there any plan for this? Am I missing something that might enable me to do this already? Thanks for any insight. Tom

By: Albert Chan - albertchan Error creating Subreport using Java API 2003-12-11 14:17 Hi, I have trouble creating a report with a subreport that only contains a static text. Here is my code snippet: -------------------------------------------------- // create design JasperDesign jDesign = new JasperDesign(); // create subreport JRDesignSubreport jSubreport = new JRDesignSubreport(); jSubreport.setUsingCache(true); jSubreport.setRemoveLineWhenBlank(true); // create Detail band JRDesignBand jDetailBand = new JRDesignBand(); jDetailBand.setHeight(50); // set subreport connection JRDesignExpression jSubreportConnExp = new JRDesignExpression(); jSubreportConnExp.addParameterChunk( JRParameter.REPORT_CONNECTION ); jSubreportConnExp.setValueClass(java.sql.Connection.class); jSubreport.setConnectionExpression(jSubreportConnExp); // set Subreport expression JRDesignExpression jSubreportExp = new JRDesignExpression(); jSubreportExp.setValueClass( java.io.InputStream.class ); //testsub only contains a static text jSubreportExp.setText( "testsub.jasper" ); jSubreport.setExpression(jSubreportExp); jDetailBand.addElement(jSubreport); jDesign.setDetail(jDetailBand); -------------------------------------------------- When I tried to compile the Jasper design, I got this error: -------------------------------------------------- /db/dbdev/jwsdp-1_0_01/bin/DetailQMEPostETLReport.java:217: cannot resolve symbol symbol : variable testsub location: class DetailQMEPostETLReport value = (java.io.InputStream)(testsub.jasper); ^ /db/dbdev/jwsdp-1_0_01/bin/DetailQMEPostETLReport.java:355: cannot resolve symbol symbol : variable testsub location: class DetailQMEPostETLReport value = (java.io.InputStream)(testsub.jasper); ^ /db/dbdev/jwsdp-1_0_01/bin/DetailQMEPostETLReport.java:493: cannot resolve symbol symbol : variable testsub location: class DetailQMEPostETLReport value = (java.io.InputStream)(testsub.jasper); ^ 3 errors QMEReport_getReportDesign(WA053, DetailQMEPostETLReport): dori.jasper.engine.JRException: Errors were encountered when compiling report expressions class file: See error messages above. java.rmi.RemoteException: JRException: dori.jasper.engine.JRException: Errors were encountered when compiling report expressions class file: See error messages above. -------------------------------------------------- Even if I set the Subreport expression to: jSubreportExp.setValueClass( String.class ) I still get the same kind of error.... Any suggestions? Eventually, I would need to connect the subreport to a datasource, which I have no idea how to do. Can you give me any directions on where to find good docs or samples? Thanks in advance, al

By: Enrico Goosen - enricogoosen Label design problem 2003-09-12 05:59 I've created a Jasper Design to print address labels. My design caters for 16 labels per page (2 columns). My problem is that when I run the application and view my labels in JasperViewer, I only get 15 labels on the page. One gets carried over to the next page, even though there is space for one more label on that page. Here's my code: public JasperDesign getJasperDesign() throws JRException{ //JasperDesign JasperDesign jasperDesign = new JasperDesign(); jasperDesign.setName("AddressLabelDesign"); jasperDesign.setPageWidth(595); jasperDesign.setPageHeight(864); jasperDesign.setColumnCount(2); jasperDesign.setPrintOrder(JasperDesign.PRINT_ORDER_HORIZONTAL); jasperDesign.setColumnWidth(265); jasperDesign.setColumnSpacing(0); jasperDesign.setLeftMargin(40); jasperDesign.setRightMargin(25); jasperDesign.setTopMargin(0); jasperDesign.setBottomMargin(0); //Fonts JRDesignReportFont normalFont = new JRDesignReportFont(); normalFont.setName("Normal_Font"); normalFont.setDefault(true); normalFont.setSize(13); jasperDesign.addFont(normalFont); //Fields JRDesignField field = new JRDesignField(); field = new JRDesignField(); field.setName("firstnames"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("surname"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("address1"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("address2"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("city"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); field = new JRDesignField(); field.setName("postcode"); field.setValueClass(java.lang.String.class); jasperDesign.addField(field); //Detail JRDesignBand band = new JRDesignBand(); band.setHeight(108); JRDesignTextField textField = new JRDesignTextField(); textField.setX(10); textField.setY(10); textField.setWidth(265); textField.setHeight(17); textField.setFont(normalFont); JRDesignExpression expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{firstnames} + " " + $F{surname}"); textField.setExpression(expression); band.addElement(textField); textField = new JRDesignTextField(); textField.setBlankWhenNull(true); textField.setX(10); textField.setY(27); textField.setWidth(265); textField.setHeight(17); textField.setFont(normalFont); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{address1}"); textField.setExpression(expression); band.addElement(textField); textField = new JRDesignTextField(); textField.setBlankWhenNull(true); textField.setX(10); textField.setY(44); textField.setWidth(265); textField.setHeight(17); textField.setFont(normalFont); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{address2}"); textField.setExpression(expression); band.addElement(textField); textField = new JRDesignTextField(); textField.setBlankWhenNull(true); textField.setX(10); textField.setY(61); textField.setWidth(265); textField.setHeight(17); textField.setFont(normalFont); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{city}"); textField.setExpression(expression); band.addElement(textField); textField = new JRDesignTextField(); textField.setBlankWhenNull(true); textField.setX(10); textField.setY(78); textField.setWidth(265); textField.setHeight(17); textField.setFont(normalFont); expression = new JRDesignExpression(); expression.setValueClass(java.lang.String.class); expression.setText("$F{postcode}"); textField.setExpression(expression); band.addElement(textField); JRDesignStaticText staticField = new JRDesignStaticText(); staticField.setX(10); staticField.setY(95); staticField.setWidth(265); staticField.setHeight(13); staticField.setFont(normalFont); staticField.setText(" "); band.addElement(staticField); jasperDesign.setDetail(band); //Column footer band = new JRDesignBand(); jasperDesign.setColumnFooter(band); //Page footer band = new JRDesignBand(); jasperDesign.setPageFooter(band); //Summary band = new JRDesignBand(); jasperDesign.setSummary(band); return jasperDesign; } By: Prem - premb007 2 column Label design 2003-12-11 09:21 Teodor, Any suggestion for this.I too am facing the same problem. Is this a bug ?? In my case out of 20 labels only 11 are printed on page 1 & 9 on page 2, (no of column = 2) By: Teodor Danciu - teodord RE: 2 column Label design 2003-12-11 11:58 Hi, If you use the horizontal filler, as Erico does, then it is about this bug here: https://sourceforge.net/tracker/index.php?func=detail&aid=816508&group_id=36382&atid=416703 It can be seen even in the "horizontal" sample and it will be fixed in the next version. I hope to make availabe the fix on the cvs before the release. Thank you, Teodor By: Teodor Danciu - teodord RE: 2 column Label design 2003-12-11 13:31 Hi, This is now fixed in the CVS version. Thank you, Teodor

By: Andrea Chiumenti - kiuma textField_3 help please! 2003-12-11 08:42 Hello i'm trying to build my first report with jasper. when i call JasperPrint jp = JasperManager.fillReport(isReport, null, flussiDS); The manager firstly fills all the variables (i've debugged it). then the method exits with: HTTP ERROR: 500 Error evaluating expression value : textField_3 I really don't know A) what this message is B) how to solve the problem. Please help me. bye. By: Tobias Gaekle - ike987 RE: textField_3 help please! 2003-12-11 08:52 looks like a textFieldExpression can't be evaluated. you should post your xml report definition. By: Teodor Danciu - teodord RE: textField_3 help please! 2003-12-11 08:53 Hi, This is only the exception message. The cause is contained in the JRExpression that you catch. Print the stack trace on the console to see what is the cause. Put the fillReport call inside a try/catch if you haven't already don so. If you get the CVS version, you'll also see the text of the report expression that throws the exception. I hope this helps. Teodor By: Andrea Chiumenti - kiuma RE: textField_3 help please! 2003-12-11 09:18 yes it was a class cast exception between an integer and a string in an expression. By: Andrea Chiumenti - kiuma RE: textField_3 help please! 2003-12-11 09:33 so my expression is : "Tourists flows: " + $F{month}.toString() + $F{year}.toString() what's wrong with that ? By: Teodor Danciu - teodord RE: textField_3 help please! 2003-12-11 10:39 Hi, What is the type of the <textFieldExpression>? Check the "class" attribute. And what do you use as report compiler? The BSH compiler? I hope this helps. Teodor By: Gregory A. Swarthout - gswarthout RE: textField_3 help please! 2003-12-11 11:07 Helpful Hint: If you had included your report xml in your first message, likely we could have helped you long ago.

By: ccatindia - ccatindia How can I call Jasper Report file from swing 2003-12-11 01:10 We are the peoples involved in one swing application project.We are using jasper reports for reporting purpose.We didn't how to call jasper report from our application.So please give some example coidings for calling the report with parameter passing. Thanking you. CCAT By: Carlos Costa e Silva - carloscs RE: How can I call Jasper Report file from swing 2003-12-11 04:57 Look in demosamplesjasperJasperApp.java for an example. By: Alexander Wallace - aows RE: How can I call Jasper Report file from swing 2003-12-11 11:06 something like this will show the jasper viewer: public static void viewReport(JasperPrint jp) { try { if (jp != null) JasperViewer.viewReport(jp, false); } catch (Exception e) { } } you need to create a jasper print object and pass it to that method... No much sense in making an example of that since there is way too many different ways of filling up reports... It's easier if you check demo/samples/datasource example that comes with the source for jasper reports. To pass parameters to a jasper reports you just create a hash map, put parameter keys and values in and then pass it to the jasperFillManager like: Map parameters = new HashMap(); parameters.put("reportWhereClause", 'WHERE ID >0"); jp = JasperFillManager.fillReport(ClassLoader.class.getResourceAsStrea m("/com/whatever/swing/reports/AReport.jasper"), parameters, cn); Hope this helps... but check the examples in the demo/samples directory, they have all you need...

By: Alexander Wallace - aows Jasper view shown modally 2003-12-11 10:46 Hi there, I had posted this in the discussion forum and did not get a response so I'll try it here... As always thanks in advance. I would like to know if it is posiblle to show the jasper viewer in a modal way, so that when shown, code execution in a swing applet is stopped. Right now I'm using a listener to know when the window is closed and procede from there, but it's a pain when multpible windows are to be shown one after another. A no is also a good response, just want to know if it is possible at all and how or not, so that I jus keep doing it the way I'm doing it... Thanks! By: Alexander Wallace - aows RE: Jasper view shown modally 2003-12-11 10:49 Well, I was wrong, I had one reply in the discussion forum... So sorry about this post... I tried putting the jasper viewer in a dialog andshow it modally but although that seemed to work, when the print dialog is brought up, nothing on it was clickable, so this didn't work. Thanks.

By: naveen - naveen_bensily sql exception 2003-12-11 05:34 sir i am getting a problem when i am trying to fill the report using JasperFillManager.it says invalid sql statement.the compiling is working fine,but when it is trying to fill it comes with the exception.The query works fine.it works fine when i am not using any web server. the exception is as follows java.sql.SQLException: ORA-00900: invalid SQL statement at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108) at com.sysarris.report.CreateReport.buildReport(CreateReport.java:171) at com.sysarris.report.CreateReport.doPost(CreateReport.java:53) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) NESTED BY : java.sql.SQLException: ORA-00900: invalid SQL statement at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108) at com.sysarris.report.CreateReport.buildReport(CreateReport.java:171) at com.sysarris.report.CreateReport.doPost(CreateReport.java:53) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) NESTED BY : dori.jasper.engine.JRException: Error executing report query : null at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:379) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108) at com.sysarris.report.CreateReport.buildReport(CreateReport.java:171) at com.sysarris.report.CreateReport.doPost(CreateReport.java:53) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: ORA-00900: invalid SQL statement at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375) ... 19 more By: Andy Deighton - andyxr RE: sql exception 2003-12-11 05:50 What's the query? How are you passing it to the report? Andy UK By: Teodor Danciu - teodord RE: sql exception 2003-12-11 08:59 Hi, It looks like the report query is missing. The stack trace says: dori.jasper.engine.JRException: Error executing report query : null ... I hope this helps. Teodor