JRSwapFileVirtualizer virtualizer = null;
JRXlsExporter xlsExporter;
JasperDesign jd;
JasperReport jr;
JasperPrint jp;
private void export(int index) {
try {
String source = Util.getUtil().getUserDirectory() + "\\reports\\report_stockbalance.jrxml";
Map<String, Object> params = new HashMap<String, Object>();
JRSwapFile swapFile = new JRSwapFile("D:\\pos\\temp\\", 512, 100);
virtualizer = new JRSwapFileVirtualizer(1, swapFile, true);
params.put("datetime", "" + Util.getUtil().formatDate(dtcFrom.getDate()) + " to " + Util.getUtil().formatDate(dtcTo.getDate()));
params.put("total", Util.getUtil().setCommaSeperatedNumbers(networth));
params.put(JRParameter.IS_IGNORE_PAGINATION, true);
params.put(JRParameter.REPORT_VIRTUALIZER, virtualizer);
jd = JRXmlLoader.load(source);
jr = JasperCompileManager.compileReport(jd);
if (index == 0) {
//excel
JFileChooser chooser = new JFileChooser();
String filename = Util.getUtil().getDate() + "_" + Util.getUtil().getCurrentTime24().replace(":", "-");
File f = new File(Util.getUtil().getUserDirectory() + "\\reports_exported\\stock_balance\\" + filename + ".xls");
chooser.setSelectedFile(f);
chooser.setDialogTitle("Specify a file to save");
int option = chooser.showSaveDialog(null);
if (option == JFileChooser.APPROVE_OPTION) {
jp = JasperFillManager.fillReport(jr, params, new JRTableModelDataSource((DefaultTableModel) tblStockBalance.getModel()));
File fileToSave = chooser.getSelectedFile();
xlsExporter = new JRXlsExporter();
xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
xlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, fileToSave.getAbsolutePath());
xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
xlsExporter.exportReport();
}
} else if (index == 1) {
//pdf
JFileChooser chooser = new JFileChooser();
String filename = Util.getUtil().getDate() + "_" + Util.getUtil().getCurrentTime24().replace(":", "-");
File f = new File(Util.getUtil().getUserDirectory() + "\\reports_exported\\stock_balance\\" + filename + ".pdf");
chooser.setSelectedFile(f);
chooser.setDialogTitle("Specify a file to save");
int option = chooser.showSaveDialog(null);
if (option == JFileChooser.APPROVE_OPTION) {
jp = JasperFillManager.fillReport(jr, params, new JRTableModelDataSource((DefaultTableModel) tblStockBalance.getModel()));
File fileToSave = chooser.getSelectedFile();
JasperExportManager.exportReportToPdfFile(jp, fileToSave.getAbsolutePath());
}
}
} catch (Exception e) {
e.printStackTrace();
LogFile.log(getClass().getName(), "export", e.getMessage().toString(), tblStockBalance);
} finally {
if (virtualizer != null) {
virtualizer.cleanup();
}
}
}
Pages
- Home
- Java JasperReport Print JTable Content
- iReport 5.6 Install On MacOS
- PHP Pager
- Java JLable Set Image
- Java Read XML Settings File
- Apple MacOS High Sierra Installation Errors
- Java Read Directory Content
- MySQL Inner Join
- WinRAR Super Compression
- Install Windows 10 from a USB Flash Drive
- Java Classpath Directory
- Java Class To Keep Some Static Variables As A Simp...
- Java Copy Paste
- Java Change Cusor
- Java Read File In To Text Area
- Java Open Any Directory
- Java Open Current Directory
- Java Regex Address
- Java Regex Email
- Java Regex Letters
- Java Regex Name
- Java Text Is Not Empty
- Java Regex AlphaNumeric
- Java Regex Numeric
- Java Combo Box Auto Complete
- Java jFrame Icon
- Java Layout Align Center
- Java JTable Quick Load Heavy Data With Handler Cla...
- Java JTable Column Text Align
- Java JTable Remove Table Headers
- Java JTable Renderer
- Java JTable Search Filter
- Java Log File Writer
- Java MD5 Of A File
- Java MD5 Of A String
- Java BigDecimal
- Java Comma Seperated Numbers
- Java JPasswordField Text Read
- Java Text Fields Auto Select All On Focus
- Java Time As 12h
- Java Time As 24h
- Java Time Current Time Stamp
- Java Util Class
- Java View Pdf
- Java JFrame Maximize
- Java Xml Read With Dom4j
- Java MySQL JDBC Basic Class
- Java MySQL Backup Local
- Java MySQL Backup Online To DropBox API v2
- Java JasperReport Print Directly Without View
- Java JasperReport Print Long Bills With Virtualize...
- Java JasperReport Export To PDF
- Java JasperReport Export To Excel
- Java JasperReport Using All Features
- Java GMail Send Attachment
- MySQL Return 0 If No Data
- Center Aligned JPanel
- Java Splash/Loading Screen
Subscribe to:
Posts (Atom)
No comments:
Post a Comment