Jasperwave - the other JasperReports DesignerIt's always good when there is new competition on the field: Jasperwave is a recent project on creating a very user-friendly JasperReport Designer. Currently it is at version 0.9.2 and available both as Eclipse plug-in as well as standalone client from here.I have to say that for such an early version it is already a very impressive offering. All the basic functionality is covered, sub-reports are partially...

Read More

Jaspersoft iReport: How to pass a parameter to a sub-dataset

Jaspersoft iReport: How to pass a parameter to a sub-datasetLet’s say our main report is grouped by continent and the details band holds sales figures for each country. We would like to add now a pie chart to the group footer to visualize the share by product by continent. Imagine our main report query is:SELECT      product_sales.`continent` AS product_sales_continent,product_sales.`city` AS product_sales_city,     ...

Read More

Star Schema Modeling with Pentaho Data Integration

Star Schema Modeling with Pentaho Data IntegrationTutorial DetailsSoftware (this tutorial was published on 2011-11-04 and download sources were correct on this date but might change in future): Download the latest version of PDI which includes the Star Modeler plugin (download here). If you run pdi-ce-4.3.0-M1, you can download the Star Modeler plug-in from here. Ideally though, just download the latest version of PDI.MySQL or similar databaseStar...

Read More