Examples with JRCsvExporter net.sf.jasperreports.engine.export.JRCsvExporter used on opensource projects

Example 1 with JRCsvExporter

use of net.sf.jasperreports.engine.export.JRCsvExporter in project opennms by OpenNMS.

the class AbstractMeasurementQueryExecutorTest method createCsv.

protected void createCsv(JasperPrint jasperPrint, String reportName) throws JRException {
    long start = System.currentTimeMillis();
    SimpleExporterInput input = new SimpleExporterInput(jasperPrint);
    SimpleWriterExporterOutput output = new SimpleWriterExporterOutput(createFileName(reportName, "csv"));
    JRCsvExporter exporter = new JRCsvExporter();
    exporter.setExporterInput(input);
    exporter.setExporterOutput(output);
    exporter.exportReport();
    LOG.info("CSV creation time: {} ms", (System.currentTimeMillis() - start));
}

Example 2 with JRCsvExporter

use of net.sf.jasperreports.engine.export.JRCsvExporter in project jgnash by ccavanaugh.

the class JasperViewerDialogController method handleSaveAction.

@FXML
private void handleSaveAction() {
    Preferences preferences = Preferences.userNodeForPackage(JasperViewerDialogController.class);
    final String lastDir = preferences.get(LAST_DIR, null);
    final FileChooser fileChooser = new FileChooser();
    fileChooser.setTitle(ResourceUtils.getString("Title.SaveFile"));
    if (lastDir != null) {
        fileChooser.setInitialDirectory(new File(lastDir));
    }
    fileChooser.getExtensionFilters().add(new FileChooser.ExtensionFilter("PDF Document", "*.pdf", "*.PDF"));
    fileChooser.getExtensionFilters().add(new FileChooser.ExtensionFilter("ODT Document", "*.odt", "*.ODT"));
    fileChooser.getExtensionFilters().add(new FileChooser.ExtensionFilter("DOCX Document", "*.docx", "*.DOCX"));
    fileChooser.getExtensionFilters().add(new FileChooser.ExtensionFilter("XLSX Document", "*.xlsx", "*.XLSX"));
    fileChooser.getExtensionFilters().add(new FileChooser.ExtensionFilter("CSV Document", "*.csv", "*.CSV"));
    fileChooser.getExtensionFilters().add(new FileChooser.ExtensionFilter("RTF Document", "*.rtf", "*.RTF"));
    final File file = fileChooser.showSaveDialog(MainView.getPrimaryStage());
    if (file != null) {
        preferences.put(LAST_DIR, file.getParent());
        switch(FileUtils.getFileExtension(file.getAbsolutePath()).toLowerCase(Locale.ROOT)) {
            case "pdf":
                try {
                    JasperExportManager.exportReportToPdfFile(jasperPrint.get(), file.getAbsolutePath());
                } catch (final JRException e) {
                    StaticUIMethods.displayException(e);
                }
                break;
            case "odt":
                try {
                    final JROdtExporter exporter = new JROdtExporter();
                    exporter.setExporterInput(new SimpleExporterInput(jasperPrint.get()));
                    exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(file));
                    exporter.exportReport();
                } catch (final JRException e) {
                    StaticUIMethods.displayException(e);
                }
                break;
            case "docx":
                try {
                    final JRDocxExporter exporter = new JRDocxExporter();
                    exporter.setExporterInput(new SimpleExporterInput(jasperPrint.get()));
                    exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(file));
                    exporter.exportReport();
                } catch (final JRException e) {
                    StaticUIMethods.displayException(e);
                }
                break;
            case "xlsx":
                try {
                    final JRXlsExporter exporter = new JRXlsExporter();
                    exporter.setExporterInput(new SimpleExporterInput(jasperPrint.get()));
                    exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(file));
                    final SimpleXlsReportConfiguration configuration = new SimpleXlsReportConfiguration();
                    configuration.setOnePagePerSheet(false);
                    exporter.setConfiguration(configuration);
                    exporter.exportReport();
                } catch (final JRException e) {
                    StaticUIMethods.displayException(e);
                }
                break;
            case "csv":
                try {
                    final JRCsvExporter exporter = new JRCsvExporter();
                    exporter.setExporterInput(new SimpleExporterInput(jasperPrint.get()));
                    exporter.setExporterOutput(new SimpleWriterExporterOutput(file));
                    exporter.exportReport();
                } catch (final JRException e) {
                    StaticUIMethods.displayException(e);
                }
                break;
            case "rtf":
                try {
                    final JRRtfExporter exporter = new JRRtfExporter();
                    exporter.setExporterInput(new SimpleExporterInput(jasperPrint.get()));
                    exporter.setExporterOutput(new SimpleWriterExporterOutput(file));
                    exporter.exportReport();
                } catch (final JRException e) {
                    StaticUIMethods.displayException(e);
                }
                break;
            default:
        }
    }
}

