Archive

Archive for the ‘BIRT’ Category

BIRT Roadshow 2011

September 9, 2011 1 comment

BIRT Roadshow 2011

Actuate Corporation (NASDAQ: BIRT), hosted the biggest BIRT Roadshow till date at Bangalore on 26th August this year, luckily could attend this event at Vivanta Taj, Bangalore. It was attended by around 700 people from various leading organisations as well as start-ups including Accenture, Capgemini, Cognizant, CSC, Ernst & Young, IBM, Infosys, Keane (News – Alert), Larsen & Toubro, Mahindra Satyam, Tata Consultancy Services (TCS) , Wipro , Popular Infotech and a big list to type.

The event was hosted by CEO Pete Cittadini and a team of BIRT experts including Mark Gamble, Technical Director Actuate Corporation to serve as an orientation to BIRT, the Eclipse Foundation Business Intelligence and Reporting Tools open source project sponsored by Actuate.

This slideshow requires JavaScript.

.

Registrants received training material, evaluation software licenses and demos. Registrants were also invited to receive their certificate of participation and access a set of BIRT resources at http://www.actuate.com/BIRT_Roadshow_India. A global contest which will award prizes for the most innovative BIRT plug-in was launched at the event. Details plus terms and conditions are available at http://www.actuate.com/birt-dev-contest/.

Being a registrant I got the opportunity to review my BIRT skills and answer the BIRT ROADSHOW Basic certification and here is my certificate 🙂

For those who dont know about Actuate Corporation,

Actuate founded and co-leads the Eclipse BIRT open source project. ActuateOne is a unified suite of products for rapidly developing and deploying BIRT-based custom Business Intelligence applications and information applications. Applications built with ActuateOne provide one user experience regardless of task or skill level; are supported by one server for any deployment including cloud and are built with one BIRT design that can access and integrate any data source – including high volume print streams. ActuateOne adds rich data visualizations, including interactivity, dashboards, analytics, and deployment options to web and mobile BIRT applications, helping organizations drive revenue through higher customer satisfaction and improved operational performance.

Actuate has over 4,800 customers globally in a diverse range of business areas including financial services and the public sector. Founded in 1993, Actuate is headquartered in San Mateo, California, with offices worldwide. Actuate is listed on NASDAQ under the symbol BIRT. For more information, visit the company’s web site at www.actuate.com or visit the BIRT community at www.birt-exchange.com.

Michael Schumaker of Bengalooru

I could make up in time only because of my Cab driver Mr. Abdul Rehman, who picked me from airport @ 8:30 AM and dropped me @ the doorstep of TAJ exactly at 9:00 AM. Rehman sahab is a Michael Schumaker when he hits the roads, he is just a traffic cutter, with an international driving experience, everytime I visit Bangalore, this is the man whom I rely on. He knows every nook and corner of Bangalore and always ready anytime anywhere. If you guys happen to go to Bangalore, Rehman is the most reliable driver, I would suggest. He can be contacted @ 09844259184.
Bangalore Cab Driver

Categories: BIRT, techbuzz Tags:

BIRT & Bangalore

Bangalore!! I really have a soft corner for this city, after all its my first job location. Its been almost 4 years, when I last visited Bangalore. Its changed entirely in terms of infrastructure and lifestyle.

Gotto to meet lots of my freinds and colleagues and had good times with them (after hours 🙂 for sure).  Gotto meet Ravi Potdar, Suraj Raut, Prasanth V M, UnniKrishan, Naresh Ganta.  All memories cherished, remembered those good old days.

Visited our very own hangout “EGL“, where I used to spend most of my time, at work and after work. Visted UBCity, it is just wonderful, Vijay Mallya really lives King Size. When I left Bangalore on 27th Nov 2007, it was under construction, and now It is one of the best architecture, I have seen. Visited “Kerala Pavillion“, the place where me along with Prasant used to regularly fill our empty stomachs.

Ohh!! let me introduce you all to Prasant VM (A very talented guy), this guy joined IBM on the same day I joined, We were staying in the same apartment at Domlur, thats not all, only after a year I came to know that this guy also shares my birthday and birth year. What a coincidence it was.

