rinse

Hi, I have downloaded the jasperreports-6.13.0 project and would like to build it and resolve its dependencies. I have installed the latest version of ant and ivy. Running ant compile gives an error: ..J:ComponentsJasperReportsjasperreports-6.13.0>ant compileBuildfile: J:ComponentsJasperReportsjasperreports-6.13.0build.xmlcompile:[ivy:configure] :: Apache Ivy 2.5.0 - 20191020104435 :: https://ant.apache.org/ivy/ ::[ivy:configure] :: loading settings :: file = J:ComponentsJasperReportsjasperreports-6.13.0ivysettings.xml[ivy:cachepath][ivy:cachepath] :: problems summary ::[ivy:cachepath] :::: WARNINGS[ivy:cachepath] ::::::::::::::::::::::::::::::::::::::::::::::[ivy:cachepath] :: UNRESOLVED DEPENDENCIES ::[ivy:cachepath] ::::::::::::::::::::::::::::::::::::::::::::::[ivy:cachepath] :: xml-apis#xml-apis;1.3.04: configuration not found in xml-apis#xml-apis;1.3.04: 'master(compile)'. Missing configuration: 'compile'. It was required from xalan#serializer;2.7.2 compile[ivy:cachepath] :: xerces#xercesImpl;2.9.1: configuration not found in xerces#xercesImpl;2.9.1: 'master(compile)'. Missing configuration: 'compile'. It was required from xalan#xalan;2.7.2 optional[ivy:cachepath] ::::::::::::::::::::::::::::::::::::::::::::::[ivy:cachepath][ivy:cachepath][ivy:cachepath] :: USE VERBOSE OR DEBUG MESSAGE LEVEL FOR MORE DETAILSBUILD FAILEDJ:ComponentsJasperReportsjasperreports-6.13.0build.xml:17: impossible to resolve dependencies: resolve failed - see output for details..[/code] What should I do? Thanks in advance

Thanks I see the problem

Hi, When printing the report to an excel file not all column titles are printed. Attached you will find the .jrxml file, a .pdf export of the report with column titles. And the .xls export with only one column title (Status). leave.zip Any idea how to fix this? Thanks.

Hi, I don't understand the ' please mark the jrxml comment as correct so that it can be resolved ' but it I now see the problem. Thanks.

Thanks it works, but I don't understand. I see you have added some lines like this: <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> Could you explain it? Could I find it in a any document? I also noticed I have less columns. In the old jrxml there was next to each column a very small column. Is there a expaination for this? I actually need to generate the jrxml using the JasperDesign API from java code. How should I do that? I noticed you sometimes added both properties (...unit.x and ...unit.width), but sometimes you have added one of theme. How should I know which one is missing? Thanks for all the help!

All files needed (inlcuded the .jrxml ) to reproduce the problem are in the attachment myreport.zip.

Hi, Thanks for your suggestion, but it is not true. The column is visible in the excelgrid. (It is column M). But the data is missing except for the group totalization row. Here is the excel export: Saldo.xls

I have got a report. When I run the preview all columns are visible in the preview. But when I save it to a xls/xlsx file, one of the columns is missing the data. Do you have got any idea's why or how to fix that? All related project files can be downloaded from here: myreports.zip Thanks

