Jump to content
We've recently updated our Privacy Statement, available here ×

klaytoncbrito

Members
  • Posts

    3
  • Joined

  • Last visited

klaytoncbrito's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hello, Is it possible for a image with height bigger than the page's height to split it between pages in a PDF file? I need to show that image before the column header (I put the image in the title band), and the image is shrank in a single page. If it's not possible, could I use a parameter with a array of inputstreams with splitted pieces of a image and show them like detail band in the title band? Thanks
  2. Hi, I'd like to know if there is a way to make rectangles with dynamic size by parameter/field value, my scenario is a kind of a graph where each segment of a bar represent a percentage, and I hoped to use rectangles but I haven't found any way to set their sizes (or any solution that could help me to do anything similar):
  3. Hello, I'm working on a legacy project and I'm having an issue with exporting XLSX file format using Jasper Library, where the resulting XLSX file doesn't have any excel formulas. I've tested changing the Java code to export to XLS and It works, the XLS file has the excel formulas. The project I'm working on use the Jasper of version 3.7.3. But I really need to export XLSX instead of XLS. XLSX file with missing formulas: XLS file with formulas: JRXML field: <textField isBlankWhenNull="true"> <reportElement mode="Opaque" x="229" y="0" width="50" height="12" backcolor="#E6E6E5"> <propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA["=A1"]]></propertyExpression> </reportElement> <box> <bottomPen lineWidth="1.0" lineStyle="Solid"/> <rightPen lineWidth="1.0" lineStyle="Solid"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> <font fontName="Monospaced" size="8" isBold="true" pdfFontName="Courier-Bold"/> </textElement> </textField> Java code: final var jasperPrint = JasperFillManager.fillReport(jasperTemplate, parameters, dataSource); final var xlsxExporter = new JRXlsExporter(); //final var xlsxExporter = new JRXlsxExporter(); xlsxExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); xlsxExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, output); xlsxExporter.setParameter(JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xlsxExporter.exportReport(); I'm also using: <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/> UPDATE I've talked with my boss and between update the jasper version or using XLS they chose using XLS
×
×
  • Create New...