Luckily I got an opportunity to conduct a 3 days BIRT Training session in Bangalore. It was a very nice experience as a trainer. Training session was made very interactive by the much cognizant and experienced senior guys who attended the session. It headed beyond the training Agenda, I prepared because the interest shown by the attendees.

You can check out the training agenda below. If anyone interested in the Training guide, can get it on request at niraj.kakodkar@gmail.com.

Looking forward for the next trip to Bangalore on 26th August, this year for the first ever BIRT Roadshow.

Categories: BaaN, BIRT, Infor Tags: , ,

Report in Matrix format – BIRT Example 2

February 18, 2011 Leave a comment

Now that we have done through reports with dynamic columns in Example 1 in my previous post, now what about printing the report in matrix format.

This is quite simple, All you need to do is insert a crosstab in a grid without having any sort of grouping.

Below is the rptdesign XML source for further reference

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
    <property name="units">in</property>
    <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name here>></property>
    <html-property name="description">Creates a blank report with no predefined content.</html-property>
    <text-property name="displayName">Blank Report</text-property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="Data Source" id="6">
            <property name="HOME">C:\Documents and Settings\90385833\Desktop\embeddedCrosstab</property>
            <property name="DELIMTYPE">COMMA</property>
            <property name="CHARSET">UTF-8</property>
            <property name="INCLCOLUMNNAME">YES</property>
            <property name="INCLTYPELINE">NO</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.datatools.connectivity.oda.flatfile.dataSet" name="Data Set" id="7">
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">Ledger</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">Debit</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">Credit</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">Project</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">Balance</property>
                        <property name="dataType">float</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">Ledger</property>
                    <property name="nativeName">Ledger</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">Debit</property>
                    <property name="nativeName">Debit</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">Credit</property>
                    <property name="nativeName">Credit</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">Project</property>
                    <property name="nativeName">Project</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">Balance</property>
                    <property name="nativeName">Balance</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
            </list-property>
            <property name="queryText">select "Ledger", "Debit", "Credit", "Project", 