Hi, I am facing the same issue. I have followed the tutorial from http://community.jaspersoft.com/wiki/tables-and-crosstabs-jaspersoft-studio . The tutorial uses the sample database and then it works. Now I (and the original poster also) want to know how a table can be used with a csv file. In the next example I have got a report which uses a csv file as datasource. I also want to have some extra details in the summary. Therefore I want to use a table, which must use the same csv file datasource. I have created the dataset with query string csv. The Dialog "dataset and query" can connect to the csv file and shows the data at the Date preview tabs (in jaspersoft studio). So you should think the dataset is correct connected. When printing a preview the table was not printed. It looks like the table was not printed, because he thinks the dataset is empty. To force the table to print I have set the property "When No Data type" to "All sections No Detail". Now the table (Header and footer) is printed, but the content remains empty. I have got a test report to show the problem: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --><!-- 2016-11-21T16:12:00 --><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="Factuur_Customer name 0" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isSummaryWithPageHeaderAndFooter="true" uuid="013c93eb-5427-4be1-91cc-20de31640e40"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="TestDataAdapter.xml"/> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Dataset1" uuid="d5e1b818-d16c-4a48-b7e0-aec9506fa8c4"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Factuur_DataAdapter.xml"/> <parameter name="net.sf.jasperreports.csv.source" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_INPUT_STREAM" class="java.io.InputStream" isForPrompting="false"/> <parameter name="CSV_URL" class="java.net.URL" isForPrompting="false"/> <parameter name="CSV_FILE" class="java.io.File" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.encoding" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_READER" class="java.io.Reader" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.column.names" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_COLUMN_NAMES_ARRAY" class="java.lang.String[]" isForPrompting="false"/> <parameter name="CSV_DATE_FORMAT" class="java.text.DateFormat" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.date.pattern" class="java.lang.String" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.field.delimiter" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_NUMBER_FORMAT" class="java.text.NumberFormat" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.number.pattern" class="java.lang.String" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.record.delimiter" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_USE_FIRST_ROW_AS_HEADER" class="java.lang.Boolean" isForPrompting="false"/> <parameter name="CSV_LOCALE" class="java.util.Locale" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.locale.code" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_TIMEZONE" class="java.util.TimeZone" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.timezone.id" class="java.lang.String" isForPrompting="false"/> <queryString language="csv"> <![CDATA[]]> </queryString> <field name="DESCRIPTION" class="java.lang.String"/> <field name="TARIFF" class="java.lang.String"/> <field name="VAT" class="java.lang.String"/> <field name="VATAMOUNT" class="java.lang.String"/> <field name="UNITPRICE" class="java.lang.String"/> <field name="QUANTITY" class="java.lang.String"/> </subDataset> <parameter name="DECIMAL_SEPARATOR" class="java.lang.Character" isForPrompting="false"> <defaultValueExpression><![CDATA[',']]></defaultValueExpression> </parameter> <parameter name="DATE_PATTERN" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["dd-MM-yyyy"]]></defaultValueExpression> </parameter> <parameter name="TIME_PATTERN" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["H:mm"]]></defaultValueExpression> </parameter> <parameter name="INV_NUMBER" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="INV_DATE" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="INV_ADDRESS" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="INV_REFERENCE" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="CUSTOMER_NAME" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="CUSTOMER_DEBNO" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="net.sf.jasperreports.csv.source" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_INPUT_STREAM" class="java.io.InputStream" isForPrompting="false"/> <parameter name="CSV_URL" class="java.net.URL" isForPrompting="false"/> <parameter name="CSV_FILE" class="java.io.File" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.encoding" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_READER" class="java.io.Reader" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.column.names" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_COLUMN_NAMES_ARRAY" class="java.lang.String[]" isForPrompting="false"/> <parameter name="CSV_DATE_FORMAT" class="java.text.DateFormat" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.date.pattern" class="java.lang.String" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.field.delimiter" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_NUMBER_FORMAT" class="java.text.NumberFormat" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.number.pattern" class="java.lang.String" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.record.delimiter" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_USE_FIRST_ROW_AS_HEADER" class="java.lang.Boolean" isForPrompting="false"/> <parameter name="CSV_LOCALE" class="java.util.Locale" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.locale.code" class="java.lang.String" isForPrompting="false"/> <parameter name="CSV_TIMEZONE" class="java.util.TimeZone" isForPrompting="false"/> <parameter name="net.sf.jasperreports.csv.timezone.id" class="java.lang.String" isForPrompting="false"/> <field name="DESCRIPTION" class="java.lang.String"/> <field name="TARIFF" class="java.lang.Double"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <pageHeader> <band height="52"/> </pageHeader> <columnHeader> <band height="16"> <frame> <reportElement mode="Opaque" x="40" y="0" width="515" height="16" backcolor="#E8E8E8" uuid="7c742394-2348-404b-8468-8060b217a3f0"/> <box> <bottomPen lineWidth="1.0" lineColor="#C0C0C0"/> </box> <textField isStretchWithOverflow="true"> <reportElement x="435" y="0" width="80" height="16" forecolor="#000000" uuid="1fc4665a-d935-4361-a729-883b58d44b1a"/> <box topPadding="2" leftPadding="3" bottomPadding="2" rightPadding="3"/> <textElement textAlignment="Right"> <font fontName="Arial" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Bedrag"]]></textFieldExpression> </textField> </frame> </band> </columnHeader> <detail> <band height="21"> <frame> <reportElement x="40" y="0" width="435" height="16" uuid="caa61f36-2373-4f1b-83a9-1bdaaf969315"/> <box> <bottomPen lineWidth="1.0" lineColor="#E8E8E8"/> </box> <textField isStretchWithOverflow="true"> <reportElement x="0" y="0" width="435" height="16" forecolor="#000000" uuid="04492601-0f29-4381-aad3-521be28a6d7b"/> <box topPadding="2" leftPadding="3" bottomPadding="2" rightPadding="3"/> <textElement textAlignment="Left" markup="html"> <font fontName="Arial" size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{DESCRIPTION}]]></textFieldExpression> </textField> </frame> <textField> <reportElement x="475" y="0" width="80" height="16" uuid="152bfdf9-599f-49cd-a4a3-c5a278fb0edb"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$F{TARIFF}]]></textFieldExpression> </textField> </band> </detail> <pageFooter> <band height="26"/> </pageFooter> <summary> <band height="338" splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <componentElement> <reportElement x="40" y="10" width="270" height="120" uuid="1a912e0f-f66f-453c-842b-c5ae31615695"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.components.autoresize.proportional" value="true"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="Dataset1" uuid="c55cf82a-b6ec-440b-8444-fdf195c3af5f"> <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRCsvDataSource) $P{REPORT_DATA_SOURCE})]]></dataSourceExpression> </datasetRun> <jr:column width="135" uuid="c392b946-d762-48bf-9fc5-dbeefb8fbc5c"> <jr:columnHeader style="Table_CH" height="20"> <staticText> <reportElement x="0" y="0" width="135" height="20" uuid="467f7255-7fc0-413b-aa23-74327d49c05c"/> <text><![CDATA[DESCRIPTION]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="20"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="135" height="30" uuid="5b02c5eb-0e8c-4a3c-a70e-77d8efffd644"/> <textFieldExpression><![CDATA[$F{DESCRIPTION}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="135" uuid="5ec9dafe-1e97-495a-b983-a33a60cbe377"> <jr:columnHeader style="Table_CH" height="20"> <staticText> <reportElement x="0" y="0" width="135" height="20" uuid="aa0f6ea6-24f7-4885-8e66-ebffa5a9c203"/> <text><![CDATA[TARIFF]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="20"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="135" height="30" uuid="ecc9f93f-4d1e-4ab3-aa6c-0037ee30132f"/> <textFieldExpression><![CDATA[$F{TARIFF}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </summary></jasperReport>[/code] And this is my data adapter: <?xml version="1.0" encoding="UTF-8" ?><csvDataAdapter class="net.sf.jasperreports.data.csv.CsvDataAdapterImpl"><name>Test data adapter</name><dataFile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="repositoryDataLocation"><location>TestData.csv</location></dataFile><recordDelimiter> </recordDelimiter><fieldDelimiter>,</fieldDelimiter><useFirstRowAsHeader>true</useFirstRowAsHeader><locale xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:java="http://java.sun.com" xsi:type="java:java.lang.String">nl_NL</locale><timeZone xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:java="http://java.sun.com" xsi:type="java:java.lang.String">Europe/Berlin</timeZone><datePattern>yyyy-MM-dd H:mm:ss</datePattern><numberPattern>#.#</numberPattern><queryExecuterMode>false</queryExecuterMode><columnNames>DESCRIPTION</columnNames><columnNames>TARIFF</columnNames><columnNames>VAT</columnNames><columnNames>VATAMOUNT</columnNames><columnNames>UNITPRICE</columnNames><columnNames>QUANTITY</columnNames></csvDataAdapter>[/code] And this is my csv file: "DESCRIPTION","TARIFF","VAT","VATAMOUNT","UNITPRICE","QUANTITY""Artikel 1 omschrijving","100.0","21.0","21.0","100","1""Artikel 2 omschrijving","200.0","21.0","42.0","100","2""Artikel 2 omschrijving","200.0","21.0","42.0","100","2""Artikel 2 omschrijving","200.0","21.0","42.0","100","2""Artikel 2 omschrijving","200.0","21.0","42.0","100","2""Artikel 2 omschrijving","200.0","21.0","42.0","100","2"[/code]Someone a solution? Thanks.

