r3n4n

I also tried to enable this option as follows (no success): Code:...jasperReport = JasperCompileManager.compileReport(sourceFileName);jasperReport.setProperty(JExcelApiExporter.PROPERTY_USE_TEMP_FILE, "true");jasperPrint = JasperFillManager.fillReport(jasperReport, paramMap, ds);...

Yes, I tried that. But did not work. At no time was created temporary files in the execution of my report.

The change in my jrxml below is correct? Code:<?xml version="1.0" encoding="UTF-8"?><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="consistenciaDado" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20"> ... <property name="net.sf.jasperreports.export.jxl.use.temp.file" value="true"/> ...</jasperReport>

How to set PROPERTY_USE_TEMP_FILE in JExcelApiExporter ?

Try: commons-beanutils-1.8.0.jar commons-collections-2.1.1.jar commons-digester-1.7.jar commons-logging-1.0.4.jar groovy-all-1.5.5.jar iText-2.1.7.jar

JRXlsxExporter allows greater number of rows than 65535 ?

Even if I set JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED for JRXlsxExporter, the font size don't change. * JRXlsExporterParameter.SHEET_NAMES also fails. ...JRXlsxExporter exporter = new JRXlsxExporter();exporter.setParameter( JRExporterParameter.JASPER_PRINT_LIST, jprintList);exporter.setParameter( JRExporterParameter.CHARACTER_ENCODING, "UTF-8" );exporter.setParameter( JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);exporter.setParameter( JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);exporter.setParameter( JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);exporter.setParameter( JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED, Boolean.TRUE);exporter.setParameter( JRXlsExporterParameter.MAXIMUM_ROWS_PER_SHEET, MAX_ROWS_PER_SHEET);exporter.setParameter( JRXlsExporterParameter.SHEET_NAMES, arraySheetNames);exporter.setParameter( JRXlsExporterParameter.OUTPUT_STREAM, bos);exporter.exportReport();...

I set the parameter SHEET_NAMES: exporter.setParameter(JExcelApiExporterParameter.SHEET_NAMES, new String[]{"Report0","Report1","Report2"}); And the parameter JASPER_PRINT_LIST with my printList with three JasperPrint elements: exporter.setParameter(JExcelApiExporterParameter.JASPER_PRINT_LIST, printList); But the three sheets, only the first is renamed according to the parameter SHEET_NAMES.

The problem was the use of division of 'Columns' in 'Page format'. I was using division of columns according to the number of columns in my table. Now I divide the page in one column and do the division of the columns of my table manually.

The problem was the use of division of 'Columns' in 'Page format'. I was using division of columns according to the number of columns in my table. Now I divide the page in one column and do the division of the columns of my table manually.

See attachment. I have a table with 8 columns and 100 rows in a subreport (inside 'Detail' from main report). - Main Report and Subreport Properties: * Print Order: Vertical * Ignore Pagination: Unchecked - Main Report and Subreport Band Properties: * Split Type: Stretch * Split Allow: Checked

Anybody can help me ?

Can I modify a field alignment at Runtime ?

I have a table with 8 columns and 100 rows in a subreport (inside 'Detail' from main report). - Main Report and Subreport Properties: * Print Order: Vertical * Ignore Pagination: Unchecked - Main Report and Subreport Band Properties: * Split Type: Stretch * Split Allow: Checked Post Edited by r3n4n at 09/21/2009 17:48

I'm trying modify the page orientation at runtime, but the following code doesnt work. Any idea ? Code:JasperDesign jasperDesign = JRXmlLoader.load(reportsBaseDir + "my_report.jrxml");jasperDesign.setOrientation(JasperDesign.ORIENTATION_LANDSCAPE);jasperReport = JasperCompileManager.compileReport(jasperDesign);