"Balance" from embeddedCrosstab.csv : {"Ledger","Ledger",INT;"Debit","Debit",DOUBLE;"Credit","Credit",DOUBLE;"
Project","Project",STRING;"Balance","Balance",DOUBLE}</property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>1.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>Ledger</design:name>
            <design:position>1</design:position>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>Ledger</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>Debit</design:name>
            <design:position>2</design:position>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>Debit</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>Credit</design:name>
            <design:position>3</design:position>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>Credit</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>Project</design:name>
            <design:position>4</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>Project</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>Balance</design:name>
            <design:position>5</design:position>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
          </design:attributes>
          <design:usageHints>
            <design:label>Balance</design:label>
            <design:formattingHints/>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
    </data-sets>
    <cubes>
        <tabular-cube name="Data Cube" id="24">
            <property name="defaultMeasureGroup">Summary Field</property>
            <property name="dimensions">
                <tabular-dimension name="Group" id="28">
                    <property name="defaultHierarchy">NewTabularHierarchy</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy" id="29">
                            <property name="levels">
                                <tabular-level name="Project" id="30">
                                    <property name="dataType">string</property>
                                    <property name="columnName">Project</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
                <tabular-dimension name="Group1" id="31">
                    <property name="defaultHierarchy">NewTabularHierarchy1</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy1" id="32">
                            <property name="levels">
                                <tabular-level name="Ledger" id="33">
                                    <property name="dataType">integer</property>
                                    <property name="columnName">Ledger</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
            </property>
            <property name="measureGroups">
                <tabular-measure-group name="Summary Field" id="25">
                    <property name="measures">
                        <tabular-measure name="Debit" id="26">
                            <expression name="measureExpression">dataSetRow["Debit"]</expression>
                            <property name="dataType">float</property>
                        </tabular-measure>
                        <tabular-measure name="Credit" id="27">
                            <expression name="measureExpression">dataSetRow["Credit"]</expression>
                            <property name="dataType">float</property>
                        </tabular-measure>
                        <tabular-measure name="Balance" id="159">
                            <expression name="measureExpression">dataSetRow["Balance"]</expression>
                            <property name="dataType">float</property>
                        </tabular-measure>
                    </property>
                </tabular-measure-group>
            </property>
            <property name="dataSet">Data Set</property>
        </tabular-cube>
    </cubes>
    <styles>
        <style name="crosstab-cell" id="4">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
        <style name="crosstab" id="5">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
    </styles>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2">
            <page-footer>
                <text id="3">
                    <property name="contentType">html</property>
                    <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
                </text>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <table id="8">
            <property name="width">100%</property>
            <property name="dataSet">Data Set</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">Ledger</property>
                    <expression name="expression">dataSetRow["Ledger"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">Debit</property>
                    <expression name="expression">dataSetRow["Debit"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">Credit</property>
                    <expression name="expression">dataSetRow["Credit"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">Project</property>
                    <expression name="expression">dataSetRow["Project"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Balance</property>
                    <expression name="expression">dataSetRow["Balance"]</expression>
                    <property name="dataType">float</property>
                </structure>
            </list-property>
            <column id="15"/>
            <header>
                <row id="9">
                    <cell id="10">
                        <label id="16">
                            <text-property name="text">Ledger</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <footer>
                <row id="13">
                    <cell id="14">
                        <extended-item extensionName="Crosstab" id="160">
                            <property name="measures">
                                <extended-item extensionName="MeasureView" id="171">
                                    <property name="measure">Balance</property>
                                    <property name="detail">
                                        <extended-item extensionName="CrosstabCell" id="172">
                                            <property name="content">
                                                <data name="Balance" id="174">
                                                    <property name="resultSetColumn">Balance</property>
                                                </data>
                                            </property>
                                        </extended-item>
                                    </property>
                                    <property name="header">
                                        <extended-item extensionName="CrosstabCell" id="173">
                                            <property name="content">
                                                <label id="175">
                                                    <text-property name="text">Balance</text-property>
                                                </label>
                                            </property>
                                        </extended-item>
                                    </property>
                                </extended-item>
                            </property>
                            <property name="rows">
                                <extended-item extensionName="CrosstabView" id="166">
                                    <property name="views">
                                        <extended-item extensionName="DimensionView" id="167">
                                            <property name="dimension">Group1</property>
                                            <property name="levels">
                                                <extended-item extensionName="LevelView" name="NewLevel View1" id="168">
                                                    <property name="level">Group1/Ledger</property>
                                                    <property name="member">
                                                        <extended-item extensionName="CrosstabCell" id="169">
                                                            <property name="content">
                                                                <data name="Ledger" id="170">
                                                                    <property name="resultSetColumn">Ledger</property>
                                                                </data>
                                                            </property>
                                                        </extended-item>
                                                    </property>
                                                </extended-item>
                                            </property>
                                        </extended-item>
                                    </property>
                                </extended-item>
                            </property>
                            <property name="columns">
                                <extended-item extensionName="CrosstabView" id="161">
                                    <property name="views">
                                        <extended-item extensionName="DimensionView" id="162">
                                            <property name="dimension">Group</property>
                                            <property name="levels">
                                                <extended-item extensionName="LevelView" name="NewLevel View" id="163">
                                                    <property name="level">Group/Project</property>
                                                    <property name="member">
                                                        <extended-item extensionName="CrosstabCell" id="164">
                                                            <property name="content">
                                                                <data name="Project" id="165">
                                                                    <property name="resultSetColumn">Project_1</property>
                                                                </data>
                                                            </property>
                                                        </extended-item>
                                                    </property>
                                                </extended-item>
                                            </property>
                                        </extended-item>
                                    </property>
                                </extended-item>
                            </property>
                            <property name="cube">Data Cube</property>
                            <list-property name="boundDataColumns">
                                <structure>
                                    <property name="name">Project_1</property>
                                    <expression name="expression">dimension["Group"]["Project"]</expression>
                                    <property name="dataType">string</property>
                                </structure>
                                <structure>
                                    <property name="name">Ledger</property>
                                    <expression name="expression">dimension["Group1"]["Ledger"]</expression>
                                    <property name="dataType">integer</property>
                                </structure>
                                <structure>
                                    <property name="name">Balance</property>
                                    <expression name="expression">measure["Balance"]</expression>
                                    <property name="dataType">float</property>
                                </structure>
                            </list-property>
                        </extended-item>
                    </cell>
                </row>
            </footer>
        </table>
    </body>
</report>

Report Output is attached below.

Categories: BaaN, BIRT, Infor Tags: ,

Variable Columns in a Report – BIRT Example

February 18, 2011 Leave a comment

There was requirement for a BIRT report with variable number of columns to be displayed for every row based on certain condition. Let me take an example to expalin the requirement more precisely.

Lets take an example of project costing, There may be “n” number of ledger accounts and for every ledger account there may be “n” number of dimensions (lets take project as a dimension to simplify the example). In a static report we will have to know the number of columns at the time of design itself but here in this case we will come to know about the columns at the runtime. So we need a report design that will display the columns dynamically based on runtime data.

Use of embedded crosstab solved the purpose.
What I had to do was just to create a Group with “Ledger” as a key and insert a crosstab in Group Header or Group Footer.

The data cube will have Grouping on Ledger and Project with summary of debit and credit. Apart from this there will be a filter which will check if the Ledger account is same to print it in respective group.

Check out the rptdesign file below, for simplification purpose I am using flatfile data source.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
    <property name="units">in</property>
    <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name here>></property>
    <html-property name="description">Creates a blank report with no predefined content.</html-property>
    <list-property name="userProperties">
        <structure>
            <property name="name">Data Cube.Data Set.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">Data Cube.Data Set.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
    </list-property>
    <property name="Data Cube.Data Set.x">135</property>
    <property name="Data Cube.Data Set.y">80</property>
    <text-property name="displayName">Blank Report</text-property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="Data Source" id="6">
            <property name="HOME">C:\Documents and Settings\90385833\Desktop\embeddedCrosstab</property>
            <property name="DELIMTYPE">COMMA</property>
            <property name="CHARSET">UTF-8</property>
            <property name="INCLCOLUMNNAME">YES</property>
            <property name="INCLTYPELINE">NO</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.datatools.connectivity.oda.flatfile.dataSet" name="Data Set" id="7">
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">Ledger</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">Debit</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">Credit</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">Project</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">Balance</property>
                        <property name="dataType">float</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">Ledger</property>
                    <property name="nativeName">Ledger</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">Debit</property>
                    <property name="nativeName">Debit</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">Credit</property>
                    <property name="nativeName">Credit</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">Project</property>
                    <property name="nativeName">Project</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">Balance</property>
                    <property name="nativeName">Balance</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
            </list-property>
            <property name="queryText">select "Ledger", "Debit", "Credit", "Project", "Balance"
 from embeddedCrosstab.csv : {"Ledger","Ledger",STRING;"Debit","Debit",DOUBLE;"Credit","Credit",
DOUBLE;"Project","Project",STRING;"Balance","Balance",DOUBLE}</property>
        </oda-data-set>
    </data-sets>
    <cubes>
        <tabular-cube name="Data Cube" id="24">
            <property name="defaultMeasureGroup">Summary Field</property>
            <property name="dimensions">
                <tabular-dimension name="Group" id="28">
                    <property name="defaultHierarchy">NewTabularHierarchy</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy" id="29">
                            <property name="levels">
                                <tabular-level name="Project" id="30">
                                    <property name="dataType">string</property>
                                    <property name="columnName">Project</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
                <tabular-dimension name="Group1" id="31">
                    <property name="defaultHierarchy">NewTabularHierarchy1</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy1" id="32">
                            <property name="levels">
                                <tabular-level name="Ledger" id="33">
                                    <property name="dataType">string</property>
                                    <property name="levelType">dynamic</property>
                                    <property name="columnName">Ledger</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
            </property>
            <property name="measureGroups">
                <tabular-measure-group name="Summary Field" id="25">
                    <property name="measures">
                        <tabular-measure name="Debit" id="26">
                            <expression name="measureExpression">dataSetRow["Debit"]</expression>
                            <property name="dataType">float</property>
                        </tabular-measure>
                        <tabular-measure name="Credit" id="27">
                            <expression name="measureExpression">dataSetRow["Credit"]</expression>
                            <property name="dataType">float</property>
                        </tabular-measure>
                    </property>
                </tabular-measure-group>
            </property>
            <property name="dataSet">Data Set</property>
        </tabular-cube>
    </cubes>
    <styles>
        <style name="crosstab-cell" id="4">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
        <style name="crosstab" id="5">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
    </styles>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2">
            <page-header>
                <image id="105">
                    <property name="source">embed</property>
                    <property name="imageName">nk.bmp</property>
                </image>
            </page-header>
            <page-footer>
                <text id="3">
                    <property name="contentType">html</property>
                    <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
                </text>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <table id="8">
            <property name="width">100%</property>
            <property name="dataSet">Data Set</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">Ledger</property>
                    <expression name="expression">dataSetRow["Ledger"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Debit</property>
                    <expression name="expression">dataSetRow["Debit"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">Credit</property>
                    <expression name="expression">dataSetRow["Credit"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">Project</property>
                    <expression name="expression">dataSetRow["Project"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Balance</property>
                    <expression name="expression">dataSetRow["Balance"]</expression>
                    <property name="dataType">float</property>
                </structure>
            </list-property>
            <column id="15"/>
            <header>
                <row id="9">
                    <cell id="10">
                        <label id="16">
                            <property name="backgroundColor">#B5FDBA</property>
                            <property name="fontWeight">bold</property>
                            <text-property name="text">Variable Columns for Rows - BIRT Example 1 </text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <group id="18">
                <property name="groupName">NewTableGroup1</property>
                <property name="interval">none</property>
                <property name="sortDirection">asc</property>
                <expression name="keyExpr">row["Ledger"]</expression>
                <structure name="toc">
                    <expression name="expressionValue">row["Ledger"]</expression>
                </structure>
                <property name="repeatHeader">true</property>
                <property name="hideDetail">false</property>
                <property name="pageBreakAfter">auto</property>
                <property name="pageBreakBefore">auto</property>
                <property name="pageBreakInside">auto</property>
                <header>
                    <row id="84">
                        <cell id="85">
                            <data id="86">
                                <property name="backgroundColor">#FFFFD7</property>
                                <property name="fontWeight">bold</property>
                                <property name="resultSetColumn">Ledger</property>
                            </data>
                        </cell>
                    </row>
                </header>
                <footer>
                    <row id="21">
                        <cell id="22">
                            <extended-item extensionName="Crosstab" id="63">
                                <property name="measureDirection">vertical</property>
                                <property name="measures">
                                    <extended-item extensionName="MeasureView" id="74">
                                        <property name="measure">Debit</property>
                                        <property name="detail">
                                            <extended-item extensionName="CrosstabCell" id="75">
                                                <property name="content">
                                                    <data name="Debit" id="77">
                                                        <property name="resultSetColumn">Debit</property>
                                                    </data>
                                                </property>
                                            </extended-item>
                                        </property>
                                        <property name="aggregations">
                                            <extended-item extensionName="AggregationCell" id="88">
                                                <property name="aggregationOnRow">Group1/Ledger</property>
                                                <property name="content">
                                                    <data id="89">
                                                        <property name="resultSetColumn">Debit_Group1/Ledger</property>
                                                    </data>
                                                </property>
                                            </extended-item>
                                        </property>
                                        <property name="header">
                                            <extended-item extensionName="CrosstabCell" id="76">
                                                <property name="content">
                                                    <label id="78">
                                                        <property name="backgroundColor">#DFFFFF</property>
                                                        <text-property name="text">Debit</text-property>
                                                    </label>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                    <extended-item extensionName="MeasureView" id="79">
                                        <property name="measure">Credit</property>
                                        <property name="detail">
                                            <extended-item extensionName="CrosstabCell" id="80">
                                                <property name="content">
                                                    <data name="Credit" id="82">
                                                        <property name="resultSetColumn">Credit</property>
                                                    </data>
                                                </property>
                                            </extended-item>
                                        </property>
                                        <property name="aggregations">
                                            <extended-item extensionName="AggregationCell" id="90">
                                                <property name="aggregationOnRow">Group1/Ledger</property>
                                                <property name="content">
                                                    <data id="91">
                                                        <property name="resultSetColumn">Credit_Group1/Ledger</property>
                                                    </data>
                                                </property>
                                            </extended-item>
                                        </property>
                                        <property name="header">
                                            <extended-item extensionName="CrosstabCell" id="81">
                                                <property name="content">
                                                    <label id="83">
                                                        <property name="backgroundColor">#DFFFFF</property>
                                                        <text-property name="text">Credit</text-property>
                                                    </label>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                                <property name="rows">
                                    <extended-item extensionName="CrosstabView" id="64">
                                        <property name="views">
                                            <extended-item extensionName="DimensionView" id="65">
                                                <property name="dimension">Group1</property>
                                                <property name="levels">
                                                    <extended-item extensionName="LevelView" name="NewLevel View" id="66">
                                                        <property name="level">Group1/Ledger</property>
                                                        <property name="filter">
                                                            <filter-condition-element>
                                                                <expression name="expr">data["Ledger"]</expression>
                                                                <property name="operator">eq</property>
                                                                <simple-property-list name="value1">
                                                                    <value>row["Ledger"]</value>
                                                                </simple-property-list>
                                                            </filter-condition-element>
                                                        </property>
                                                        <property name="member">
                                                            <extended-item extensionName="CrosstabCell" id="67">
                                                                <property name="content">
                                                                    <data name="Ledger" id="68">
                                                                        <property name="backgroundColor">#DFFFFF</property>
                                                                        <property name="resultSetColumn">Ledger</property>
                                                                    </data>
                                                                </property>
                                                                <property name="width">1in</property>
                                                            </extended-item>
                                                        </property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                                <property name="columns">
                                    <extended-item extensionName="CrosstabView" id="69">
                                        <property name="grandTotal">
                                            <extended-item extensionName="CrosstabCell" id="87">
                                                <property name="content">
                                                    <label id="92">
                                                        <property name="backgroundColor">#DFFFFF</property>
                                                        <text-property name="text">Grand Total</text-property>
                                                    </label>
                                                </property>
                                            </extended-item>
                                        </property>
                                        <property name="views">
                                            <extended-item extensionName="DimensionView" id="70">
                                                <property name="dimension">Group</property>
                                                <property name="levels">
                                                    <extended-item extensionName="LevelView" name="NewLevel View1" id="71">
                                                        <property name="level">Group/Project</property>
                                                        <property name="member">
                                                            <extended-item extensionName="CrosstabCell" id="72">
                                                                <property name="content">
                                                                    <data name="Project" id="73">
                                                                        <property name="backgroundColor">#DFFFFF</property>
                                                                        <property name="resultSetColumn">Project</property>
                                                                    </data>
                                                                </property>
                                                            </extended-item>
                                                        </property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                                <property name="cube">Data Cube</property>
                                <list-property name="boundDataColumns">
                                    <structure>
                                        <property name="name">Ledger</property>
                                        <expression name="expression">dimension["Group1"]["Ledger"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Project</property>
                                        <expression name="expression">dimension["Group"]["Project"]</expression>
                                        <property name="dataType">string</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Debit</property>
                                        <expression name="expression">measure["Debit"]</expression>
                                        <property name="dataType">float</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Credit</property>
                                        <expression name="expression">measure["Credit"]</expression>
                                        <property name="dataType">float</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Debit_Group1/Ledger</property>
                                        <expression name="expression">measure["Debit"]</expression>
                                        <property name="dataType">float</property>
                                        <simple-property-list name="aggregateOn">
                                            <value>Group1/Ledger</value>
                                        </simple-property-list>
                                        <property name="aggregateFunction">sum</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Credit_Group1/Ledger</property>
                                        <expression name="expression">measure["Credit"]</expression>
                                        <property name="dataType">float</property>
                                        <simple-property-list name="aggregateOn">
                                            <value>Group1/Ledger</value>
                                        </simple-property-list>
                                        <property name="aggregateFunction">sum</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Debit_Group/Project</property>
                                        <expression name="expression">measure["Debit"]</expression>
                                        <property name="dataType">float</property>
                                        <simple-property-list name="aggregateOn">
                                            <value>Group/Project</value>
                                        </simple-property-list>
                                        <property name="aggregateFunction">sum</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Credit_Group/Project</property>
                                        <expression name="expression">measure["Credit"]</expression>
                                        <property name="dataType">float</property>
                                        <simple-property-list name="aggregateOn">
                                            <value>Group/Project</value>
                                        </simple-property-list>
                                        <property name="aggregateFunction">sum</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Debit_1</property>
                                        <expression name="expression">measure["Debit"]</expression>
                                        <property name="dataType">float</property>
                                        <property name="aggregateFunction">sum</property>
                                    </structure>
                                    <structure>
                                        <property name="name">Credit_1</property>
                                        <expression name="expression">measure["Credit"]</expression>
                                        <property name="dataType">float</property>
                                        <property name="aggregateFunction">sum</property>
                                    </structure>
                                </list-property>
                            </extended-item>
                        </cell>
                    </row>
                </footer>
            </group>
            <footer>
                <row id="13">
                    <cell id="14"/>
                </row>
            </footer>
        </table>
    </body>
    <list-property name="images">
        <structure>
            <property name="name">logo.jpg</property>
            <property name="data">            </property>
        </structure>
        <structure>
            <property name="name">nk.bmp</property>
            <property name="data">
            
            </property>
        </structure>
    </list-property>
</report>


Attached is the output report

Categories: BaaN, BIRT, Infor Tags:

Brand your Eclipse Application

December 22, 2010 Leave a comment

Thought of changing the splash screen that appears @ the start in Helios, its pretty simple , just replace the splash.BMP image in the plugin folder below

\plugins\org.eclipse.platform_3.6.0.v201006080911

checkout my ssplash screen

More Branding details can found @ Branding Options

Categories: BIRT, Infor Tags: ,

Infor BDB plugins on HELIOS

December 22, 2010 Leave a comment

Got some time today to look into BIRT again, I am trying to integrate Google Maps with BIRT Report, the requirement is for service Module wherein I need to show the closest Service Man available and display it visually in maps.

While doing this was just going through BIRT references, The ECLIPSE verion which I am using was 2.1, far behind the current HELIOS. So just thought of downloading HELIOS and install the INFOR plugin in HELIOS to make it work . You simply need to copy the plugins from 2.1 and paste in the plugin folder of 2.6, nothing else and it worked perfectly.

Infor is simply using the JDBC-ODA driver with some customisation, I tried to check if I can modify the jar files but no source included, only class files and a declaimer stating no changes to be done prior to written permission :), so it stops me from decompiling those class files.

Categories: BIRT, Infor Tags: ,

My First BIRT Report for Infor LN

December 18, 2010 2 comments

Finally after spending a day navigating through the BIRT controls, successful to print a pie chart for Item Inventory maintained in Infor LN.  The Infor plugins really works great, as I have already mentioned in my previous post. It shows the package wise biforcation of all the tables with the description of the tables as well as the table field, so its very easy for even a newbie to identify the LN tables. This was very much impressive.

The controls and navigation are very well placed. Various Charts,Graphs included and very easy and user freindly configuration. The Best Part is you can write your own script compliant to ECMA standards as per your requirement. The reports can be published in HTML, PDF, XLS etc.

 BIRT Rocks … I enjoyed working on it. Will keep on updating. 

Check out my first BIRT Report.

Now the next step will be call the BIRT report from any external application not necessarily a web application, main purpose is to open the BIRT Reports through LN Worktop and not webtop and finally trying it on mobile devices.

The best thing is BIRT is available for (IOS,Android,Windows etc). Its so very flexisible I can change the entire layout styling, import my own CSS, too good.

Categories: BIRT, Infor Tags: ,
%d bloggers like this: