Category Archives: Announcements

Pentaho Reporting version will be 5.0, in sync with BA-Server

It is now official. The next release of Pentaho Reporting will be numbered 5.0, in sync with the Pentaho Suite 5.0. Future releases will then keep in sync with the suite version number and will be released at the same time as the Pentaho Server.

Although it is a shame that you will no longer be able to impress friends and family with the arcane knowledge of what PRD goes with a given release of the BA-Server, it will simplify the story for support, marketing, sales and everyone else.

We are now also officially in feature-lock-down. We thus have finally entered the last stages of the development process (the remaining phases being ‘stress’, ‘panic’ and ‘outright agony’). That means, no new features get added, regardless how good they are, and we now concentrate solely on working though the remaining items of the sprint backlogs.

Crosstabs got pushed from 5.0 – but my work goes on

211px-Punishment_sisyphOn Friday, Pentaho development and product management made the decision to remove crosstabs out of the next release. Therefore, the Pentaho Suite 5.0 will not claim support for crosstabs. The decision came upon us after looking at the scope of the remaining work across the whole stack.

So let me give some context to this decision and how it impacts the ongoing and future development work of the reporting stack.

What does it mean for the Pentaho Suite 5.0 release?

The BI-Suite will ship with Pentaho Reporting 4.0. I will continue to finalize the reporting engine’s support for crosstabs, and that will ship with the release. The engine will fully support crosstab reports.

However, the user interface for creating crosstabs will be basically limited to what we have in the current development version, plus fixes to make it work stable. Given the fact that we can’t reasonably expect anyone but consultants and programmers to use a feature that has no proper UI, we will refrain from publicly claiming that the reporting system supports crosstabs (yet).

That means, you create crosstabs via a dialog and you can select and format elements in the graphical editor. Everything beyond that won’t have proper UI support, and thus reconfiguring an existing crosstab requires hard work in the structure tree.

The Pentaho Reporting engine has still some interesting new features to offer to make a upgrade worthwhile. Stylesheet support now allows you to create shared style definitions that can be hosted centrally. A new class of datasources driven by Kettle templates adds support for Big-Data/No-SQL datasources. These templates are parametrized, and deployed as plugins and thus allow you to write reusable datasources that are user-friendly to use. And last but not least: We opened up the layout system, giving you new options on how to format reports.

What were the reasons for the push?

The decision was a classical result of reducing the risk of the upcoming release. The next release contains a massive rewrite of the internals of the Pentaho BI-Server, updating the architecture to the standards of the 21st century. Adding the JCR repository and REST services required paying for a large amounts of work, which will pay off in the future with faster release cycles and easier to maintain code.

We have roughly 6 weeks left until the code needs to be finished and handed over to the release process. Many of the committed features have only few bits missing or need debugging to be checked off as finished.

Over the last month or two, the crosstab UI work was somewhat sidelined by bug-fixing work for the service packs and by work on other features. With too many tasks for not enough hands, at some point something has to give in.

Faced with a large workload that would finally leave little time for QA and documentation, it was only sensible to cut our loses short for this release. To create a release that contains as many goodies as possible, it is more sensible to finish what is nearly done than to work on the larger risk items.

It is difficult to push cases where the missing feature would be a regression or leave a visible gap. At the end, the crosstab cases were clearly separate from the other features, and with clear lines for the cut the safest to push.

 

Pentaho publishes its first montly Service Pack

Pentaho_ContentLast week, Pentaho delivered it’s first service pack full of bug-fixes for the last two releases to our existing customers. I think this now marks the point where Pentaho crossed over from being a wild teenager towards being an responsible adult.

We provide commercial support for our customers as part of the Pentaho support offering, and as part of that we have a long history of fixing critical bugs in releases outside of the normal release cycle.

The main selling point of any commercial support contract is that of an insurance policy – if something goes wrong and your critical systems are down, there is someone who cares and who can fix them for you. It is the kind of service that lets managers sleep at night in the safe knowledge that their factories will run and their reports continue to be delivered when they wake up the next day.

