kburns

Does anyone have experience looking inside the actual JasperReports MySQL database? I'd like to search through the queries used throughout all reports to find usages of a certain string. The reason is because I have used a "LIKE" pattern in a number of places which has now changed in our code/database. I need to get a list of reports that use this so I can verify and updated them. Any ideas on how can I take a peak inside the database? And where can I see documentation on the table schemas?

Bump.

Has anyone handled input validation when implementing web services? I see the class named com.jaspersoft.jasperserver.irplugin.gui.jrxmlvalidator.ElementValidationItem, but no reference to it (or any validation for that matter) in the web services documentation. Any ideas?

Hi butlerc - No, I haven't been able to figure this out and am just now returning to the problem. If anyone case shed some light that would be much appreciated. Thanks!

Two things regarding using the LIKE condition and concatenating parameter strings: 1. How can I use the LIKE condition with a parameter. For example, in normal SQL: select * from my_table where column_value LIKE 'SOMETHING%' I'd like to insert my report's parameter for SOMETHING, so that I get anything that begins with my parameter's value.For example: select * from my_table where column_value LIKE $P{my_param} select * from my_table where column_value LIKE '$P{my_param}%' select * from my_table where column_value LIKE $P{my_param}% 2. How can I concatenating parameters with strings. For example, my parameter's value is "foo" and I'd like to get rows where the value is "foobar". I assume its something like: select * from my_table where column_value = $P{my_param}+'bar' Any ideas? Post Edited by kburns at 06/29/2011 20:47

I just had this problem (v 4.0.1) happen whenever I logged into the server. My fix was to clear the cookies/cache and it went back to normal.

I fixed this problem by stacking my subreports and page breaks on top of each other in the main.jrxml leaving not a pixel of space between them. [subreport 1] [page break] [subreport 2] [page break] [subreport 3] Clearly this is a bug that needs to be dealt with, but more importantly we need better error messages. "net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: No space left on device" ^ makes no sense.

This seems like a serious issue, so I figure it deserves it's own thread. I have created a report with 3 sub-reports each separated with a page break. When I run it through jasper server, it takes a very long time to return. Eventually it gives the following error after completely filling up the machine with temp data and crashing the server. Because this effects our production server it is a very serious issue. -- Oh my! The server has encountered an error. Please excuse the inconvenience. Error Message net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: No space left on device Error Trace net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: No space left on device at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.writeData(JRAbstractLRUVirtualizer.java:578) at net.sf.jasperreports.engine.fill.JRFileVirtualizer.pageOut(JRFileVirtualizer.java:122) at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.virtualizeData(JRAbstractLRUVirtualizer.java:531) at... -- Previously I had this problem with a report containing 2 sub-reports separated by a single page break. The solution was in changing the size of the sub-reports in the main one by making them very large in width and very short in height. Has anyone else come across this problem?

Still very confusing. No one has done this?

Now I'm having the same problem when creating a report that has 3 sub reports and using the jasper server interface. Can anyone explain why this is happening and how I can fix it?

This is in reference to implementing a web services interface and exporting report data in PDF format.

Jasper Server 4.0 comes with version 2.1.7 of itext, but the current version is 5.1.1. 2.x is structured as com.lowagie.text.*, but 5.x in com.itextpdf.*, so upgrading is not an option. Is there any reason for this? Are there any plans to up date the library?

Anyone has experience putting an image in a report and using web services? I googie for answers and keep ending up at my own threads.

Anyone with experience doing this?

Problem solved. My client was using jar for 4.0, but our server was running 4.0.1.

I am using jasper server 4.x and trying to export to XLSX. This option is available in the jasper server interface, however in Argument.class I do not see it: public static final java.lang.String RUN_OUTPUT_FORMAT_PDF = "PDF"; public static final java.lang.String RUN_OUTPUT_FORMAT_JRPRINT = "JRPRINT"; public static final java.lang.String RUN_OUTPUT_FORMAT_HTML = "HTML"; public static final java.lang.String RUN_OUTPUT_FORMAT_XLS = "XLS"; public static final java.lang.String RUN_OUTPUT_FORMAT_XML = "XML"; public static final java.lang.String RUN_OUTPUT_FORMAT_CSV = "CSV"; public static final java.lang.String RUN_OUTPUT_FORMAT_RTF = "RTF"; Any insight on this?

