[How set PROPERTY_USE_TEMP_FILE in ExcelApiExporter]

 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);...

[How set PROPERTY_USE_TEMP_FILE in ExcelApiExporter]

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

[How set PROPERTY_USE_TEMP_FILE in ExcelApiExporter]

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 set PROPERTY_USE_TEMP_FILE in ExcelApiExporter]

 How to set PROPERTY_USE_TEMP_FILE in JExcelApiExporter ?

[what jar is needed for using jasperReport 3.7.4]

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

 

[MAXIMUM_ROWS_PER_SHEET for XLSX]

JRXlsxExporter allows greater number of rows than 65535 ?

 

[JRXlsxExporter fails to apply FONT_SIZE_FIX]

  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();...

[Problem with SHEET_NAMES parameter]

 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.

 

[Why does my report is being printed that way?]

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.

[Why does my report is being printed that way?]

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.

[Why does my report is being printed that way?]

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

[Why does my report is being printed that way?]

Anybody can help me ?

[Can I modify a field alignment at Runtime ?]

Can I modify a field alignment at Runtime ?

[Why does my report is being printed that way?]

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

[Modifying page orientation]

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);

[Can I modify field align at runtime ?]

Can I modify field align at runtime ?

[Jasper and a Matrix as a data source]

I have a class Matrix defined by an ArrayList of String[ ]. How can I have the Matrix as a table in my report?