mariuss

with a blank template you have to drag and drop the fields on your design view (detail band)

Hi jbmorla, click once on your report, then in the Properties window once on the button "Edit quera, filte and sort options" to open the Dataset and Query Dialog and then click once on "Read Fields" Marius

Hello community, I try to hide a field in the column footer on the last page with detail records. I thought if I create an integer variable PageCount_SUM with sum calculation and as expression $V{PAGE_COUNT}, then it will be possible to use the print when expression: $V{REPORT_COUNT}!=$V{PageCount_SUM}. But this does not work. After previewing the report I know that the report has 14 records on the first page, +17(31) on the second, + 17(48) on the third and +2(50) on the fourth page. If the print when expression is hard coded like $V{REPORT_COUNT}!=50 or $V{PageCount_SUM}!=50 I will have what I want, but not when I use $V{REPORT_COUNT}!=$V{PageCount_SUM}. Does anybody have experience with this issue and want to give me a hint how to do it? Or maybe you know another way to do that? Thank you :) Here is the report using Jaspersoft Studio 5.5, the Sample DB and groovy, just paste and copy to test it. I need Help :) <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version last--><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="PrintWhenLastDetailPage" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5ed3c130-043e-4bcb-bb9b-599e9d76ab00"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/> <queryString language="SQL"> <![CDATA[select firstname, lastname, street, cityfrom address]]> </queryString> <field name="FIRSTNAME" class="java.lang.String"/> <field name="LASTNAME" class="java.lang.String"/> <field name="STREET" class="java.lang.String"/> <field name="CITY" class="java.lang.String"/> <variable name="RecordPos_COUNT" class="java.lang.Integer" calculation="Count"> <variableExpression><![CDATA[boolean.TRUE]]></variableExpression> </variable> <variable name="PageCount_SUM" class="java.lang.Integer" incrementType="Page" calculation="Sum"> <variableExpression><![CDATA[$V{PAGE_COUNT}]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"> <staticText> <reportElement x="40" y="2" width="101" height="30" uuid="726ded3a-dee6-4172-8a9b-2e48416794a5"/> <text><![CDATA[FIRSTNAME]]></text> </staticText> <staticText> <reportElement x="141" y="2" width="138" height="30" uuid="e1e4d9da-aab5-447c-89b5-dd5c34c09997"/> <text><![CDATA[LASTNAME]]></text> </staticText> <staticText> <reportElement x="279" y="2" width="138" height="30" uuid="18decfc1-65ed-49d9-93a1-0770c2674bda"/> <text><![CDATA[sTREET]]></text> </staticText> <staticText> <reportElement x="417" y="2" width="138" height="30" uuid="717a4c67-c255-4448-9945-e62d4e0a18ae"/> <text><![CDATA[CITY]]></text> </staticText> <staticText> <reportElement x="0" y="0" width="40" height="30" uuid="544db95f-2469-456e-9250-e7a4bea75b2b"/> <text><![CDATA[POS]]></text> </staticText> </band> </columnHeader> <detail> <band height="35" splitType="Stretch"> <textField> <reportElement x="40" y="0" width="101" height="30" uuid="c845a013-6f55-44b1-bb49-5db46c442fb5"/> <textFieldExpression><![CDATA[$F{FIRSTNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="141" y="0" width="138" height="30" uuid="e8ae0655-0b2c-4bb5-a3c1-f2357c526e16"/> <textFieldExpression><![CDATA[$F{LASTNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="279" y="0" width="138" height="30" uuid="02677fe9-123e-48f9-b34c-8c7cf0f23a02"/> <textFieldExpression><![CDATA[$F{STREET}]]></textFieldExpression> </textField> <textField> <reportElement x="416" y="0" width="138" height="30" uuid="aacaee2a-8c76-4c1c-b153-2cb0a6e94334"/> <textFieldExpression><![CDATA[$F{CITY}]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="0" width="40" height="30" uuid="ed6c6a13-b25b-46c2-b017-7c66663d4b4a"/> <textFieldExpression><![CDATA[$V{RecordPos_COUNT}+"."]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="52" splitType="Stretch"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="220" height="20" forecolor="#000000" backcolor="#FFFF00" uuid="4b088258-01cc-42cb-9d90-213783076f61"> <printWhenExpression><![CDATA[$V{REPORT_COUNT}!=$V{PageCount_SUM}]]></printWhenExpression> </reportElement> <text><![CDATA[Please hide me just on the last page with records]]></text> </staticText> </band> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="46" splitType="Stretch"> <textField isStretchWithOverflow="true"> <reportElement x="0" y="0" width="141" height="30" uuid="9fb1b703-dbd7-4f5b-87c5-e824a90b0da4"/> <textFieldExpression><![CDATA["Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. nn Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of de Finibus Bonorum et Malorum (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, Lorem ipsum dolor sit amet.., comes from a line in section 1.10.32.The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from de Finibus Bonorum et Malorum by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham."]]></textFieldExpression> </textField> </band> </summary></jasperReport>[/code]Marius

Thank you Stephen, your answers are very helpful for my start with jasper. Did you manually insert the xml_url param in the jrxml file? I do it like this: ]]></parameterDescription></p><p> <defaultValueExpression><![CDATA[$P{XML_URL} ? $P{XML_URL} :"http://server:8080/nav/xml/test/Anfrage_EA00005.xml" And whe I'm publishing the report, the window with "Select Resources to publish" is just skipped(I find it, when I go Back a step with the publishing wizard) but the xml_url param ist still in the report. I can change the param, and the changes are not lost after publishing to the server :). Do you use groovy or javascript? I can not use javascript, there is a bug report posted: http://community.jaspersoft.com/jaspersoft-studio/issues/3305. But groovy is also ok :). Do you have your JSON Adapter now in use ? :) Have a nice day, Marius

Hi carrison, do you design with iReport or with JS Studio? Just click on your report in the Report Inspector and take a look at the Properties and find the Columns section. In Jaspersoft Studio you have to click once more on Edit Page Format: Marius

Hi akshathajcta, due to java.io.FileNotFoundException C:Program FilesApache Software FoundationTomcat 7.0libdb2jcc-9.7.jar (Access is denied) so maybe you have to check the folder/file permissions of your war installer folder. Try first to uncheck the read-only folder attribute as described here (apply changes to this folder, subfolders and files) and if that is not sufficient then take a look at this tutorial. Marius

Hello community, the errors from the view Report State are not logged in the default log file from workspace/.metadata/.log So where can I find the log file for these errors ? Thank you, Marius

Hi Luciana, do you know the jasper server requirements? You have here and here an overview of that. My JAVA_OPTS are: JAVA_OPTS=$JAVA_OPTS -Xms1024m -Xmx2048m -XX:PermSize=32m -XX:MaxPermSize=512m -Xss1m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled[/code]Maybe you'll find solutions for exceeding the garbage collector overhead in this thread and in this thread. Marius

Hi Stephen, what do you mean with "assuming you setup the syncing and checked the parameters to upload"? After editing I publish the jrxml file on the jasper server since i have a JRS connection in my JR Studio. The only option checked is "Don't use any Data Source". Is there another workflow for doing that? Related to the JSON Adapter, you have on the JR Server a sample for a CSV Data Adapter under Reports/Interactive and http://jasperreports.sourceforge.net/sample.reference/csvdatasource/. And you can take a look at the Chapter 5(Custom Data Sources) of JasperServer Ultimate Guide: community-static.jaspersoft.com/system/files/documentation/js-ultimate-guide-5.0.pdf And here is another thread about data adapter: http://community.jaspersoft.com/questions/802580/how-create-excel-data-source-jasperreports-server I hope this can help you a little bit :) Marius

Hi, a similar thread you'll find here. Marius

hi :) and sorry for the delay, I didn't realize that I have an answer, I think that I accidently skiped that email. Thank you for sharing your experience with me and the community! Where did you find out, when we have to create an input control for the passed parameter, as you mentioned at step 4 and when not? Can you please point me on that part of the documentation, thx again. Your answer helps me a lot. First I got this Error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Type mismatch: cannot convert from String to boolean value = ((java.lang.String)parameter_XML_URL.getValue()) ? ((java.lang.String)parameter_XML_URL.getValue()) :"http://your/server"... but then i realized that I have tho change the language used for the report expressions to javascript :) and now it works :) Concerning the JSON adapter I have just some links for you: http://community.jaspersoft.com/wiki/how-create-and-use-jrdatasource-adapter http://community.jaspersoft.com/wiki/how-create-and-use-jrdatasourceprovider-adapter http://community.jaspersoft.com/wiki/sample-report-using-json-data-source-deployed-jasperreports-server http://community.jaspersoft.com/wiki/how-query-file-based-json-datasource http://stackoverflow.com/questions/11536995/create-jasper-report-pdf-form-from-json-object-or-json-string/15518513#15518513 http://www.grantcurrey.com.au/blog/2013/01/26/using-jsondatasource-with-jasperreports/ Maybe it is better to open a new thread for that. So many thanks again :) Marius

Hi, take a look at this tutorial. Marius

Hi, there is an example in the jasperreports library as mentioned here. And some tutorials(1, 2) for iReport. I hope this can be useful for you :) Marius

Sorry, it is not mentioned in the section of Log Settings Page but at the begin of the chapter 7.1 Configuration Settings in the User Interface. You can remove loggers from Repository/System Properties/GlobalPropertiesList. Marius

Hello community, I can not find out how to remove added loggers to the log settings page from the jasper server web interface. Do I miss something? :) I add loggers as mentioned in the Jasperreports Server Admin Guide, but how can I remove them? Thank you Marius

Hi jpderyck, as mentioned in the Jasperreports Server Admin Guide Chapter 7.11, you can do thi in the WEB-INFlog4j.properties Marius

Hello Community, after reading the tutorials below: Build reports based on XML datasource using the iReport DesignerXML Datasources in Jaspersoft StudioXML DatasourcesRemote XML DatasourceUsing XML Datasource in JasperReports ServerI finally get a report with a remote xml data source to run on the server and to output it in the browser using the webservice rest_v2/reports/. What I didn't find in the tutorials, is how to pass a new value for the report parameter XML_URL and what webservice to use for. But it is mentioned something like: Does anybody have experience with passing the xml_url through a webservice and would be nice to point me in a direction? I'm using the JasperReports Server CE 5.2.0 Thank you, Marius

Hi samhast, maybe this and this will help you. Marius

Hello JonReport, - check your JVM startup parameters sudo service tomcat7 status # to find out your pid sudo jmap -J-d64 -heap pid # -J-d64 for a 64-bit System, to print info about heap memory - try to understand environment variables in ubuntu - take a look at the differences between JAVA_OPTS and CATALINA_OPTS - decide how to change the JAVA_OPTS(there are some ways) I do it in /etc/default/tomcat7, e.g.:

added as answer :)

Thank you hishamkmr, yes that is what I missed. So you have finally drag and drop the fields to the Detail 1 part of the report in order to complete the tutorial. Thanks, this helped :)

Thank you vaibhav.lather for your attention! I'll try to give you a little bit more of information. The OS is Windows 7 64 bit. The genereted jrxml is: and it is different and much shorter as the Code Example 3-1 from iReport Ultimate Guide. I don't know where to find the java code, I found just the .jasper file with the compiled code and uploaded as an attachment. Could that be, that the guide is not anymore updated and that I miss some steps? Would you be nice to give me some hint how to get it working? Thank you Marius

Hello community, I'm trying to start with iReport and when I go through the tutorial "2.10 Creating Your First Report" from the ebook ireport ultimate guide, then I can preview just an empty document with 13 pages. Does anybody have an idea what do i miss? Thank you Marius