Planet Jaspersoft

June 28, 2011

To create a crosstab report (sometimes called a "Pivot Table") in Jaspersoft's iReport Designer, simply drag a Crosstab component from the palette to a Summary band and configure through the wizard.  However, if you need more than 2 row or 2 column groups in the crosstab, you'll need additional configuration.

Read more »

June 28, 2011

June 20, 2011

To create a PDF report use Jaspersoft's iReport Designer to save off static content.  To parameterize and invoke the report on-the-fly, use a JSP container like Tomcat.
Read more »

June 20, 2011

May 26, 2011

Insight Into Any Data Source

noreply@blogger.com (Brian Gentile)
( n/a )

I’ve spent many hours talking to customers who are driven to respond assertively to the manybusiness challenges and opportunities presented to them nowadays. Top on their list is harnessing the deluge of data available to them to make more timely, fact-based decisions, which I’ve written about previously. Their businesses depend upon it. So, I’m proud that today, Jaspersoft is in better position than ever to help its customers rise to this challenge and create new opportunities.

Yesterday, we launch Jaspersoft v4.1. It may be just a single digit improvement from v4.0, but it’s a giant leap toward delivering insight from any data source (and released just four months after Jaspersoft 4!). Utilizing the enormous architectural improvements and the ground-breaking UI framework designed into Jaspersoft 4, we are quickly delivering a simple, elegant new interface to ROLAP-based, multi-dimensional data. And we’ll deliver that interface purely within our natural, web-based, drag-and-drop environment that allows querying of and interaction with nearly any data source. Here’s a sample screen to provide a view of this new ROLAP interface.

In total, our Jaspersoft BI Server architecture now supports integrated analysis capabilities across relational, OLAP and Big Data sources. Which means that our broad array of Big Data connectors can be used to bring gobs of data into this unified analytic and reporting environment, yielding new business insight simply and at an unbelievably low cost. Kind of makes the deluge of data seem tame-able.

Jaspersoft is fortunate in that its product’s breadth of use affords us a front row seat to some of the most demanding reporting and analytic requirements in the world. We know that scalability and performance will become ever-more important as data sizes and expectations for near real-time results grow. Clever then that Jaspersoft v4.1 comes wrapped in a native 64-bit installer, which allows this powerful BI server to be up-and-running on the most powerful hardware with the click of a button. Smells like more timely, fact-based decisions are on the horizon for organizations of any size.

Because this powerful, scalable, integrated analytic BI server still comes with our incredibly affordable commercial open source subscription pricing, we’re doing all we can to eliminate the barriers for anyone to create their own new opportunities.

My only hope is that everyone will check out Jaspersoft v4.1 before they consider using any other BI server. To learn more about our new product, you can check out the updated information on our web site or consider attending an up-coming webinar.

In the meantime, all comments and feedback are encouraged. Let me know what you think.

Brian Gentile

Chief Executive Officer

Jaspersoft


May 26, 2011

Insight Into Any Data Source

noreply@blogger.com (Brian Gentile)
The Open Book on BI )

I’ve spent many hours talking to customers who are driven to respond assertively to the manybusiness challenges and opportunities presented to them nowadays. Top on their list is harnessing the deluge of data available to them to make more timely, fact-based decisions, which I’ve written about previously. Their businesses depend upon it. So, I’m proud that today, Jaspersoft is in better position than ever to help its customers rise to this challenge and create new opportunities.

Yesterday, we launch Jaspersoft v4.1. It may be just a single digit improvement from v4.0, but it’s a giant leap toward delivering insight from any data source (and released just four months after Jaspersoft 4!). Utilizing the enormous architectural improvements and the ground-breaking UI framework designed into Jaspersoft 4, we are quickly delivering a simple, elegant new interface to ROLAP-based, multi-dimensional data. And we’ll deliver that interface purely within our natural, web-based, drag-and-drop environment that allows querying of and interaction with nearly any data source. Here’s a sample screen to provide a view of this new ROLAP interface.

