christiaan_se

This issue is almost 2 years old and many users seem to like it. It seems like a normal reporting requirement, many of our users ask for it. When can we expect an implementation of it? What can we do to speed things up?

My preference would be option 1), so after their "left" pages

I will definitely check out the new table components and see if we can migrate our existing reports to it. Since the existing reports have no notion of the concept column, I would like to suggest to make the rule as simple as possible. If the field does not fit entirely on the current page, it will be moved the next page. So this is independent of fields in "parent" grouping or other fields in the same band. This would already help us a lot. thanks, Christiaan

Hi, I have a question whether the roadmap presented in http://jasperforge.org/projects/jasperreports/tracker/roadmap is still feasible? More specifically, I very much like the idea of JasperReports supporting a more flexible approach to page orientation and page size, which from my point of view is the one major feature currently lacking in this great report engine. Moreover, I would like to propose to include the following feature request to be included since it fits nicely into this theme: 0004368: Column spanning multiple pages (title should probably be column header spanning multiple pages) kind regards, Christiaan

I agree, move to Java 6. For a product / developer the choice is straightforward I think, if you don't want to upgrade the jre version, you shouldn't upgrade your jasper version.

Hi Teodor, cutting the columns like a scissor would definitely not be a good option for us, since this would make the report unreadable. The whole column should move to the next page. If I am not mistaken, JasperReports already takes this approach, if the column only fits on the page partly, it is not printed at all right? My proposal would be the print it on the next page. What other content are you thinking about? A subreport? I would assume the same approach can be taken there if the subreport also has a columnheader: all subreport column headers which don't fit completely on this page are moved to the next. I think it should be up to the designer of the report to make sure that the "fit columns on next page" behaviour is applicable for his report. kind regards, Christiaan

Did you try: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=41922 I have to admit, searching on this forum is not really ideal. kind regards, Christiaan

The problem is the excel library you are using to produce the Excel. Are you using JExcelApi? In that case the Excel file is completely stored into memory (the virtualizer doesn't have effect on that). In more recent versions they have allowed you to use a temporary file so the Excel file is not completely stored into memory, but you should configure that explicitly. I've posted this before in a topic, so may be you can do a search on that. kind regards, Christiaan

hi, I want to print an image where the image is using the full height of the detailband. I have solved this as follows: 1) creating an JRDesignImage with JRImage.SCALE_IMAGE_RETAIN_SHAPE 2) Creating a detail band which is has the actual height of the page minus header and footer band heights 3) Placing the JRDesignImage on the detail band, give it the same height as the detail band and setting the stretch type to STRETCH_TYPE_RELATIVE_TO_BAND_HEIGHT This works fine, however, if the header dynamically increases in height (eg. because it contains a text which is wrapped to the next line). JasperReports keeps on generating the report for ever since (of course) the detail band's height is too large. Is there another way to solve this? kind regards, Christiaan

Hi, can someone elaborate on the feature: - generic component support to allow extending the functionality of the JasperReports engine by plugging-in custom-made visual components that would take data as input and produce content that is embedded into the resulting documents; What does it do and how can I use it? (eg. can I embed swing components in the report?) kind regards, Christiaan

JExcelAPI has been made more memory-scalable in terms of writing Excel files. Starting from version 2.6.5 you can use useTemporaryFileDuringWrite. You probable need to subclass JExcelApiExporter in order to use this property. kind regards, Christiaan

Hi Assaf, "You are saying that anyone who wishes to run reports must have java installed on their computer" Did I? I was just talking about the viewer you were talking about. As mentioned, in order to preview a report in the webbrowser you will probably need to export your report to pdf or html (which can be done without the viewer executed on the server) so it can be displayed in the browser. Anyway, Jasperreports is certainly used in J2EE applications. I am just not one of them, so may be someone else should respond on how they handle previewing a report. I am not aware of any Ajax viewer though. kind regards, Christiaan

Hi, I notice when exporting to rtf, the bottom part of texts are not completely visible. Eg. "p", "q" or "g" are cut off whereas they are completely visible in the preview? kind regards, Christiaan

you've got my vote for this issue as well! ;-)

