Awarded Design and Development
DGI Systems is committed to the use of proven open source technologies to provide dynamic, cost effective business intelligence (BI) solutions. We believe that the use of open source software recipients should contribute wherever possible. The simplest way for us to do that is financially, where we have made financial contributions to the eclipse foundation and are currently granted 'friends of eclipse' status.
The second, and more challenging method of contribution, is technical input. As a member of various IT forums which help support the BI community DGI Systems has contributed an award winning design to BIRT exchange, the home of everything BIRT related. BIRT exchange is sponsored by Actuate who are the engineers behind the BIRT technology, teaming up with the Eclipse Foundation and IBM to produce this highly sophisticated BI platform. A full list of the BIRT Project Management Committee (PMC) and Project Leads can be seen here.
The Award - BIRT Exchange DevShare Contributor of the Month
The DevShare Contributor of the Month contest was created as one way to reward BIRT Exchange members who actively contribute to the community. Actuate created an area on BIRT Exchange called the DevShare where developers can share these lessons learned. At the end of each month, the person with the most popular DevShare item submitted that month will win a prize. The most popular solutions are generally those which present solutions to design issues where a required output is not supplied 'out of the box' by the software and an innovative approach is required.
The problem arose for us when we were required to render a report in numerous columns across a page, having the data from one column (table) flow into another. Once the page ended the final column data would flow into the first column of the next page. While the BIRT designer does not allow this out of the bow, it does provide all of the tools required to create an innovative workaround.
DGI Systems were able to use tables in conjunction with data row and page break counts to create an algorithm enabling the BIRT engine to intelligently filter rows on a column and page bases for an infinite number of columns on an infionitie number of pages. The intial design placed on DevShare has since been adapted to include column dseb headings, adding scalability to to strength of the solution.
The Solution - Multi Column Reports
* 122 Customer names exist in the BIRT sample database being used below, they have been deliberately duplicated to create a large enough test sample.
** The images below show the output for the actual technical design where no attention to aesthetics has been made. Please see our demonstrations page for styled layouts.
Contact us today to organise an obligation free demonstration of our services.