Until recently, customers with show-stopping problems (severity class 1, with no work-around) would have to go through an escalation process to get the bug-fix machine rolling. The escalation, received by our support department, would land on the desk of the engineering group, who would scramble on their feet to fix it as fast as possible. After we have a fix, it goes through some more testing (which can include that we send out early versions of the fix to validate that it really works in your production system) before it gets wrapped up and officially handed back to support as a ‘customer deliverable’ patch release.

One major drawback of that system was: If a bug was not a show-stopper, you would have a rather hard time to get that through as an worthy emergency fix. This easily leads to situations where a low-intensity bug affects a lot of customers, making everyone unhappy, but it never gets addressed for existing releases, as the bug is not severe enough for a single customer.

This system is working well when there is a crisis, and stays around. Sometimes you just can’t wait until the next patch release comes out.

But for us, as engineering group, dropping all tools and jumping onto emergency bug-fixes causes large disruptions in our engineering process. Emergency patches are born in an expensive process.

Therefore, Pentaho now introduces ‘Service Packs’. Similar to how Microsoft, Oracle and all the old companies publish bug-fixes for their software on a regular schedule, Pentaho’s service packs are following that same approach.

Roughly every 4 weeks – to be precisely, usually in the 3rd week of the month – we package up all bug-fixes that we created over the last month, and make it available to all customers as a patch release.

When we allocate some quality bug-fix time in our planing way before there is a panic call, we can work on the fixes without having to jump around wildly. We get more work done by concentrating a week or so on fixing a series of bugs than by context-switching between our product development work and us delivering emergency fixes.

And when we fix bugs regularly, it makes everyone happy.

Customers are happier, as they see we care, that we fix bugs that annoy them, even though they are not blocker problems. Engineering is happier, as we can fix bugs under less pressure, creating a larger number of fixes with less tears. And when it comes to renewal, sales is happier too, as customers who got help during the year are more likely to see the value of a support contract.

How do we decide what issues get fixed?

When the time comes to assemble the list of things we want to address, we have a list of criteria that help us pick and choose. Here are some of the criteria we use, but bear in mind that this list is in no particular order and not complete:

  • How critical is it? (we rather fix critical issues than cosmetic issues)
  • Is it a regression of an existing functionality?
  • What is the impact on customer(s)?
  • Is there a work around available
  • How many customers reported the problem?
  • Is it a data & security issue?
  • How complex is the fix? Does it require large changes? Is it risky?
  • How close to the patch package cut-off date has this bug been reported?

All these metrics get mixed together to help us form an opinion. So a more severe bug that affects only one customer in a highly arcane scenarios may get fix later than a small fix that affects dozens of customers.

Some issues cannot be solved in the short time frame of the allocated bug-fix time. These issues are likely to be scheduled to the next feature release, especially if fixing them involves major code work, along with the risk to create new problems. A bug fix is not really a bug fix if it introduces new bugs, right?

We currently produce service packs for the Pentaho 4.5 and Pentaho 4.8 release. For report designer, this maps to Pentaho Report Designer 3.9 and 3.9.1 respectively.

Let me repeat it to be extra clear: The old escalation process for show-stopper problems (severity class 1, no workaround available) is still there and will not go away. So when you encounter an issue that has a very negative impact on your operations, please continue to use the escalation process to make us aware of that. We then work together to resolve your problem.

Adding Service packs as an additional tool just makes it easier for us to improve our existing products in a more timely fashion, with fixes made to work within your existing product and installation. This way, getting and installing bug fixes can be as easy as installing the latest Windows Update, so that you can spend more time growing your business.

Moving to Git and easier builds

During the last year, as part of my work with the Rabbit-Stew-Dio, I fell in love with Git. Well, sort of, that marriage is not without conflict, and from time to time I hate it too. But when the time came to move all our Pentaho Reporting projects to Git, we all were happy to jump on that boat.