From looking at the regular jasperserver interface, I know the servlet is located at: /jasperserver-pro/reportimage?jrprint=1288466012_1306878828078&image=px What is the jrprint parameter? Where does it come from? I do not have any images in my reports. At the moment I am only concerned by the 1x1 pixel shim gif. That is being used to fill in white spaces and keeps causing a bunch of broken image links. I have been digging through the server source code and see it referenced as: <js:jasperviewer imageServlet="${pageContext.request.contextPath}/reportimage?jrprint=${jasperPrintName}&" page='${requestScope.page}' jasperPrintAttribute="${jasperPrintName}" innerPagination="${showPagination}" ignorePageMargins="${ignorePageMargins}" renderJsp="${requestScope.reportDisplayForm}"/> Here it is referenced as jasperPrintName, but there is no explanation in the code as to where it is defined. Any ideas?

Great question. Anyone have any suggestions? I'm stuck in the same place.

Hello all - I have created quite a few reports and now need to standardize the look and feel. I would like to create a style that I can be referenced across multiple reports (like CSS file included in multiple HTML pages) so I can make style changes that will immediately be reflected over all reports. Things like "Style Template" and "Style Reference" lead me to believe that this is possible, although I can't find any explanation in the iReport Ultimate Guide pdf (I'm using JS 4.0.1) I have already created a Style Template and then added a reference to it under my report's resources. However the styles do not appear as options when ending the properties of various elements. Any ideas, examples or suggestions?

Is it possible you've renamed it? Or you've copy and pasted an existing report into a new location in your repo?

This may actually have less to do with... net.sf.jasperreports.engine.util.JRStyledTextParser than it does with... java.lang.NoClassDefFoundError Any ideas on what is missing? The jar that defines JRStyledTextParser is in my classpath. Has anyone else run across this problem? Post Edited by kburns at 05/10/2011 16:41

I am curious about the HTMLTemplate Exporter add on: http://www.jaspersoft.com/node/1058 It sounds useful, but after reading that page I am not quite sure what the capabilities really are. Is there a working example somewhere? Can anyone share experiences they've had working with it? Also about this... Important note: this utility is sold “as-is”. Please review the click-wrap license agreement for full details. Does this mean there is no support included, if I were to buy it? Does it come with some level of documentation?

Oh yes, and as a follow up... My goal is to implement pagination within my web services. For example, run a report and get the 1st page, then the 2nd, etc. Seems likesimple stuff that has already been handled by many people here. I am using 4.0. I have already looked at pages 24-25 in the web services documentation, but they were no help. My concern is that something changed in 4.0 that was not documented in the pdf or changed in the sample webapp. Any *working* code snippets would be extremely useful. Thanks for your help!

In the web services sample webapp, I found the following commented out code (in executeReport.jsp) /* -------- The commented code below shows how to get from the webserive a JasperPrint instead of a final file format (like PDF) and use directly the JasperReports library to create the output with the maximum control over the exporter. ---------------------------------------------------------- JasperPrint print = client.runReport(currentUri, hashMap); net.sf.jasperreports.engine.JRExporter exporter = null; if (request.getParameter("format") == null || request.getParameter("format").equals("html")) { response.setContentType("text/html"); response.setCharacterEncoding("UTF-8"); exporter = new net.sf.jasperreports.engine.export.JRHtmlExporter(); JRHyperlinkProducerMapFactory producerFactory = new JRHyperlinkProducerMapFactory(); producerFactory.addProducer("ReportExecution", new ReportExecutionHyperlinkProducer()); exporter.setParameter(JRExporterParameter.HYPERLINK_PRODUCER_FACTORY, producerFactory); request.getSession().setAttribute(net.sf.jasperreports.j2ee.servlets.ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, print); exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI, "image?image="); } else if (request.getParameter("format").equals("pdf")) { response.setContentType("application/pdf"); exporter = new net.sf.jasperreports.engine.export.JRPdfExporter(); } else if (request.getParameter("format").equals("xls")) { response.setContentType("application/msexcel"); response.setHeader("Content-Disposition", " inline; filename=report.xls"); exporter = new net.sf.jasperreports.engine.export.JExcelApiExporter(); } os = response.getOutputStream(); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, os); exporter.setParameter(JRExporterParameter.JASPER_PRINT, print); exporter.exportReport(); */ I am implementing this, but getting the following exception error: SEVERE: Servlet.service() for servlet default threw exception java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser at net.sf.jasperreports.engine.JRAbstractExporter.setJasperPrint(JRAbstractExporter.java:800) at net.sf.jasperreports.engine.JRAbstractExporter.setInput(JRAbstractExporter.java:867) What I am missing? JRStyledTextParser has been included and the jar exists in my class path (jasperreports-4.0.0.jar) Post Edited by kburns at 05/06/2011 18:27

What does your code look like that generates HTML/PDF? Please post a small snippet if possible.