sharkoff76

Hello i get date from oracle and whant to see after in Excel this date in format dd.mm.yyyy and value in Excel must to be Date fromat Please help.. i try many ways. But useless

Hello! I have huge report which generated in XLSX format. Count of rows over 3 000 000 For correct all rows divided by some principal and i get many pages in Excel . On every page count rows < 1 000 000 So i made it this way: In SQL request i make Page-switcher like this <field name="PAGER_NEW" class="java.lang.String"/> ... <variable name="Var1" class="java.lang.String"/> .. <textField> <reportElement x="1020" y="0" width="10" height="15" forecolor="#FFFFFF" uuid="73246961-8f9a-45f4-8991-b5352aaf31b3"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/> <printWhenExpression><![CDATA[$F{PAGER_NEW}.equals("1")]]></printWhenExpression> </reportElement> <textFieldExpression><![CDATA[$V{Var1}]]></textFieldExpression> </textField> So work perfect but I want header on every page will the same Like Page0 - header - detail data Page1 - header - detail data PageN - header - detail data Now : Page0 - header - detail data Page1 - detail data PageN - detail data How i can do it?

Hello! Im using jasperstarter as wrapper JasperLibrary I found strange result. When i run report with params java -Xmx4g -XX:+UseG1GC -jar lib/jasperstarter.jar --locale ru pr ~/1.jrxml -f xlsx -F ~/param.xml -t generic -u xxx-p xxx -o - --db-driver oracle.jdbc.driver.OracleDriver --db-url jdbc:oracle:thin:@//some_ora_server:1521/someSid > 1_std.xlsx and java -Xmx4g -XX:+UseG1GC -jar lib/jasperstarter.jar --locale ru pr ~/1.jrxml -f xlsx -F ~/param.xml -t generic -u xxx-p xxx -o ~/ - --db-driver oracle.jdbc.driver.OracleDriver --db-url jdbc:oracle:thin:@//some_ora_server:1521/someSid I get 2 xlsx file - and they are different . IMHO this files must equal. but they different I go to source code jasperstarter public void exportXlsx() throws JRException { Map<String, String> dateFormats = new HashMap<String, String>(); dateFormats.put("dd.MM.yyyy", "ddd, mmm dd, yyyy"); JRXlsxExporter exporter = new JRXlsxExporter(); SimpleXlsxReportConfiguration repConfig = new SimpleXlsxReportConfiguration(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(getOutputStream(".xlsx"))); repConfig.setDetectCellType(Boolean.TRUE); repConfig.setFormatPatternsMap(dateFormats); exporter.setConfiguration(repConfig); exporter.exportReport(); } Export in xlsx fire up only exportXlsx. Where & how i can find problem? I have to use stdout export but now this generate failed XLSX. Excel say it can recover my file (which is go via stdout) and can do this. But i dont like this.. Help me please! PS I'm using JasperStarter 6.16 I

Hello I have Office 365 and ALL report generated by JasperLibrary 6.16 with XLSX format incorrect. I try open xlsx files with Office 2016 and investigate problem is on xldrawings 1. When i remove directory xldrawings from zip of xlsx it can be open with Office 2016 but not Office 365 2 My report's have NO any drawing 3. When i try open by Office 365 xlsx (xldrawings NOT Deleted ) Excel CAN recover xlsx but it takes long long time (Huge report!) How i can get NORMAL XLSX?

Hello By the way, XLSX is archive file, so when i unarchive file i see "unexpected end file" . Seem to be file was corrupted. But after recover process file is good

So for generation i use jasperStarter public void exportXlsx() throws JRException { Map<String, String> dateFormats = new HashMap<String, String>(); dateFormats.put("EEE, MMM d, yyyy", "ddd, mmm d, yyyy"); JRXlsxExporter exporter = new JRXlsxExporter(); SimpleXlsxReportConfiguration repConfig = new SimpleXlsxReportConfiguration(); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(getOutputStream(".xlsx"))); repConfig.setDetectCellType(Boolean.TRUE); repConfig.setFormatPatternsMap(dateFormats); exporter.setConfiguration(repConfig); exporter.exportReport(); }

Hello Im using library jasperreports-6.16.0 jar for generate huge xlsx report. When i open file with xlsx i get warning : I open errr log What's happend and where i have to check code? After Excel check i can save report and i see it's OK. Please help!

Hello Im using jasperreport-6.16.0 & JasperStarter (for launch from command line) compiled with jasperreport-6.16.0 So with jrxml with huge amount row (test example) Im getting sometime: