How to create a Site based Pentaho report (with sub-report) for Alfresco Business Reporting

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how you can create  a report with content for a specific site only. The report will be stored back into that site. Your bonus is a subreports.

How to create a single Pentaho report with subreports for Alfresco Business Reporting

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how you can create  a report with subreports, and drive the report from within Alfresco.

How to create a parameterized Pentaho report for Alfresco Business Reporting

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how you can create  parameterized report, and drive the report from within Alfresco.

How to create a basic Pentaho report for Alfresco Business Reporting

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. And this blog is about how to create your first report using Pentaho Report Designer.

Alfresco Business Reporting – The out-of-the-box basics

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how to find your way around the basic reporting objects in the system once you installed the AMP (and the JAR)

Alfresco Business Reporting 0.8 released

Alfresco is a great ECM tool. However, it is not very powerful in facilitating reporting against it’s own content repository. Therefore I started the Alfresco Business Reporting project somewhere in 2011. Back then, the tool started as a kind of JavaScript API for reporting. The concepts are the same, but the usability and user-configurability have increased dramatically since then. The tool is still based on extracting metadata to an external SQL-based reporting database. The idea still is that:

• ‘The business’ should be able to run ‘reporting’, not external technical consultants or people with heavy weight Alfresco knowledge,
• Reporting is based on standard tooling (read: Pentaho)

Alfresco Business Reporting – Alive and Kicking

It has been a while since I published new code on the Alfresco Business Reporting project. Actually, I still have not. But lots of stuff has happened last 4 months, and some months before that. Partially because I needed the functionality for my customers (or for those testing this tool). And of course, because you were asking for it.

Executing JNDI based Pentaho reports using the Java API

I am working on the Alfresco Business Reporting project. In there, the tool can execute Pentaho/ Jaspersoft reports (against Alfresco business objects, using the Pentaho/Jasersoft Java API) on a scheduled basis. I ran into the issue of portability of the (Pentaho) reports. The database, url, credentials were not identical on my Development, Test and Production environments… JNDI is the answer.

Alfresco Business Reporting released

A while ago I wanted insight in how our Alfresco Share repository was used. ‘Ad-hoc reporting’ and ‘(always changing) management reporting’ is not Alfresco’s strongest feature. There is a need for reporting in a way a business user understands, using their tools of choice. The Alfresco Business Reporting project delivers the missing link. It extracts Alfresco business objects (like documents, folders, datalists, links, discussions) into plain SQL tables. The total set of properties for each object, including your custom aspects, show up as columns in your table. And you, the business, can use your reporting tool of choice, to generate fancy reports. No need for IT consultants to configure Alfresco for every change or additional report. Once the synchronization is configured, you can define as much reports as you like, answering your (or your management’s) questions immediately.