node-jasper-th

JasperReports within Node.js and UTF-16 encoding

Downloads

no need to download, jasperreports-6.17.0-project.tar.gz is embedded in lib

Install

if you don't have a java Install java jre-8u251(Java SE 8) and java jdk

Install via npm:

npm install node-gyp -g
npm install --global --production windows-build-tools(if does not work try installing python, vs2017 c++ manually)
npm install node-jasper-report

To use it inside your project just do:

var jasper = require('node-jasper-report')(options);

Where options is an object with the following signature:

options: {
	reports: {
 		// Report Definition
 		"name": {
 			jasper: , //Path to jasper file,
 			jrxml: , //Path to jrxml file,
 			conn: , //Connection name, definition object or false (if false defaultConn won't apply or if ´in_memory_json´ then you can pass an JSON object in the ´dataset´ property for in-memory data sourcing instead of database access

 		}
 	},
 	drivers: {
 		// Driver Definition
 		"name": {
 			path: , //Path to jdbc driver jar
 			class: , //Class name of the driver (what you would tipically place in "Class.forName()" in java)
 			type: //Type of database (mysql, postgres)
 		}
 	},
 	conns: {
 		// Connection Definition
 		"name": {
 			host: , //Database hostname or IP
 			port: , //Database Port
 			dbname: , //Database Name
 			user: , //User Name
 			pass: , //User Password
 			jdbc: , //jdbc connection String. If this is defined, every thing else but user and pass becomes optional.
 			driver: //name or definition of the driver for this conn
 		}
 	},
 	defaultConn: ,//Default Connection name
	java: ,//Array of java options, for example ["-Djava.awt.headless=true"]
	javaInstnace: //Instance of node-java, if this is null, a new instance will be created and passed in 'java' property
 }

API

• java

  Instance of node-java that we are currently running.

• add(name, report)

  Add a new report definition identified by name.

  In report definition one of jasper or jrxml must be present.

• pdf(report)

  Alias for export(report, 'pdf')

• export(report, format)

  Returns the compiled report in the specified format.

  report can be of any of the following types:

  • A string that represents report's name. No data is supplied.. defaultConn will be applied to get data with reports internal query.

  • An object that represents report's definition. No data is supplied.. if conn is not present, then defaultConn will be applied to get data with reports internal query.

  • An object that represents reports, data and properties to override for this specific method call.

    {
      report: , //name, definition or an array with any combination of both
      data: {}, //Data to be applied to the report. If there is an array of reports, data will be applied to each.
      override: {} //properties of report to override for this specific method call.
      dataset: {} //an object to be JSON serialized and passed to the Report as fields instead of parameters (see the example for more info)
      query: '' // string to pass to jasperreports to query on the dataset
    }
    

  • An array with any combination of the three posibilities described before.

  • A function returning any combination of the four posibilities described before.

Example

var express = require('express'),
	app = express(),
	jasper = require('node-jasper')({
		path: 'lib/jasperreports-6.1.0',
		reports: {
			hw: {
				jasper: 'reports/helloWorld.jasper'
			}
		},
		drivers: {
			pg: {
				path: 'lib/postgresql-9.2-1004.jdbc41.jar',
				class: 'org.postgresql.Driver',
				type: 'postgresql'
			}
		},
		conns: {
			dbserver1: {
				host: 'dbserver1.example.com',
				port: 5432,
				dbname: 'example',
				user: 'johnny',
				pass: 'test',
				driver: 'pg'
			}
		}
		defaultConn: 'dbserver1'
	});

	app.get('/pdf', function(req, res, next) {
		//beware of the datatype of your parameter.
		var report = {
			report: 'hw',
			data: {
				id: parseInt(req.query.id, 10)
				// jasper.toJsonDataSource is modified to convert to UTF-16
				secundaryDataset: jasper.toJsonDataSource({
					data: ...
				},'data')
			}
			dataset: //main dataset
		};
		var pdf = jasper.pdf(report);
		res.set({
			'Content-type': 'application/pdf',
			'Content-Length': pdf.length
		});
		res.send(pdf);
	});

	app.listen(3000);