Hi, see answers inline: 1. Is the Jasper Viewer only Swing based or is there an DHTML/Javascript viewer that can be incorperated into a J2EE application based on JSP/Struts ? The viewer (JasperViewer) is a subclass of a JFrame and thus Swing based (see http://jasperreports.sourceforge.net/api/net/sf/jasperreports/view/JasperViewer.html). As such you cannot use it to preview it in a J2EE application. You should either make it an applet (I think it is in one of the examples) or you probably need to export it to pdf, so it can be previewed in your explorer. 2. Can a viewer component of Jasper be incorporated into our application so we can achieve a single installation for application + report viewer ? yes, very easily. As mentioned the viewer is a JFrame which you can open in your application. Even better, you can use the JRViewer, which is a subclass of JPanel, to nicely embed a viewer into your application (htmlhttp://jasperreports.sourceforge.net/api/net/sf/jasperreports/view/JRViewer.html). 3. Does this viewer include the export capabilities (Word,PDF,Excel) ? I think the viewer is for previewing only. It is very easy to export a report in the format pdf, excel, xml, rtf (see Faq and examples). Again, since the viewer is a panel it is easy to integrate the export to whatever in the viewer. 4. Non DB Datasources – I would like to base the reports on a non DB dataSource – would like my java classes to fetch the data and see some Java object in the HTTP Session (or pass to report in any other way) -> this object should be the basis for the report. Is this possible ? yes, I think that is one of the strengths of jasperreports. You can create your own datasource as a java class an print whatever you want to print. In our application we even build up the report at runtime using the classes of JasperReports (instead of the xml layout). Note, to visually create a report design, use IReports. 5. RTL (right to left) direction – are there any open issues regarding rtl support (does the export formats support the rtl direction as well). Don't know about this one. I suppose it uses the same techniques as java does. 6. Can I use the open source edition for the above or do I need to purchase a professional edition? (how to I get the Jasper Studio for building the reports?) Yes the open source edition provides all the required capabilities. Someone from the Jaspersoft team can probably better elaborate on the professional edition. kind regards, Christiaan

Hi, you have to use two separate textfields (instead of one) using the same variable PAGE_NUMBER, but setting different evaluation time current page: JRExpression.EVALUATION_TIME_NOW total page count: JRExpression.EVALUATION_TIME_REPORT Note, this has also been described in: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=37662#37662 kind regards, Christiaan

The image used [file name=test1.png size=45729]

Hi, I have create a report for a single image. I notice that displaying this report in the JRViewer is quite slow when scrolling up or down. Especially when the report consists of multiple pages the viewer becomes quite inresponsive. Any ideas how to improve this? kind regards, Christiaan [file name=image.jrxml size=8856]

Hi Michael, why don't you create a custom datasource so you can do whatever you want, including executing JDO queries to return the right objects for the report. I also work with JDO and have taken this approach and it works great. kind regards, Christiaan

Thanks, that works!

Hi Teodor, I am constructing the rectangle in code using a JRDesignRectangle. Unfortunately a JRDesignRectangle doesn\'t have a method setStretchWithOverflow() method like JRDesignTextfield does. Also, setting the background color of the text field is also not really an option, since we use this code also for other situations where eg a column has two textfields below eachother with some spacing. kind regards, Christiaan

Included jrxml file

Hi, when printing a report to txt format (1.3.3) I get the following exception when the report design has elements beyond it's margins (see attachement). Other formats dont give this and jus wrap it. Is this a bug? Caused by: java.lang.ArrayIndexOutOfBoundsException at java.lang.System.arraycopy(Native Method) at net.sf.jasperreports.engine.export.JRTextExporter.exportText(JRTextExporter.java:476) at net.sf.jasperreports.engine.export.JRTextExporter.exportElements(JRTextExporter.java:345) at net.sf.jasperreports.engine.export.JRTextExporter.exportPage(JRTextExporter.java:322) at net.sf.jasperreports.engine.export.JRTextExporter.exportReportToWriter(JRTextExporter.java:298) at net.sf.jasperreports.engine.export.JRTextExporter.exportReport(JRTextExporter.java:240) kind regards, Christiaan [file name=report.xml size=21443]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/report.xml[/file]

Hi, exporting to different formats use other libraries to accomplish this. Depending on how these libraries deal with memory everything is loaded into memory or not. Virtualization only deals with the reports part (filling the report and creating a representation of the report). For instance, the JExcelApi holds all data in memory before creating the excel file. I recently did some modification on the library in order to deal with large quantities, not sure whether this will be included in the library itself. kind regards, Christiaan

Thanks. Btw, do you recommend saving JasperDesign to xml instead of serializing the object for compatibility reasons? kind regards, Christiaan