Skip to Content
Former Member
Dec 21, 2007 at 09:35 AM

Export Report as CSV/XML


Post Author: mps77

CA Forum: JAVA

Hi all,i inherited a project that integrated CR XI ( in a java client. the user may choose what should be done with the report:view, send as email or export as csv or xml.the last part i have to do now. i got the csv export, but it contains the report title, column header, footer in every line. my code:CharacterSeparatedValuesExportFormatOptions csvOptions = new CharacterSeparatedValuesExportFormatOptions(); csvOptions.setSeparator(tagCfg.getCSVSeparator()); csvOptions.setDelimiter(""); csvOptions.setExportMode(ExportMode.legacyMode); ExportOptions exportOptions = new ExportOptions(); exportOptions.setExportFormatType(ReportExportFormat.characterSeparatedValues); exportOptions.setFormatOptions(csvOptions); FileOutputStream fos = new FileOutputStream(tagCfg.getCSVFilename()); PrintOutputController poc = reportClientDoc.getPrintOutputController(); ByteArrayInputStream bis = (ByteArrayInputStream)poc.export(exportOptions); int read; byte[] buffer = new byte[1024]; while((>-1) { fos.write(buffer); } fos.flush(); fos.close(); bis.close();can i get a resultset or something similar to access the data of the report?thanks for helpregards mps