Just checking if we do understand this right... JasperReports is able to use all fonts available on the system and print them to a physical printer (or preview the report) If the report has to be printed to a pdf, the usage of fonts is limited to only the fonts which are provided as a jasperreport font extension. (This sounds weird to us as the developer now has to provide fonts in the jar which are already available on the system, also the legal aspect is a problem)

Hi, Thanks for your suggestion. But I don't see a max height property of a band either. I believe, it is only possible to set it to a fixed height. Perhaps I should clarify myself: I would like to have a default row height of 1 line of text. Only when the text does not fit it should wrap and stretch the textfield his height. So far it worked with the stretchwithoverflow property set to true, but I would like to limit it to a max height. Any suggestions?

Hi, We would like to give a textfield a max height if setStretchWithOverflow is enabled. Is that posible?

Hi, I would like to have a report using encoding Cp1252. I create a JasperDesign using the API and write to jrxml using this function: JRXmlWriter.writeReport( jasperDesign, "test.jrxml", "CP1252" ); All went fine, the report seems to use the correct encoding, because special chars are displayed correct. Only when I try to edit the report in JasperSoft studio an SAXParseException occurs: Invalid encoding name "CP1252" Any ideas how to use Cp1252 in JasperSoft studio?

Hi, Before jasperreports 5.6.0 you could download a jar separately: jasperreports-functions-5.5.0.jar I just updated to 5.6.0 and did not found a new version of the functions jar. I took jasperreports-functions-5.6.0-SNAPSHOT.jar from jaspersoft studio now. I don't know if it is the right way. but it works for me. Just add it to your buildpath

