fenix4life

Hello All, We are having some issue with the PDF export and the 'Text Field' expression with JasperReports. We have a random text in a forgeing language for instance : Bu mesajı yazdırmadan önce çevreye olan sorumluluÄŸumuzu bir kezdaha düÅŸünelim which we would like to be displayed on the report. Now we have an issue where within the Jasper Preview those characters are correctly being displayed when using a 'Static Text' block. If we use a 'Text Field' then this fails. Some characters are not displayed anymore and are removed from the report. When we export the report to PDF then in all cases the characters are wrong ('Text Field' and 'Static Text') HTML export however display the content just like the previewer. We've tried to change the UTF-8 settings but this made it worse. Any idea how we would be able to export in PDF with those strange characters. A rather identical case has been logged but was using the previous pdf enconding functionality which is now obsolete. Is the solution still identical or not? Using version JasperReports 3.7.1 with iReport 3.7.1 Regards, Post Edited by fenix4life at 06/07/2011 14:51 Post Edited by fenix4life at 06/07/2011 14:55

To make it more strange the issue is linked with the pattern itself. 1800-01-01T00:00:00+01:00 or 1800-01-01T00:00:00 can be handled using DATE_PATTERN yyyy-MM-dd'T'HH:mm:ss From the momement I add the timezone Z then it fails working and can not parse 1800-01-01T00:00:00+01:00 anymore. As a workaround I'll remove the Z from the date pattern. That should do the trick but still remains strange

Hello, It took me a while to find a way to alter the XML_DATE_PATTERN field within iReport. Now I managed to alter on the Date Pattern in the Data Source with the following value yyyy-MM-dd'T'HH:mm:ssZ This value was selected as it matches the date fields within my XML file (for instance 2011-03-09T00:00:00+01:00) Additionally I've altered the Field Class from a date field to have a direct cast to the correct Data Type. When I generate the report I'm having the following stacktrace: Error filling print... Unparseable date: "2011-03-09T00:00:00+01:00" org.apache.commons.beanutils.ConversionException: Unparseable date: "2011-03-09T00:00:00+01:00" This error is a bit odd as it mentions it can not parse a date which has the same date pattern as defined in the XML_DATE_PATTERN parameter. I would have hoped that it would have solved the initial issue but it doesn't look to make any differences. Could this be caaused by the fact that the pattern is not one of the defaults in the list? Maybe some kind of behind the scene restriction of date patterns. I've added a small example as an attachement to explain the error. If someone could make the parsing of the date work pleas let me know. Thx,

Hello all, We are currently looking for a potential integration of the JasperServer/Analysis/OLAP functionality within a commercially distributed, closed source, software. I do know that this is probably the 500th thread which is similar but they are always just that slightly different and sometimes in contradiction. Now we know that there are several limitations linked to the GPL license which we did not had with the LGPL license for the JasperReports library. We are currently reviewing/documentingen several cases and what effect they could have on our software. Could someone confirm if my understanding is correct. We are searching for an integration which offers us the most flexibility but still without a commercial license if possible. Case 1: We install/Deploy the current JasperServer 4.0 version on a Web Application and we then seamless integrate this website as a portall within our application. (Meaning that the user clicks in our menu and then views the OLAP report within our application frame. No menu from jaspersoft,... will be shown, just the basic middle view) => This is from my understanding not possible with a GPL license while keeping our source code closed and not release this under GPL or by buying a OEM commercial license. Case 2: We install/deploy it on a Web Application Server but let it run as a stand alone. Within our application we can add a button/link to open a new webbrowser session/popup. No login will be provided as the lik will contain the SSO possibility and will directly navigate to the correct view. The layout/content of the JasperServer will remain as-is => This should be possible with GPL license but with the following restrictions -> IF we let the user download the JasperServer himself and let him/us install it. Two seperate actions are needed - install our software and then install jasperserver. This process is not automated. Case 3: We alter the UI from JasperServer and distribute this new UI with our product. => From the moment we alter the source code I presume it does not even mather how this integrated within our commercial application. As we need to package the software together it won't be possible to do this without a commercial OEM license. But if we don't package our commercial software with jasperserver but we offer as an additional download the modified JasperServer could this not be a workaround and still offer us the possibility to implement with a case 2 like implementation. The only thing that would be required is a GPL version of the modified JasperServer which is not an issue for us. Is my understanding correct that only case 2 would be possible with a GPL licensed software or could the workaround proposed in case 3 (or any other -in this case which one ? -) also be possible. A double download and/or install is not a problem and a GPL based JasperServer is also not an issue. Kind Regards and Thank you in advance for a response