In total, our Jaspersoft BI Server architecture now supports integrated analysis capabilities across relational, OLAP and Big Data sources. Which means that our broad array of Big Data connectors can be used to bring gobs of data into this unified analytic and reporting environment, yielding new business insight simply and at an unbelievably low cost. Kind of makes the deluge of data seem tame-able.

Jaspersoft is fortunate in that its product’s breadth of use affords us a front row seat to some of the most demanding reporting and analytic requirements in the world. We know that scalability and performance will become ever-more important as data sizes and expectations for near real-time results grow. Clever then that Jaspersoft v4.1 comes wrapped in a native 64-bit installer, which allows this powerful BI server to be up-and-running on the most powerful hardware with the click of a button. Smells like more timely, fact-based decisions are on the horizon for organizations of any size.

Because this powerful, scalable, integrated analytic BI server still comes with our incredibly affordable commercial open source subscription pricing, we’re doing all we can to eliminate the barriers for anyone to create their own new opportunities.

My only hope is that everyone will check out Jaspersoft v4.1 before they consider using any other BI server. To learn more about our new product, you can check out the updated information on our web site or consider attending an up-coming webinar.

In the meantime, all comments and feedback are encouraged. Let me know what you think.

Brian Gentile

Chief Executive Officer

Jaspersoft


May 26, 2011

May 19, 2011

In Talend Open Studio, the tJasperOutput component can be used to create a Jasper Report created in iDesigner.  Talend's flows -- say from a tAccessInput -- provide the data.

Read more »

May 19, 2011

May 18, 2011

Use the tJasperOutput component to run a Jasper Report from Talend Open Studio.  This component allows a report to be produced after a data flow is executed.

Read more »

May 18, 2011

May 7, 2011

If you have trouble docking the Palette in Jaspersoft's iReport Designer, reset the windows using Windows > Reset Windows.

In 4.0.2, the Palette docker wouldn't dock with the Properties docker.  After "Reset Windows", the Palette and the Properties docker appear in the right side of the screen with the Palette on top and the Properties below.

May 7, 2011

April 18, 2011

This is a sysadmin how-to for backing up JasperReports Server (formerly JasperServer) and it's database (MySQL only for now).

I wrote a fairly robust script to achieve this task. It will read the database configuration from your default_master.properties file, work with several versions of JasperServer, delete old backups, write to the syslog and export the repository contents to file.

First drop my backup script into your \buildomatic folder if you're using 4.0 and abovie, 3.7 and below put in your /scripts folder.

Once the script is in place edit the variables at the top of the script:

This is to signify that you're using JasperServer 3.7.1 and below:
IS_PRE_4=false

This is a name for the product:
PRODUCT_NAME="JRS-4.0-Pro"

This is where backups will be stored:
BACKUP_DEST="/home/ernesto/Dropbox/Backups"

This will delete old backups if set to true
DELETE_OLD=true

How many days to keep old backups
DAYS=120

Now add it to your crontab. I will do it once a week in a lazy manner so will add the script to vim /etc/cron.weekly/js-backups

#!/bin/bash
/usr/local/jaspersoft/jasperserver4/buildomatic/js-backup.sh


The script will log to /var/log/messages:


The output files will look like this, I chose to stick them in my Dropbox folder for off-site backups:













You can download the script from this jasperforge forum post or view it below:

April 18, 2011

The Repository Advantage: Deploying JRXML to JasperReports Server

Introduction

In this article we will explore a few of the advantages of using JasperReports Server (JRS), specifically the repository and some of the advantages it provides for report deployment. We are going to look at how reports can be linked together in the repository to create a drill down effect. Part of this discussion will include widgets referred to as input controls. These can be used to collect data from clients before running the reports.

read more

April 18, 2011

The Repository Advantage: Deploying JRXML to JasperReports Server

Introduction

In this article we will explore a few of the advantages of using JasperReports Server (JRS), specifically the repository and some of the advantages it provides for report deployment. We are going to look at how reports can be linked together in the repository to create a drill down effect. Part of this discussion will include widgets referred to as input controls. These can be used to collect data from clients before running the reports.

read more

April 18, 2011

Pages

Feedback
randomness