Hi, Thanks for your answer. I have got it working. Now, I want to have a cutom function added. I tried to follow this page: http://community.jaspersoft.com/wiki/jaspersoft-studio-expression-editor-how-extend-it-and-contribute-your-own-functions-part-2 , but it is very out dated. I can't get through it. The annotations are not valid any more and I don't understand how the property file should look like. Also the package names does not exists any more. Does any one have a working CustomFunction example? Thanks.

Hi, I would like to create a report with Jaspersoft Studio. We will deploy reports (*.jrxml) with our application. We will run the report using the jasperreport API from our application. When we use a built-in function (e.g. WEEKDAY()) and run the report in our application there comes an error: The method WEEKDAY(Date) is undefined for the type... How can we use Jaspersoft Studio's built-in functions and run them using the jasperreport API? Thanks, Olaf

Hi, No I don't.

Hi, I am using JRXhtmlExporter to export a jasper report to a html output. The html output becomes quit big very soon. There is a lot of css code arround every item. Is there a way to optimze the output? By using predfined css in the head for example? Thanks in advance for a reply.

I found a workarround. The .jasper file gets an internal name derived from the filename. When the filename contains sub-directories, the name of the jasper report also gets sub-directories. The name property is used to create the .jrprint filename. When the name contains sub-directories ot doubles the parent directorie in its filname. By setting the name of jasperDesign with the filename (without parent directories) it works. So in the case above jasperDesign.setName( "test" ); will fix this issue

Changed Assigned User from @User_306070 to @anonymous Editting the bugreport failes: I get an error: The referenced entity (user: 306070) is invalid.***EDIT: It can't work with subdirectoriesWhen I give reportsFileBaseName a relative subdir like this:String _reportsFileBaseName = "temp\\reports\\test"JasperFillManager.fillReportToFile() raises an error: Error saving file : temp\reports\temp\reports\test.jrprintthe files temp\reports\test.jrxml and temp\reports\test.jasper are created as expected****

Changed Priority from Normal to High Changed Severity from Minor to Major Changed Assigned User from - to @User_306070