ErgoTechWiki

User Tools

Site Tools

Trace: • MIStudio and TransSECS Reporting: Introduction to Jasper Reports
gettingstartedwithjasperreports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
gettingstartedwithjasperreports [2022/01/05 18:52] – [Running the SimpleReport in MIStudio] wikiadmingettingstartedwithjasperreports [2022/01/05 20:09] (current) – [Generate a Spreadsheet from SimpleReport] wikiadmin
Line 240: Line 240:
 This is an extension of the Tutorial 1: Simple Report Design and Test Example. If you want to skip Tutorial 1, you can get the set of files needed to run Tutorial 2 [[https://www.ergotech.com/files/examples/jasperreports/JasperReportsTutorial1FilesForTutorial2.zip|here]]. This is an extension of the Tutorial 1: Simple Report Design and Test Example. If you want to skip Tutorial 1, you can get the set of files needed to run Tutorial 2 [[https://www.ergotech.com/files/examples/jasperreports/JasperReportsTutorial1FilesForTutorial2.zip|here]].
  
 +The purpose of this Tutorial is to show you how to use the compiled SimpleReport JasperReport project built with Jaspersoft Studio in Tutorial 1 to generate a PDF report in MIStudio.
  
 +===Setting Up===
 +
 +If you do not have MIStudio Plus Reporting installed please do this step first.
 +
 +You will need these files from the SimpleReport project in Tutorial 1: the compiled report SimpleReport.jasper, the database SimpleSQLiteTest.sqlite, the SQLite driver jar (i.e., sqlite-jdbc-3.30.1.jar or similar), and the exported data adapter definition SQLiteTestDatabase.xml. Put all of these files into the MIStudioSuite/MIStudio directory of your installation (so in the root of the MIStudio folder). 
 +
 +You will need to edit the SQLiteTestDatabase.xml file in a text editor (Notepad++ or similar) to remove the hard-coded paths to the database file and the driver jar. It should look similar to this, with the correct name for your SQLite driver jar:
 +
 +<code xml>
 +<?xml version="1.0" encoding="UTF-8" ?>
 +<jdbcDataAdapter class="net.sf.jasperreports.data.jdbc.JdbcDataAdapterImpl"><name>SQLite Test Database</name><driver>org.sqlite.JDBC</driver><username></username><password></password><savePassword>true</savePassword><url>jdbc:sqlite:SimpleSQLiteTest.sqlite</url><database></database><serverAddress></serverAddress><classpath>sqlite-jdbc-3.30.1.jar</classpath></jdbcDataAdapter>
 +</code>
 +
 +You will also need the DynamicJasper.jar in your MIStudio lib directory, which is installed with the Jasper Reports module for MIStudio.
 +
 +===MIStudio SimpleReport Project===
 +
 +Start MIStudio and create a new project, SimpleReport. Add a button to the design window and copy this to the diagram window. Label this button "Generate PDF". In the Diagram Window, add a JavaScript Bean. Connect the Button to the trigger of the JavaScript.
 +
 +Copy and paste this script to the JavaScript bean:
 +
 +<code javascript>
 +
 +//Script to generate a PDF report from SimpleReport.jasper
 +
 +var HashMap = Java.type("java.util.HashMap");
 +var FileInputStream = Java.type("java.io.FileInputStream");
 +var JasperPrint = Java.type("net.sf.jasperreports.engine.JasperPrint");
 +var JasperFillManager = Java.type("net.sf.jasperreports.engine.JasperFillManager");
 +var JasperExportManager = Java.type("net.sf.jasperreports.engine.JasperExportManager");
 +
 +compiledReport="SimpleReport.jasper";
 +outputName = "SimpleReport.pdf";
 +
 +try {
 +        reportStream = new FileInputStream(compiledReport);
 +        parameters = new HashMap(); //empty hashmap  (no parameters)      
 +        jasperPrint = JasperFillManager.fillReport( reportStream , parameters);
 +        JasperExportManager.exportReportToPdfFile(jasperPrint,outputName);
 +   
 +    
 +} catch (e) {
 +    print("Error in Run JasperReport script: \n"+e.stack);
 +    print(e);    
 +    
 +}
 +
 +</code>
 +
 +Go to the Test Frame of MIStudio and press the "Generate PDF" button. You will see a pdf called "SimpleReport.pdf" generated in the same directory as the SimpleReport.jasper file (the root MIStudio directory).
  
 <note tip>If you see the error:  <note tip>If you see the error: 
 net.sf.jasperreports.engine.JRRuntimeException: No secret found for "" key in "net.sf.jasperreports.data.adapter" category, you will need to add the JasperReports identity.secrets.jar https://www.ergotech.com/files/extra/identity.secrets.jar to the runtime classpath. This allows database connections to databases, such as the test database, which do not use passwords (clear passwords) </note> net.sf.jasperreports.engine.JRRuntimeException: No secret found for "" key in "net.sf.jasperreports.data.adapter" category, you will need to add the JasperReports identity.secrets.jar https://www.ergotech.com/files/extra/identity.secrets.jar to the runtime classpath. This allows database connections to databases, such as the test database, which do not use passwords (clear passwords) </note>
 +
 +That's the end of this basic Tutorial. You can also generate other report types from this same SimpleReport.jasper file (see code examples below).
 +
 +===Generate a Spreadsheet from SimpleReport===
 +
 +Instead of generating a PDF you can make an xls or xlsx report (excel spreadsheets), or a csv file.
 +
 +To make an xls spreadsheet, use this code in the JavaScript bean:
 +
 +<code javascript>
 +//Script to run SimpleReport.jasper as an XLS Excel Spreadsheet
 +
 +var HashMap = Java.type("java.util.HashMap");
 +var FileInputStream = Java.type("java.io.FileInputStream");
 +var JasperPrint = Java.type("net.sf.jasperreports.engine.JasperPrint");
 +var JasperFillManager = Java.type("net.sf.jasperreports.engine.JasperFillManager");
 +var JRXlsExporter = Java.type("net.sf.jasperreports.engine.export.JRXlsExporter");
 +var SimpleOutputStreamExporterOutput = Java.type("net.sf.jasperreports.export.SimpleOutputStreamExporterOutput");
 +var SimpleExporterInput = Java.type("net.sf.jasperreports.export.SimpleExporterInput");
 +
 +compiledReport="SimpleReport.jasper";
 +outputName = "SimpleReport.xls";
 +
 +try {
 +        reportStream = new FileInputStream(compiledReport);
 +        parameters = new HashMap(); //empty hashmap  (no parameters)      
 +        jasperPrint = JasperFillManager.fillReport( reportStream , parameters);
 +        xlsExporter = new JRXlsExporter();
 +        xlsExporter.setExporterInput(new SimpleExporterInput(jasperPrint));
 +        xlsExporter.setExporterOutput(new SimpleOutputStreamExporterOutput(outputName));
 +        xlsExporter.exportReport();
 +   
 +    
 +} catch (e) {
 +    print("Error in Run JasperReport script: \n"+e.stack);
 +    print(e);    
 +    
 +}
 +
 +</code>
 +
 +to make an xlsx spreadsheet, use this code in the JavaScript bean:
 +
 +<code javascript>
 +//Script to run SimpleReport.jasper as an XLSX Excel Spreadsheet
 +
 +var HashMap = Java.type("java.util.HashMap");
 +var FileInputStream = Java.type("java.io.FileInputStream");
 +var JasperPrint = Java.type("net.sf.jasperreports.engine.JasperPrint");
 +var JasperFillManager = Java.type("net.sf.jasperreports.engine.JasperFillManager");
 +var JRXlsxExporter = Java.type("net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter");
 +var SimpleOutputStreamExporterOutput = Java.type("net.sf.jasperreports.export.SimpleOutputStreamExporterOutput");
 +var SimpleExporterInput = Java.type("net.sf.jasperreports.export.SimpleExporterInput");
 +
 +compiledReport="SimpleReport.jasper";
 +outputName = "SimpleReport.xlsx";
 +
 +try {
 +        reportStream = new FileInputStream(compiledReport);
 +        parameters = new HashMap(); //empty hashmap  (no parameters)   
 +        jasperPrint = JasperFillManager.fillReport( reportStream , parameters);
 +        xlxsExporter = new JRXlsxExporter();
 +        xlxsExporter.setExporterInput(new SimpleExporterInput(jasperPrint));
 +        xlxsExporter.setExporterOutput(new SimpleOutputStreamExporterOutput(outputName));
 +        xlxsExporter.exportReport();     
 +   
 +    
 +} catch (e) {
 +    print("Error in Run JasperReport script: \n"+e.stack);
 +    print(e);    
 +    
 +}
 +</code>
 +
 +to make a csv file, use this script:
 +
 +<code javascript>
 +//Script to run SimpleReport.jasper to generate a CSV file
 +
 +var HashMap = Java.type("java.util.HashMap");
 +var FileInputStream = Java.type("java.io.FileInputStream");
 +var JasperPrint = Java.type("net.sf.jasperreports.engine.JasperPrint");
 +var JasperFillManager = Java.type("net.sf.jasperreports.engine.JasperFillManager");
 +var JRCsvExporter = Java.type("net.sf.jasperreports.engine.export.JRCsvExporter");
 +var SimpleCsvExporterConfiguration = Java.type("net.sf.jasperreports.export.SimpleCsvExporterConfiguration");
 +var SimpleWriterExporterOutput = Java.type("net.sf.jasperreports.export.SimpleWriterExporterOutput");
 +var SimpleExporterInput = Java.type("net.sf.jasperreports.export.SimpleExporterInput");
 +
 +compiledReport="SimpleReport.jasper";
 +outputName = "SimpleReport.csv";
 +
 +try {
 +        reportStream = new FileInputStream(compiledReport);
 +        parameters = new HashMap(); //empty hashmap  (no parameters)      
 +        parameters.put("IS_IGNORE_PAGINATION", true);
 +        jasperPrint = JasperFillManager.fillReport( reportStream , parameters);
 +        csvExporter = new JRCsvExporter();
 +        csvExporter.setExporterInput(new SimpleExporterInput(jasperPrint));
 +        csvExporter.setExporterOutput(new SimpleWriterExporterOutput(outputName));
 +        csvConfiguration = new SimpleCsvExporterConfiguration();
 +        csvConfiguration.setWriteBOM(true);
 +        csvConfiguration.setRecordDelimiter("\r\n");   
 +        csvExporter.setConfiguration(csvConfiguration);
 +        csvExporter.exportReport();   
 +    
 +} catch (e) {
 +    print("Error in Run JasperReport script: \n"+e.stack);
 +    print(e);    
 +    
 +}
 +
 +
 +
 +</code>
 +
 +
 +===Run the SimpleReport from TransSECS===
 +
 +You can trigger a script in TransSECS Devices with a CEID (Collection Event) or any other trigger to run the same reports as you can run in MIStudio and MIX. Copy the files listed in the setup section to your TransSECS project's resources directory. These files will be copied to the deployment when you build your TransSECS project.
 +
 +
 +
  
gettingstartedwithjasperreports.1641426766.txt.gz · Last modified: by wikiadmin
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki