szaharia

By default page footers are excluded from the Excel export. To change this behavior, you need to set this property in your JRXML file: <property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value=""/>[/code]This will override the net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter setting in the jasperreprts.properties file.

Hi, In order to be properly evaluated, the variable ReportName should be placed after reportTitleA and reportTitleB. You also need to set the initial value expressions for all variables: <variable name="reportTitleA" class="java.lang.String"> <variableExpression><![CDATA["Report A"]]></variableExpression> <initialValueExpression><![CDATA["Report A"]]></initialValueExpression> </variable> <variable name="reportTitleB" class="java.lang.String"> <variableExpression><![CDATA["Report Other"]]></variableExpression> <initialValueExpression><![CDATA["Report Other"]]></initialValueExpression> </variable> <variable name="ReportName" class="java.lang.String"> <variableExpression><![CDATA[$P{ReportType}.equals("A")? $V{reportTitleA}:$V{reportTitleB}]]></variableExpression> <initialValueExpression><![CDATA[$P{ReportType}.equals("A")? $V{reportTitleA}:$V{reportTitleB}]]></initialValueExpression> </variable>[/code]

You could use a report scriptlet to create a String [value1|value2|value3|.....] parameter based on your input control. For guidance see http://community.jaspersoft.com/wiki/jasperreports-library-tutorial#Scriptlets and http://jasperreports.sourceforge.net/sample.reference/scriptlet/index.html#scriptlet

Hi, to get this behavior, set the net.sf.jasperreports.text.truncate.at.char property to true for your text field. See http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.text.truncate.at.char

The JRXlsxExporter provides XLSX output documents that should be saved with the ".xlsx" extension. In your example the Excel document is saved as "test.xls", therefore the ".xls" file extension does not properly match the file content. Try to export it as "test.xlsx" instead: resp.setHeader("Content-Disposition", "attachment;filename="test.xlsx"");

This kind of issues may have various causes, such as wrong defined names, improper formula results, wrong local anchor names, etc. In order to identify the cause here, please post the JRXML file, and if possible, the generated XLSX workbook.

Hi, Another way to set dynamic styles for report elements is to make use of style feature properties at element level. More on these properties you can find out here: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.style.{style_property_suffix}

Hi, You could place a large textfield with an appropriate printWhenExpression when values are equal, and 2 smaller textfields with another printWhenExpression when values are different.

In this case keep the <initialValueExpression/> as it is, and set the <valueExpression /> of the variable with the same value as in <initialValueExpression/>. The evaluation time of the image element could be left as "Page". Other appropriate values for the evaluation time are "Now" and "Auto". Regards, Sanda

In case you are using the Jaspersoft Studio IDE, you can find several interesting tutorials and related documentation here: http://community.jaspersoft.com/project/jaspersoft-studio/resources Regards, Sanda

Hi, Try to set Reset Type = "Page" for your variable.

Hi, CSV output format does not support multisheet layout. Try to export to XLSX or XLS instead. You could set the net.sf.jasperreports.export.xls.ignore.text.formatting property to true in order to ignore text formatting (meaning text color, bold style, etc), like in a CSV output. Also, set the net.sf.jasperreports.export.xls.one.page.per.sheet property to true to get a multisheet document. Regards, Sanda

Changed Status from Resolved to Closed

Changed Resolution from Open to Fixed Changed Status from Acknowledged to Resolved Fixed. Support for 'type' and 'start' attributes was introduced and will be available in the upcoming JasperReports release.

Hi, Try to upgrade to the current version (6.3) and use the same page zoom in both PDF document and Jasper viewer. Regards, Sanda

Hi, In this case you should use data grouping. Create a group for each category type, each group having header and footer. Print the category name in group header, and use report variables to print total values in group footers. More information about data grouping is available here. Regards, Sanda

There is no 'minHeightToStartNewPage' attribute in case of subreports. However, you could set the desired height for the subreport element in the main report and also set subreport element's 'isPrintInFirstWholeBand' attribute to true. Regards. Sanda

Hi, Usually, this kind of errors are related to the report design. Overlapping elements in the report template are ignored in grid-layout-based exporters. Unlike PDF, the Excel exporter does not support the absolute positioning of the elements. In case elements are improperly aligned, some of them might be excluded from the export (see the explanation here). To solve this, create an appropriate layout for your report, ensure there are no overlapping or misaligned elements, and then run the report again. Regards, Sanda

Changed Resolution from Open to Won't Fix Changed Status from Feedback Requested to Closed Closing this, since there are no case updates. In case of new information, it should be reopened.

Changed Resolution from Open to Works as Designed Changed Status from New to Resolved Changed Assigned User from @teodord to @shertage Values for properties like- net.sf.jasperreports.export.xls.sheet.header.left- net.sf.jasperreports.export.xls.sheet.header.center- net.sf.jasperreports.export.xls.sheet.header.rightand - net.sf.jasperreports.export.xls.sheet.footer.left- net.sf.jasperreports.export.xls.sheet.footer.center- net.sf.jasperreports.export.xls.sheet.footer.rightcan be set using the following predefined 'element' expressions:&P - the current page number&N - the total number of pages&D - the current date&T - the current time&A - the sheet name&F - the file name&Z - the file path

Changed Status from Resolved to Closed

Hi, Take a look at the properties below, maybe you could find them useful in this case: net.sf.jasperreports.export.xls.fit.heightnet.sf.jasperreports.export.xls.fit.widthnet.sf.jasperreports.export.xls.page.scaleI hope this helps, Sanda

The MS Excel format specifications indicate a limitation of hyperlinks number per sheet, indeed. To disable all hyperlinks in the Excel document you could use the following property: net.sf.jasperreports.export.xls.ignore.hyperlink = true in your JRXML. Altenatively, you can handle each hyperlink separately by using a hyperlink parameter with the same name as the property above, in order to make some of them disabled while the other are enabled. More information about this export property/parameter you can find here: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.ignore.hyperlink I hope this helps, Sanda

Hi, The built-in str() function is an equivalent of the the $R{} syntax in i18n report expressions, so you don't need it here. If $F{VIL_DT} is of type java.lang.String, use $F{VIL_DT}.substring(0,3)[/code]in your expression. Otherwise, use $F{VIL_DT}.toString().substring(0,3)[/code]Regards, Sanda

Hi, In case your report is based on JFreeCharts, try with an xyBarChart instead of simple barChart, and set tickLabelMask="MMM" for the axisFormat in the categoryAxisFormat element. An useful example can be found in the JR charts sample (see the XYBarChartTimeSeriesReport.jrxml file in the /demo/samples/charts/reports/ directory in the src distro). I hope this helps, Sanda