As a result, you can now access all code for the 4.0/TRUNK version of Pentaho Reporting via our GitHub Project. This project contains all libraries, all runtime engine modules and everything that forms the report-designer and design-time tools.

Grab it via:

git clone git@github.com:pentaho/pentaho-reporting.git

Code organization

Our code is split into three groups of modules.

  • “/libraries” contains all shared libraries and code that provides infrastructure that is not necessarily reporting related.
  • “/engine” contains the runtime code for Pentaho Reporting. If you want to embed our reporting engine into your own Swing application or whether you want to deploy it as part of a J2EE application, this contains all your ever need.
  • “/designer” contains our design-time tools, like the report-designer and the report-design-wizard. It also contains all data source UIs that are used in both the Report Designer and Pentaho Report Wizard.

If you use IntelliJ Idea for your Java work, then you will be delighted to find that the sources act as a fully configured IntelliJ project. Just open the ‘pentaho-reporting’ directory as project in IntelliJ and off you go.  If you use Eclipse, well, why not give IntelliJ a try?

Branching system

At Pentaho we use Scrum as our development process. We end up working on a set of features for about 3 weeks, called a Sprint. All work for that Sprint goes into a feature branch (sprint_XXX-4.0.0GA) and gets merged with the master at the end of the sprint.

If you want to keep an eye on our work while we are sprinting, check out the sprint branches. If you prefer is more stable, and are happy with updates every three weeks, stick to the master-branch.

During a Sprint, our CI system will build and publish artifacts from the sprint branches. If you don’t want that, then it is now easy to get your own build up and running in under 5 minutes (typing time, not waiting time).

Building the project

The project root contains a global multibuild.xml file that can build all modules in one go. If you want it more finely granulated, each top level group (‘libraries’, ‘engine’, ‘designer’) contains its own ‘build.xml’ file to provide the same service for these modules.

To successfully build Pentaho Reporting, you do need Apache Ant 1.8.2 or newer. Go download it from the Apache Ant Website if you haven’t done it yet.

After you cloned our Git repository, you have all the source files on your computer. But before you can use the project, you will have to download the third party libraries used in the code.

On a command line in the project directory, call

ant -f multibuild.xml resolve

to download all libraries.

If you’re going to use IntelliJ for your work, you are all set now and can start our IntelliJ project.

To build all projects locally, invoke

ant -f multibuild.xml continuous-local-testless

to run.

If you feel paranoid and want to run the tests while building, then use the ‘continuous-local’ target. This can take quite some time, as it also runs all tests. Expect to wait an hour while all tests run.

ant -f multibuild.xml continuous-local

After the process is finished, you will find “Report Designer” zip and tar.gz packages in the folder “/designer/report-designer/assembly/dist”.

If you get OutOfMemoryErrors pointing to a JUnitTask, or if you get OutOfMemory “PermGen Space” errors, increase the memory of your Ant process to 1024m by setting the ANT_OPTS environment variable:

export ANT_OPTS="-Xmx1024m -XX:MaxPermSize=256m"

Building the project on a CI server

Last but not least: Do you want to run Pentaho Reporting in your own continuous integration server and you want to publish all created artifacts to your own maven-server? Then make sure you set up Maven to allow you to publish files to a repository.

  1. Install Artifactory or any other maven repository server.
  2. Copy one of the ‘ivy-settings.xml’ configurations from any of the modules and edit it to point to your own Maven server. Put this file into a location outside of the project, for instance into “$HOME/prd-ivy-settings.xml”
  3. Download and install maven as usual, then configure it to talk to the Artifactory server.

Edit your $HOME/.m2/settings.xml file and locate the ‘servers’ tag. Then configure it with the username and password of a user that can publish to your Artifactory server.
Replace ‘your-server-id’ with a name describing your server. You will need that later.
Replace ‘publish-username’ and ‘publish-password’ with the username and password of an account of your artifactory installation that has permission to deploy artifacts.