Issue found. More information can be found on the following page -> http://stackoverflow.com/questions/3628302/jasperreports-noclassdeffounderror-exception-on-net-sf-jasperreports-engine-util In short it's the property java.awt.headless that needs to be changed

Hello All, We have been moving our internal application towards a new machine. Unfortunattely we aren't able to generate any Jasper Reports document any more. Any attempt results in a no class def found error. I've found some similar tickets but without a real solution. I presume it's machine related but it there some kind of checklist or entry point to start out research. (Machine itself is Unix/Linux based) Rgrds Code:

Next to the creation of a decompile script you could also use iReport for this purpose. iReport can open and auto decompile jaser files back to a jrxml which can then be modified

Hello, I was wondering if there are any settings related to the csv report which might have an influence on the resulting character set. Currently I'm having those é, ù,... stored in the CSV as (i think) UTF-8. Problem is that when opening in Excel, textpad that those characters can't be read. What I would like to achieve is when export towards csv those characters are back translated to what it supposed to be and not to UTF-8. I presume it's some kind of setting/default parameter but which one would that be. Regards

Hello, those files need to be located within the classpath of the application. Most likely where the jar's are located or any other directort which has been defined as a part of the classpath. Or YOu could also write an wrapper around this properties system where you, as an application, picks up the correct file and transmits this aas a parameter to jasperreports (Only backfire of this, is that you will have to add this parameter to every subreport)

Hi, While reading my initial mail again I'm thinking what have I been drinking that day :-) I was more a request for Graph in footers then for a crosstab but now I've done that I'll stick with that demand :-) Now I've done a quick check but it looks i'm not able to perform such behavior. Do we need to change something specific in the crosstab. What I've done is first created a crosstab in the report footer. This is working like a charm. Then I've added a Group with a group footer. Then I've added an identical crosstab to this group footer with the Wizard but then I'm having a stacktrace. If I remove this newly added crosstab and just move the working crosstab from the summary to the group footer then I have the same issue/stacktrace. Error filling print... Error incrementing crosstab dataset net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset     at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:758)     at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:175)     at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:148)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:736)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:272)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:114)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:59)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:857)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed.     at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:300)     at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:754)     ... 13 more Print not filled. Try to use an EmptyDataSource...

Nobody with an idea how I still can use alternate colours while removing/hiding some records with a PrintExpression else I should introduce some kind of workaround by introducing a sort so that those records are automatically in the beginning or at the end of the list.

Hello All, We've created a report with alternating colours in a detail line. What we have done is create a style within the XML which contains a boolean. the detail line received a frame which has a printelement with the same style defined. The alternating colours is working. Now we need to add a printexpression on the detail line. Only some line needs to be displayed. The non displayed lined have to be processed with variables. Unfortunately it looks like the alternate does not handle the printexpression. The counter which is available within the defined style is stil calculation. You can se this in the example where there is a jump from 7 to 9. Row number 8 is a record which isn't shown as will be processed with a specific variable. Any idea if it's possible to extend the style with the printexpression? Code:<!-- Defined style at top of the jrxml --><style name="AlternateDetail" isDefault="false"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean( $V{REPORT_COUNT}.intValue() % 2 == 1 )]]></conditionExpression> <style isDefault="false" style="AlternateDetail" mode="Opaque" backcolor="#E6E6E6"/> </conditionalStyle></style><!-- Content of the detail line --><printWhenExpression><![CDATA[$F{OPTIONTYPECODE} !=622 && $F{OPTIONTYPECODE} !=623]]></printWhenExpression><frame> <reportElement style="AlternateDetail" x="0" y="0" width="608" height="11"/>