Example for DB2

var express = require('express'),
	app = express(),
	jasper = require('node-jasper-report')({
		path: 'lib/jasperreports-6.1.0',
		reports: {
			hw: {
				jasper: 'reports/helloWorld.jasper'
			}
		},
		drivers: {
			db2: {
				path: 'lib/db2jcc4.jar',
				class: 'com.ibm.db2.jcc.DB2Driver',
				type: 'db2'
			}
		},
		conns: {
			dbserver1: {
				host: 'dbserver1.example.com',
				port: 5432,
				dbname: 'example',
				user: 'kevin pogi',
				pass: 'kevin pogi',
				driver: 'db2'
			}
		}
		defaultConn: 'dbserver1'
	});

	app.get('/xlsx', function(req, res, next) {
		//beware of the datatype of your parameter.
		var report = {
			report: 'hw',
			data: {
				id: parseInt(req.query.id, 10)
				// jasper.toJsonDataSource is modified to convert to UTF-16
				secundaryDataset: jasper.toJsonDataSource({
					data: ...
				},'data')
			}
			dataset: //main dataset
		};
		var resp = jasper.export(
			{
				report: 'jasper_report',
				data: {
					name: 'Gonzalo',
					lastname: 'Pogi',
				},
				dataset: [
					{
						name: 'Gonzalo',
						lastname: 'Vinas' // TODO: check on UTF-8
					},
					{
						name: 'Agustin',
						lastname: 'Moyano'
					}
				]
			},
			'xlsx'
		)

		res.send(resp);
	});

	app.listen(3000);

Example for Docx

var express = require('express'),
	app = express(),
	jasper = require('node-jasper-report')({
		path: 'lib/jasperreports-6.1.0',
		autoCompileReportsPath: 'folder path of jrxml files', //compiles report automatically
		reports: {
			hw: {
				jasper: 'reports/helloWorld.jasper'
			}
		},
		drivers: {
			db2: {
				path: 'lib/db2jcc4.jar',
				class: 'com.ibm.db2.jcc.DB2Driver',
				type: 'db2'
			}
		},
		conns: {
			dbserver1: {
				host: 'dbserver1.example.com',
				port: 5432,
				dbname: 'example',
				user: 'kevin pogi',
				pass: 'kevin pogi',
				driver: 'db2'
			}
		}
		defaultConn: 'dbserver1'
	});

	app.get('/docx', function(req, res, next) {
		//beware of the datatype of your parameter.
		var report = {
			report: 'hw',
			data: {
				id: parseInt(req.query.id, 10)
				// jasper.toJsonDataSource is modified to convert to UTF-16
				secundaryDataset: jasper.toJsonDataSource({
					data: ...
				},'data')
			}
			dataset: //main dataset
		};
		var resp = jasper.export(
			{
				report: 'jasper_report',
				data: {
					name: 'Gonzalo',
					lastname: 'Pogi',
				},
				dataset: [
					{
						name: 'Gonzalo',
						lastname: 'Vinas' // TODO: check on UTF-8
					},
					{
						name: 'Agustin',
						lastname: 'Moyano'
					}
				]
			},
			'docx'
		)

		res.send(resp);
	});

	app.listen(3000);

That's It!. Note that compiling jrxml to jasper only works on jasperreports-6.1.0.

=== Enhancemence == To user jasper report and enable Thai language: Pre-requisite:

1. npm install -> "node-jasper-report-dp": "^1.0.0"
2. jasper report library 6.17.0
3. Customer java jar file -> <jasper_project_folder>/lib/jasper-string-converter.jar. ( **created by Pele: convert charset to utf-16)
4. Modify index.js in node-jasper-report-dp module: Change function jasper.prototype.toJsonDataSource To jasper.prototype.toJsonDataSource = function (dataset, query) { var self = this; var jsonString = JSON.stringify(dataset); var is = java.callStaticMethodSync("com.jdea.dental.StringToByteArray", "GetInputstream", jsonString); return new self.jrjsonef(is, query || ''); }

** com.jdea.dental.StringToByteArray is package from jar file in step 3