<settings xmlns="http://maven.apache.org/SETTINGS/1.0.0"           
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"           
          xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0 
                    http://maven.apache.org/xsd/settings-1.0.0.xsd">
   ...
   <servers>
     <server>
       <id>your-server-id</id>
       <username>publish-username</username>
       <password>publish-password</password>
       <configuration>
         <wagonprovider>httpclient</wagonprovider>
         <httpconfiguration>
           <put>
             <params>
               <param>
                 <name>http.authentication.preemptive</name>
                 <value>%b,true</value>
               </param>
             </params>
           </put>
         </httpconfiguration>
       </configuration>
     </server>
   </servers>
    ..
</settings>

Now set up your CI job. You can either override the ivy properties on each CI job, or your can create a global default by creating a ‘$HOME/.pentaho-reporting-build-settings.properties’ file. The settings of this file will be included in all Ant-builds for Pentaho Reporting projects.

ivy.settingsurl=file:${user.home}/prd-ivy-settings.xml
ivy.repository.id=your-server-id
ivy.repository.publish=http://repo.your-server.com/ext-snapshot-local

After that, test your setup by invoking

ant -f multibuild.xml continuous

It should run without errors now. If you see errors on publish, check your Maven configuration or your Artifactory installation.

Conclusion

With the new build structure and the move to Git, it has become tremendously easy to download and work with the Pentaho Reporting source code. Even formerly daunting tasks like setting up an CI server have become simple enough to be documented in a single blog post.

Enjoy!

Pentaho Reporting 3.9.1 released on SourceForge

Doug just uploaded the latest stable release of the Pentaho Report Designer on Sourceforge. Thanks Doug!

This is a bug-fix release addressing issues in the drill-linking editor and the formula-editor. It also enabled support for smarter Mondrian-Caching via the new ‘JDBCConnectionUUID’ property.

Be aware that using PRD-3.9.1 requires that you also use BI-Server 4.8. If you have an older BI-Server installation, you have to stick to the report-designer that came with it or upgrade your server to 4.8.

Thank you Sulaiman to handle the whole release process! Well done.

Saiku Reporting 1.0 hits the market

.. and WAQR can finally rest in peace.

The community edition of the Pentaho Bi-Platform just got a whole lot better: On Friday, Marius Giepz released version 1.0 of Saiku-Reporting (SR).

Saiku-Reporting is a adhoc reporting plugin for the BI-Server. SR uses your existing Pentaho Metadata models to produce stylish reports. SR provides you with everything you have would expect from a adhoc tool:

  • Drag&Drop Report-Design with What-you-see-is-what-you-get design of your report
  • Export to: PDF,CSV,XLS,CDA,PRPT
  • Uses PRPT-Templates (bye, bye, WAQR templates!)
  • Grouping
  • Aggregation
  • Totals
  • Calculate additional columns with formulas

Creating a report is rather simple. Select your data from the left-hand side of your screen and drag it into the fields for columns, groups or filters. Double-click on the field-names to open a dialog with some more formatting options. 
 
When creating your reports, you have the choice to view your data either as paginated report or as raw-data. The raw-data view comes in handy when you create calculated columns, as you can see the data in the same way the reporting engine actually sees it.

And last but not least: Saiku-Reporting 1.0 is miles ahead of WAQR, so now we can finally bury that zombie for good.

Thank you Marius for that new member of the Pentaho space. And thank for your not naming it CAR (Community Adhoc Reporting). :D

Pentaho Reporting 3.9-RC is on the slide to its release

Right now the engineers at Orlando are building the Release Candidate of the 4.0 release of the BI-Server. Along with it, we will have a bug-fix release of the Report-Designer and Reporting Engine named 3.9-RC.

The release ships with only a handful of new features and a ship load of bug-fixes.

New feature: Justified Text

This feature has been sitting on my list of things to do for ages. More specifically, since the old “Pre-Pentaho” days, when the internet was still young. We now have a new text-alignment option for your content and a button for it on the toolbar.