This is indeed what I need. As I didn't saw any attribute in the sample I thought this wasn't implemented yet. Can be closed.

Hello, It looks I manage to find some additional information regarding this issue. It's not related to the SQL or XML use. While testing a working report on an different environment we had the same issue as mentioned above where the Resource Bundle is not being used for sub report. While checking we found out that on the working environments we still had the initial Resource Bundle in the classpath. This caused us not to see this issue as we thought that the correct file was being picked up. The issue/question now basically changes. Is there any way to transfer the passed Resource Bundle from the main report to the subreport? Can the REPORT_RESOURCE_BUNDLE parameter be used for this purpose? As the issue has changed could the title of this ticket be changed. Regards

Hello All, I just have a small question. I would like to have confirmation that we are obliged to use the jasperreports-fonts.jar to be able to export towards pdf with fonts like eg. SansSerif in Bold, Italiv. I found many information regarding the font extensions but they are in most cases linked towards additional fonts and not the fonts which you basicly can find within eg. iReport. Can those small list of fonts be seen as default and giving us the functionality to export them in any style (bold,...) or is the fonts.jar needed in all cases. Regards,

Add the following reports: Amendment_Quote.jrxml Sub_LeaseServiceComponents.jrxml Sub_Amendment_Quote.jrxml Sub_Amendment_Quote_Closed_Services.jrxml Sub_Amendment_Quote_Open_Services.jrxml Amendment_Quote.properties Those reports represent a case where SQL and subreport is used in combination with a Resource Bundle. It's possible that something is different in the set up but I don't manage to see any. It could be something small or not related to the resource Bundle functionality. If any more information is needed just let me know. Regards, (In mean time I created a workaround by picking up all the needed Resource Bundle labels within the main report and passing them as paramters to the subreport. Not very clean but helps me forward :-) )

Hello. I have a report using an XML file as an datasource but as you all know it has the behaviour where the first records is missed in the subreport causing everything to be moved and having the 2 last elements having the same data. I did found a webpage on jasperforge concerning this behaviour but I can't seem to manage implementing their proposed solution. (http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/faq.html#FAQ20) Below you can find some code which I used to test their solution but then I have an empty subreport. This is not really what I wanted to achieve. Possibly I'm doing something wrong but I can't seem to see what that might be. Any help, tips or feedback? Code:Before: <group name="Sysrepobject"> <groupExpression><![CDATA[$F{sysrepobjectid}]]></groupExpression> <groupFooter> <band height="50"> <subreport isUsingCache="true" runToBottom="false"> <reportElement x="0" y="15" width="555" height="35"/> <subreportParameter name="PAR_OBJECT"> <subreportParameterExpression><![CDATA[$F{name}]]></subreportParameterExpression> </subreportParameter> <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//attributes_Set//attributes")]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA["Sub_Object_Attribute_Security.jasper"]]></subreportExpression> </subreport> </band> </groupFooter> </group>After: <parameter name="parameter1" class="net.sf.jasperreports.engine.JRDataSource" isForPrompting="false"> <defaultValueExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></defaultValueExpression> </parameter> <group name="Sysrepobject"> <groupExpression><![CDATA[$F{sysrepobjectid}]]></groupExpression> <groupFooter> <band height="50"> <subreport isUsingCache="true" runToBottom="false"> <reportElement x="0" y="15" width="555" height="35"/> <subreportParameter name="PAR_OBJECT"> <subreportParameterExpression><![CDATA[$F{name}]]></subreportParameterExpression> </subreportParameter> <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{parameter1}).subDataSource("//attributes_Set//attributes")]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA["Sub_Object_Attribute_Security.jasper"]]></subreportExpression> </subreport> </band> </groupFooter> </group>