Example 3 with JRCsvExporter

use of net.sf.jasperreports.engine.export.JRCsvExporter in project opennms by OpenNMS.

the class JasperReportService method exportReportToCsv.

private void exportReportToCsv(final JasperPrint jasperPrint, final OutputStream outputStream) throws JRException {
    JRCsvExporter exporter = new JRCsvExporter();
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
    exporter.exportReport();
}

Example 4 with JRCsvExporter

use of net.sf.jasperreports.engine.export.JRCsvExporter in project opennms by OpenNMS.

the class DefaultReportService method saveReport.

private String saveReport(JasperPrint jasperPrint, Report report, String destFileName) throws JRException, Exception {
    createReportCatalogEntry(jasperPrint, report, destFileName);
    String reportName = null;
    switch(Format.valueOf(report.getReportFormat())) {
        case pdf:
            JasperExportManager.exportReportToPdfFile(jasperPrint, destFileName);
            reportName = destFileName;
            break;
        case html:
            JasperExportManager.exportReportToHtmlFile(jasperPrint, destFileName);
            reportName = createZip(destFileName);
            break;
        case xml:
            JasperExportManager.exportReportToXmlFile(jasperPrint, destFileName, true);
            reportName = createZip(destFileName);
            break;
        case csv:
            JRCsvExporter exporter = new JRCsvExporter();
            exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
            exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFileName);
            exporter.exportReport();
            reportName = destFileName;
            break;
        default:
            LOG.error("Error Running Report: Unknown Format: {}", report.getReportFormat());
    }
    return reportName;
}

Example 5 with JRCsvExporter

use of net.sf.jasperreports.engine.export.JRCsvExporter in project midpoint by Evolveum.

the class ReportCreateTaskHandler method generateReport.

private String generateReport(ReportType reportType, JasperPrint jasperPrint) throws JRException {
    String destinationFileName = getDestinationFileName(reportType);
    switch(reportType.getExport()) {
        case PDF:
            JasperExportManager.exportReportToPdfFile(jasperPrint, destinationFileName);
            break;
        case XML:
            JasperExportManager.exportReportToXmlFile(jasperPrint, destinationFileName, true);
            break;
        case XML_EMBED:
            JasperExportManager.exportReportToXmlFile(jasperPrint, destinationFileName, true);
            break;
        case XHTML:
        case HTML:
            JasperExportManager.exportReportToHtmlFile(jasperPrint, destinationFileName);
            break;
        case CSV:
            JRCsvExporter csvExporter = new JRCsvExporter();
            csvExporter.setExporterInput(new SimpleExporterInput(jasperPrint));
            csvExporter.setExporterOutput(new SimpleWriterExporterOutput(destinationFileName));
            csvExporter.exportReport();
            break;
        case RTF:
        case XLS:
        case ODT:
        case ODS:
        case DOCX:
        case XLSX:
        case PPTX:
        case JXL:
            ExporterInput input = new SimpleExporterInput(jasperPrint);
            ExporterOutput output = new SimpleOutputStreamExporterOutput(destinationFileName);
            Exporter exporter = createExporter(reportType.getExport());
            if (exporter == null) {
                break;
            }
            exporter.setExporterInput(input);
            exporter.setExporterOutput(output);
            exporter.exportReport();
            break;
        default:
            break;
    }
    return destinationFileName;
}