New feature: Heavily Scripted Data-Sources

This is my personal favourite of this release. All major data-sources (SQL, MetaData, Mondrian and OLAP4J) can now customize both the configuration of the data-source, the query that gets executed and the result-set that gets produced. At the moment we ship with support for Java-Script and Groovy scripting to make these customizations.

Improvement: CDA-datasource local calls

When running on the same server, CDA data-sources now call the CDA plugin via Java-calls instead of routing all calls through a network layer. THank you, web-details, for this addition.

Improvement: JQuery based report-viewer

Well, not sure whether this is a new feature or improvement, but we now have a pure Java-Script based report-viewer based on JQuery and standard JavaScript. It is so clean that even I can understand that code. Over the last few years, we heard more and more desperate calls for a better report viewer that can be customized to customer needs. If you are a web-developer or know one, you now are one step closer to a customized report parametrization experience. Credits go to Jordan Ganoff for coming up with this great addition.

Improvement: Data-sources now obfuscate stored passwords.

When writing PRPT files, we now obfuscate all passwords so that they are not as asy to read. Note that this does not make any change to any skilled attacker – as anyone with a debugger or access to the source-code can see how these passwords are en- and de-coded. If you need true security for your database credentials, you still have to use JNDI connections and ensure that only trustworthy administrators can access the server configuration.

Bug-Fixes: A load of layouter related issues. Subreports processing with page-footers and repeated group-footers was buggy. The HTML content produced by the HTML output writer is now much cleaner and less verbose. The table-datasource editor now can remove multiple rows at once and has other usability problems fixed as well. For a complete list, have a look at the release notes on our JIRA system.

What’s New in Pentaho Report Designer 3.8.1 – Bug-Fixes!

With weeks and weeks of doing nothing bug bug-fixes passing by, we finally reached the point where there is a new release of the reporting tools and the BI-Server comes along. So let’s have a look on what changed and why you want to upgrade as fast as possible.

The most exciting new addition for everyone probably is the Pentaho Interactive Reporting service. Pentaho Interactive Reporting replaces the old Web-Based Ad-Hoc Query and Reporting (WAQR) tool. WAQR was one of those things that get the job done, but do so neither gracefully nor with style. But in the 21st century you need something better. There are times where you can’t go for the full featured hardcore-nerdy Report-Designer option.

Pentaho Interactive Reporting is aimed to supplement our reporting solutions. Technologically it stands between Analyzer being a complete Ad-Hoc tool for exploring the OLAP models of the data-warehouses and the Pentaho report designer, a tool for creating standardized reports for printing or non-interactive access to the data.

Apart from opening up some APIs for Pentaho Interactive Reporting, this release only contains bug-fixes. This release contains fixes in the layouter, the parameter handling and the cascading prompt capabilities inside the platform and the report-designer and fixes some missing functionality inside the charting system.

Overall, 63 bugs got squashed in the process.

Pentaho Reporting 3.8.1 is now in the final build process and from my part the work is done now (assuming that the final tests do not come up with any show-stopping bugs). Judging from the last releases, the final build should be uploaded to our public Sourceforge page in a next weeks.


Release Notes – Pentaho Reporting and Pentaho Report Designer – Version 3.8.1 GA (4.0.0 GA Suite Release)