Hi, We have a small question regard the reuse of subreport in Multiple Master Reports. We are using some subreport in several master reports which is great but for one Master Report the behaviour is slightly different. This specific subreport displays some data and fills 2 variables. Now my case only needs the value of those 2 variables but does not need the view/show content. Any idea how we can set Jasper Report to kind of suppress the view of the subreport. (eg. Limit in in size to pixel 1) but still filling my variables in the background. Adding a true/false parameter could possible also be a solution but I prefer checking out if there are some other issues. Regards

Hello All, We're having some isssues with the localization of the Resource Bundle when generating the report. Initially we thought that filing the REPORT_FILE_RESOLVER would be enough for Jasper to know where to find the Resource Bundle. As this was not the case we found the REPORT_RESOURCE_BUNDLE property which could do the trick. Now my question is how should this best be used. -> Should we give the path towards the Main multiulanguage file or already to the more specified. Path() + JasperReport.GetResourceBundle() + ".properties" of Path() + JasperReport.GetResourceBundle() +"_" + Locale + ".properties" -> If we need to set the Locale when passing the Resource Bundle should we then also use the Report_locale property ? -> Will The application automaticly select the default Resource Bundle if not avialble when passing the resource Bundle. I presume we will have to check if the file is present and automaticly switch towards the default one. What we would like to achieve is that the Resource Bundle from the same directory as the Report is being pickup up. As this location differens from environment hard coding it in the report is not really an option. I thought maybe to use the REPORT_FILE_RESOLVER path to define the this does not seem to be working. Kind Regards, Post Edited by fenix4life at 02/24/2010 15:33 Code:Error filling print... Can't find bundle for base name $P{REPORT_FILE_RESOLVER}/Quote, locale en_GB java.util.MissingResourceException: Can't find bundle for base name $P{REPORT_FILE_RESOLVER}/Quote, locale en_GB Post Edited by fenix4life at 02/24/2010 15:41

Hello, It looks like I have an issue with alternating colours when a subreport is empty. What I need is two distinct lists which both have alternating colour. What I did is create a main and a subreport. Both report have an identical style and conditionalStyle tag. Then a frame was added with the needed fields. This frame is then linked to the defined style. Now when I generate the report with an ID which result in main and subreport to retrieve records then the generate result has alternating colours. If I then select an ID which does not have any records in the subreport then I don't have any alternating colours in the main report. I thought this might be linked to the fact I was using the same style name in main and subreport. After changing this, this did not make any difference. Any idea what might be the trigger of this? Code:<style name="AlternateDetail" isDefault="false"> <conditionalStyle> <conditionExpression> <![CDATA[new Boolean( $V{REPORT_COUNT}.intValue() % 2 == 1 )]]> </conditionExpression> <style isDefault="false" style="AlternateDetail" mode="Opaque" backcolor="#E6E6E6"/> </conditionalStyle></style><frame> <reportElement style="AlternateDetail" x="0" y="0" width="766" height="11"/> <textField isStretchWithOverflow="true"> <reportElement x="14" y="0" width="209" height="11"/> <textElement> <font size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[($F{Foo}.equals( null )? $F{FOO}: " ".concat($F{BAR}))]]> </textFieldExpression> </textField> ...</frame>

