Jump to content


  • Posts

  • Joined

  • Last visited

mariuss's Achievements

  1. with a blank template you have to drag and drop the fields on your design view (detail band)
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  • Create New...