Bug

  • [PRD-114] – Round settings on rectangle element are not being saved.(In HTML)
  • [PRD-2434] – PRD will show only the one column if the same column is being queried in multiples of different aggregates.
  • [PRD-2690] – Selecting a formula-function in the side-bar-list does not show the function’s description in the bottom area of the formula editor.
  • [PRD-2834] – Radar chart not displaying Japanese characters for the legend and graph points
  • [PRD-2924] – Reporting plugin within PUC, date field doesn’t populate with the date chosen with the date picker.
  • [PRD-3243] – On functions attributes, when you use the … button to select a group, for the property “Reset on Group name , and select a group, the value won’t update to the property
  • [PRD-3330] – Removed “ProductLine” custom parameter in Hyperlink definition on the “Product Line Sales.prpt”.
  • [PRD-3354] – Experimental features disabled with CDA datasource on classpath dies with NPE
  • [PRD-3420] – Date format on X-axis in chart is ignored
  • [PRD-3425] – Saving a report with landscape orientation mixes up the left and right margin on load
  • [PRD-3431] – Regression: Sheetname style expression used on group header does not set the first sheet’s sheetname
  • [PRD-3433] – PRD Windows *.bat startup file does not work with latest JRE
  • [PRD-3438] – Horizontal scroll bars do not appear in IE when using custom landscape layout and parameter-layout equal to horizontal
  • [PRD-3453] – Tables need a style definition “table-layout: fixed” to render properly in IE
  • [PRD-3466] – UI Refresh – Reports in the PUC report viewer do not have new scroll bars.
  • [PRD-3467] – UI Refresh – Report filters controls do not have updated style
  • [PRD-3470] – Indexed columns had no proper metadata processing and therefore wizard-label printing broke if the tablemodel did not provide proper metadata
  • [PRD-3474] – Overlapping element in group header on HTML Action report.
  • [PRD-3475] – Report Name for Chart Post Processor is Line it should be “Chart Post Processor”.
  • [PRD-3476] – Radar Chart is display incorrect data for the series. The chart is setup incorrectly.
  • [PRD-3478] – Firefox: Links are not aligning with items in a PRPT’s pie chart (Product Line Sales)
  • [PRD-3479] – Adding element in details band breaks out the Pentaho Report Designer GUI.
  • [PRD-3480] – On functions attributes, the Value’s dropdown list contains empty descriptions
  • [PRD-3487] – I get the following stack trace when using the report wizard in PRD, no end user impact
  • [PRD-3489] – Report Header displays a blue border and the font it not anti-aliased (IE only)
  • [PRD-3490] – Reports are not displayed correctly in IE 7.0 and 8.0 when the Report Parameter pane is minimised
  • [PRD-3494] – XYBar-Charts do not have the stackedBarRenderPercentages option the categorical charts have.
  • [PRD-3495] – Morphing a label into a date field kills the attribute-table when it tries to format the “value” attribute
  • [PRD-3496] – Edit-Groups dialog looses user-input if a cell-editor is still active when the user hits OK
  • [PRD-3497] – LegacyChartEditor looses user data if closed while editing cells.
  • [PRD-3498] – Report Pre-Processors are displayed with their raw classnames in the master-report attribute table
  • [PRD-3499] – As a PIR developer, I want the wizard-core to provide an option to override metadata formatting when applying a user defined format.
  • [PRD-3503] – Chart Editor has additional chart properties that don’t have user-friendly names.
  • [PRD-3507] – Set Italian number format for chart labels
  • [PRD-3512] – Problem launching Report Designer version 3.7 and 3.8 on Windows 7
  • [PRD-3514] – Adding TOC to report causes exception from JDBC driver
  • [PRD-3515] – Url-formula option in the Scatter Plot Chart doesn’t work.
  • [PRD-3516] – Saving a report in PUC via IE gives the filename as “reporting” instead of giving the prpt’s name as filename.
  • [PRD-3519] – Default date format for a text input parameter field works in 3.6 but not in 3.8
  • [PRD-3521] – XY/XYZ charts have no option to display the textual series key in a tooltip or URL
  • [PRD-3522] – Layout Issues: Inventory Report doesn’t look the same in 3.8.1.
  • [PRD-3528] – Sample Report – What’s New – is not correctly grouping the detail items.
  • [PRD-3529] – Block layout in Report Header behaves differently between html stream and html paginated.
  • [PRD-3536] – BarcodeElement with invalid barcode input bombs the layout and the report processing
  • [PRD-3537] – After changing the orientation from portrait to landscape, the right and left margins get reversed.
  • [PRD-3540] – Cascading prompts with server side calculated default values are not working
  • [PRD-3541] – A plain text-field parameter with a data-source attached to it resets unknown values to even if the parameter is not strictly validating.
  • [PRD-3542] – Editing a metadata query containing the same columns with differ aggregation types, the query aggregation types default to MIN.
  • [PRD-3549] – Character spacing on report elements not working on PDF outputs.
  • [PRD-2422] – When editing query with a parameter that is a date in the MQL Editor, the editor updates the a parameter, {date_parameter} to DATEVALUE([date_parameter]) and the default value can’t be set.
  • [PRD-3349] – Request for patch to Report Designer 3.7 to fix number truncation problem
  • [PRD-3365] – Column-by-index fields are not available if the data comes from the query-cache
  • [PRD-3373] – Random incorrect value displayed in PDF output format
  • [PRD-3375] – Round up/down error in Report Designer
  • [PRD-3396] – Problem displaying different format-string in the same column on a number field
  • [PRD-3422] – Moving the focus widget out of the parameter panel
  • [PRD-3448] – Excel chart output is blurred
  • [PRD-3451] – As a reporting user I want to use a default-value formula to get default values for cascading parameters when the parent parameter changes
  • [PRD-3454] – On Open dialog, update Report Definition to include the .prpti file type.
  • [PRD-3455] – On Open from Repository dialog, update Report Definition to include the .prpti file type.
  • [PRD-3465] – Kettle datasource does not work correctly with datasource-cache enabled as it does not take the query name into account
  • [PRD-3473] – Label Text “Group n Footer” is displaying in a report generate by the Report Wizard using the new templates.
  • [PRD-3411] – Issue with Cascading Prompts