Just to say that the solution was indeed available in the scriplet example. What you must to is create a "Frame" in the section where you would like to see alternating colours. In addition you will need to define a conditionalstyle. By linking both you will have your altenation. Afterwards you only need to place you elements within this frame. This result in the needed layout. More info (and other - not tested by me) solutions can also be found here: http://sothaticanremember.blogspot.com/2008/11/alternate-background-colour-of-rows-in.html Code:<conditionalStyle> <conditionExpression> <![CDATA[new Boolean( $V{REPORT_COUNT}.intValue() % 2 == 1 )]]> </conditionExpression> <style isDefault="false" style="AlternateDetail" mode="Opaque" backcolor="#E6E6E6"/></conditionalStyle><frame> <reportElement style="AlternateDetail" x="16" y="0" width="766" height="14"/></frame>

Hello, I'm just wondering, is there any way to limit the list of available functions to a specifc JDK. I had some issue with reports using String.equals(null) but as this is only available for 1.6 or higher this gave issue when deploying to our 1.5 application. I managed to find the correspond 1.5 syntax so this won't be a problem in the future for me. Can we set a kind of limiter, compatibility mode so that only 1.5 or other functions are shown. This could avoid some possible corrections due to the use of non compatible functions. Regards,

Hello, Is it possible to create a Print Expression not on data but on page. I've tried somthing like Page_number < Page_count but this doesn't work. When checking the documentation I only can manage to receive the corrent number of pages when creating a text field with evaluation time 'Report' bu thow can we use this field in a formula. Kind Regards

Hello, I'm creating a report which uses data from an XML to display. I'm having troubles to display the date information. Part of the XML: <Depreciation_Table> <the_sequence_number_of_the_period type="Integer">1</the_sequence_number_of_the_period> <start_date_of_the_period type="Date">2006-10-02</start_date_of_the_period> <end_date_of_the_period type="Date">2006-11-01</end_date_of_the_period> <capital_at_the_start_of_the_period currency="Euro" currency_id="1" type="Currency" >24141.83</capital_at_the_start_of_the_period> <total_payment currency="Euro" currency_id="1" type="Currency">312.22</total_payment> <capital_payment currency="Euro" currency_id="1" type="Currency">254.03</capital_payment> <interest_amount currency="Euro" currency_id="1" type="Currency">58.19</interest_amount> <capital_at_the_end_of_period currency="Euro" currency_id="1" type="Currency" >23887.8</capital_at_the_end_of_period> <jpk currency="Euro" currency_id="1" type="Currency">2.92</jpk> </Depreciation_Table> When I add the field start_date in the report and link it towards java.util.Date I receive an error Unparseable date error. <field name="start_date_of_the_period" class="java.util.Date"> <fieldDescription><![CDATA[start_date_of_the_period]]></fieldDescription> </field> If I choose class java.lang.String then no error is thrown but I can not seem to format the report. I need to extract the year from the date to add a group. I could use a substring of first 4 characters but this isn't really nice. (In addition that I need to change the format of the date to display) Any ideas? Code:Error filling print... Unparseable date: "2006-10-02" org.apache.commons.beanutils.ConversionException: Unparseable date: "2006-10-02"     at org.apache.commons.beanutils.locale.BaseLocaleConverter.convert(BaseLocaleConverter.java:241)     at org.apache.commons.beanutils.locale.LocaleConvertUtilsBean.convert(LocaleConvertUtilsBean.java:285)     at net.sf.jasperreports.engine.data.JRAbstractTextDataSource.convertStringValue(JRAbstractTextDataSource.java:69)     at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:300)     at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:818)     at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:782)     at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1448)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:108)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:119)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:970)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.text.ParseException: Unparseable date: "2006-10-02"     at java.text.DateFormat.parse(Unknown Source)     at net.sf.jasperreports.engine.util.JRDateLocaleConverter.parse(JRDateLocaleConverter.java:84)     at org.apache.commons.beanutils.locale.BaseLocaleConverter.convert(BaseLocaleConverter.java:232)     ... 14 more Print not filled. Try to use an EmptyDataSource...

Hi, Does any one has a quick code sniplet of a Java Application where the subreport has a different datasource then the mainreport. Last month I saw some example for this but I can't seem to be able to find this example again. Kind Regards,