Improvement

  • [PRD-3426] – Need the ability to set the padding on the detail elements on templates
  • [PRD-3432] – Width of Inherit column is too wide leaving less space for property name
  • [PRD-3525] – Update default Chart Options to be consistent with Analyzer and Dashboards
  • [PRD-3547] – Opent Dashboards (.xdash) via hyperlinks into new tab
  • [PRD-3452] – As a reporting user I want to open PRPTI files from within PRD
  • [PRD-3469] – Add new templates and remove the old ones.

Pentaho Reporting 3.8.1-RC1 released

On Friday without much ado, Pentaho uploaded the Release Candidate 1 of Pentaho Reporting 3.8.1 to the Sourceforge servers. This bug-fix release contains only bug-fixes, among the more noteworthy we have PRD-3349 and PRD-3375 (Numbers rounded wrongly) and some changes to the parameter handling so that cascading prompts get more usable inside the report designer and the Pentaho BI-Server.

Full list of all cases closed in this release

Download: Download Pentaho Report Designer 3.8.1-RC1

[PATCH Notice] There is a rounding error in PRD-3.7/3.8

Shortly after the release of Pentaho Reporting 3.8, we got reports that the nasty rounding error introduced in PRD-3.7 (PRD-3080) partially survived the surgery.

The bug caused rounding errors when we formatted and displayed numbers in a report and I highly advice anyone to install this patch.

Even though all patches and binaries of the bugfix releases are always available to our paying customers via the Pentaho support, I consider this one critical enough to make this patch available to the global community as well.

So grab the patch to the patch:
http://www.sherito.org/downloads/libformat-1.2.4.jar

Patch Installation

Place this jar into both into your Pentaho Report Designer and BI-Server library directory.

For Pentaho Report Designer

(1) locate the “lib” directory in the Report Designer Installation directory
(2) delete the “libformat-1.2.3.jar” file.
(3) copy the “libformat-1.2.4.jar” file you just downloaded into this lib-directory.

For the Pentaho BI-Platform

(1) locate the “biserver-ee/tomcat/webapps/pentaho/WEB-INF/lib” directory in your BI-Server Installation directory.
(2) delete the “libformat-1.2.3.jar” file.
(3) copy the “libformat-1.2.4.jar” file you just downloaded into this lib-directory.

After that, restart your BI-Server and your Pentaho Report Designer.