The Digital Voice

BIRT: Fix for Preview Tab After Updating to IE11

2014-10-03T14:38:00.001-06:00

I've come across this issue before, but never had a really good fix until now. It seems that Internet Explorer 11 has all sorts of incompatibilities it introduced, and one of which is with Eclipse. I first encountered it when trying to Preview report designs from withing the Eclipse BIRT Report Designer. It just hangs, it never runs the report. The fix to get preview working again in BIRT is as follows: Change the following Windows Registry Keys HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main\FeaturControl\FEATURE_BROWSER_EMULATION jawaw.exe=9000 change to 9999 eclipse.exe=9000 change to 9999 This fixed the Preview issue. Alternatively, you can change to use an External Browser in Window/Preferences/Report Design/Preview. But this will only work if you go to the Run/View in Web Viewer option.

Gaming: NVidia Shield Portable

2014-08-22T17:12:00.000-06:00

NVidia just recently released their new gaming portable, the NVidia Tablet. I just picked one up and will give my thoughts on it separately. This article is about it predecessor, the NVidia Shield, recently renamed the NVidia Shield Portable. Let me first go on to say, after a full year of using this device, I absolutely LOVE, LOVE, LOVE this device. It has become a constant companion for me wherever I go. Seriously. I do a lot of business travel these days, and I bring the NVidia Shield Portable with me more than I do my laptop. When I am around the house, I use the Shield more than I do any of my gaming consoles. I play it from bed, I play it when sitting on the couch. When I travel, the HDMI output goes right into the hotels TV, and if they have something stupid blocking it to try to force hotel content on you, I use my little Brookstone pico projector. So what makes this device so useful? I could go on about ram, storage, Tegra processors, blah blah blah. This is covered more in depth by the many gaming and tech sites out there. I don't need to cover that, its a dead horse at this point. What makes this so useful to me is games. In particular, emulators. I have been waiting for a device like this since the late 90's when the first emulators for NES and SNES hit the scene, when Nesticle and Genecyst first came out and made light year leaps and bounds over the slow and buggy emulators at the time and made console gaming on a PC a reality, I have been waiting for the day when it would hit a handheld form and have every retro system I love in one package. The PSP did a damned good job of this, but it required a hacked PSP. While nowadays it's childs play to hack the PSP, the Shield does everything I want out of the box and more. Emulates every system from the 2600 - PSOne full speed? Check. N64 most games at full speed, including Super Smash Bros, check. Netflix? Check. XBMC? Check. Mame arcade emulator? Check. Touch screen for supporting all games available for the Android? Check. A set of exclusives that take advantage of the awesome power of the Tegra processor, including support for the controller built into it? Check. Support for external controllers, through both bluetooth and USB (this includes the two bluetooth controllers that go with the Gamestick?)? Check. Ability to emulate a PC via PC emulators, so I can use a bluetooth keyboard and mouse and play old PC games? Check. All the other Android capabilities, such as web browser, email, and anything else in the App Store? The next thing is the form factor. A lot of people gripe about the clamshell design. For me, it works surprisingly well. Because it is portable and the screen folds out, I can play this in bed, or close the screen and hook up the HDMI and not have the Shield in the way. I only have one gripe about the device. 1 Single gripe. And that is the cross on the controller. For everything else that is so perfect about this device, that cross tends to "slide", making control with the cross a huge pain. Sometimes games will register an "up" instead of a "left" push because the cheap plastic on it has shifted to the top left. For most games, this is not a problem. But with certain precision games on the NES and SNES where timing of certain movements is key, it tends to flake, leaving a lot of reloaded save states. I hate having to use save states, but it becomes a necessity when you know that darn cross is going to get you killed. If I am using an XBox wires controller or the Gamesticks bluetooth controller, this isn't a problem. But I shouldn't have to rely on an external controller for precision control. Overall, this NVidia Shield Portable is, without a doubt, my favorite gaming device of all time. It has replaced my modded Wii and PSP as my goto gaming device for emulation. When I'm stuck in some crappy hotel, and I don't want to game, I can fire up Netflix and watch the new season of the Killing or House of Cards, or fire up XBMC and watch that last episode of Bobs Burgers that is sitting on my DVR at home and I can't get to. While I am excited to try out the NVidia Shield Tablet due to it's increased speed, I don't know that it will be replacing my Shield Portable simply because a tablet form factor isn't more convenient for me. When I spend some time with it I will write up a review and let you know.

First Tutorial Video Release: BIRT Report Examples View

2013-09-05T06:04:00.002-06:00

We started releasing a series of tutorial videos on YouTube. The first one, starring yours truly, is up right now. It covers a little known and under utilized area of the BIRT Designer containing a whole set of example reports. Check it out.

BIRT: Using JSON

2013-08-08T15:15:00.002-06:00

This topic has come up quite a bit. Using JSON in BIRT Reports. This comes up for just about everything, from using as a Data Source to serializing large amounts of parameters for use in a report design. Seriously, lots of stuff.

Since the Rhino engine has not been updated to a version passed 1.7R4, there is no access to the nice Rhino JSON methods. So, we have have a few options. Since Rhino can use anything in the Java JVM, we can use any 3rd party JSON parser out there. My preference is Google GSON library. The caveat is that you must build the object structure beforehand in Java, and then use the GSON to parse a string into the object representation.

There are other options as well, such as these:
http://www.birt-exchange.org/devshare/_/designing-birt-reports/1053-scripted-data-source-using-json

I ran across the old school method of using an eval() statement to do the same thing. While not as safe, this is a much simpler, quicker method, and will suffice in most cases. And example can be found here: http://www.birt-exchange.org/devshare/_/designing-birt-reports/birt-json-scripted-data-set-and-parameter-parsing-r1484

Update: Kristopher Clark, whom is a very talented member of the BIRT community, posted something similar. In his example, he is using Apache Commons to stream in a JSON file and use as a scripted data source. This showcases BIRT's ability to leverage anything within the Java Classpath in a report execution.

BIRT: BIRT DaVinci Plugin

2013-08-08T14:53:00.000-06:00

Recently, I had the opportunity to catch up with the author of BIRT Chart DaVinci, Keith Howard, at a BIRT get together in the Bay Area. I had previously blogged about Chart DaVinci, so it's no secret that I like it. But there was always one little issue for me, and that was the manual application of the scripts. So, after chatting with Keith, we came up with a solution. Why not build a plugin for BIRT that displays all the styles in Chart DaVinci in a gallery that the user can select and apply to a report, and the plug-in does all the work. And that is exactly what I built. So, without further ado, the BIRT Chart DaVinci Plugin is available over at the BIRT Exchange. Follow the instructions and start applying some slick, pre-done styles to your BIRT charts.

BIRT: Report to get available Emitter ID's

2013-07-17T16:32:00.002-06:00

Below is an example report that demonstrates how to get a list of available Emitters and their ID's and Formats from the Report Engine within a BIRT Report. Good thing the entire Report Engine API and Design Engine API are available within a report.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.2.1.v201209101448 Build &lt;4.2.1.v20120912-1721></property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" 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>
        <style name="crosstab" id="6">
            <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>
        <text-data id="7">
            <expression name="valueExpr">var x = 0;&#13;
var emitterInfo = reportContext.getReportRunnable().getReportEngine().getEmitterInfo();&#13;
&#13;
var sb = new Packages.java.lang.StringBuilder();&#13;
&#13;
for (x = 0; x &lt; emitterInfo.length; x++)&#13;
        {&#13;
            var info = emitterInfo[x];&#13;
            &#13;
            var id = info.getID();&#13;
            var format = info.getFormat();&#13;
            &#13;
            sb.append(id + " - " + format + "&lt;br>\n");&#13;
        }&#13;
        &#13;
sb.toString();</expression>
            <property name="contentType">html</property>
        </text-data>
    </body>
</report>

BIRT: Writing BIRT ODA's

2012-12-13T12:14:00.000-07:00

New article on writing ODA's for BIRT has been published on IBM Developerworks. As an added bonus, learn about the BIRT Data Extraction Task. Two kinds of awesome in one place. Check it out.

http://www.ibm.com/developerworks/library/ba-birtextpoints/

BIRT: Emitters Tutorial Posted

2012-09-18T16:04:00.003-06:00

Finally got around to writing some articles. I have one published for IBM DeveloperWorks about writing for the BIRT Emitter Framework. Check it out.

http://www.ibm.com/developerworks/library/ba-birt-emitter/index.html

BIRT: The Pipeline

2012-06-17T17:04:00.000-06:00

So many different things in the works at the moment. I have several proposals out for articles to be published relating to BIRT. It seems I can't stray too far from BIRT, which is great because now I have the freedom to pick and choose what I do with it. I'm also working with a lot of GWT stuff ramping up for a major development effort with my new job. This is great because I am getting a chance to catch up on a lot of newer technologies that have been introduced into GWT over the past few years that I have fallen behind on, such as the RequestFactory framework. I will also starting writing a little more. I need to keep track of all these new findings, and I enjoyed sharing that work with the community when I was more active in writing. I'll keep things posted here.

GWT: Getting Maven Generated GWT Project working within Eclipse

2012-05-03T10:48:00.002-06:00

Recent events have thrust me back into the world of GWT Development. So much has changed. RequestFactories, EventBuses, all sorts of improvements. I haven’t had to dig this deep in a while. But these are great improvements, and they take GWT that extra mile.

The source of my recent aggravations hasn’t been with GWT. It has been with Maven. Maven is a wonderful build tool. There is something really nice about being able to say “Hey, Maven, I want to build this project, and it has these dependencies”, and having Maven go out and fetch everything, set up a class path, and build. Awesome. Or at least in theory. One of my biggest headaches has been building Eclipse Plugins, but that will wait until another blog post.

This one is about GWT, Eclipse, and Maven. Now my Eclipse setup is pretty straight forward. I use the BIRT All-In-One 3.7.2 distribution, with the m2eclipse plugin installed separately (because the BIRT distribution has an incomplete m2eclipse plugin installed), the GWT Designer and Window Builder Plugins, and Googles Eclipse GWT Plugin (well, technically GWT Designer and the GWT Eclipse Plugin are BOTH Googles now….).

“So why so glum, chum?” I ask myself. Well, because things don’t quite work as advertised out of the box. GWT Designer and the GWT Eclipse Plugin provide AWESOME support for creating new projects and making things just work. Maven, no so much. What doesn’t work? Well, besides the thousands of red ‘X’ everywhere in Eclipse, GWT Designer doesn’t work, and the Google Eclipse Plugin run doesn’t quite work. At least with GWT 2.4, and the 3.7.2 Indigo setup of Eclipse. So, let me outline how I fixed these annoying issues with a step by step on creating a new GWT project with Maven and making the necessary fixes in Eclipse to make things work. I won’t cover getting RequestFactory working, I’ll leave that for the next post.

1. Create a new Maven. Start by going to New/Other.

2. Select Maven/Maven Project.

3. Leave everything alone on the next page of the wizard.

4. On the next screen, for the archetype, enter “gwt-maven-plugin”. (Note: m2eclipse does something really stupid in my environment (or maybe all environments in general, I havent investigated it further) where it will refuse to create more than one project of the same archtype in my workspace. In order to resolve this, I need to go and completely delete my .m2 respository, located at /.m2, and let it re-index). If you haven’t indexed your Maven repository before, it might take a while, so be patient and let it pop up in the grid.

5. Fill out the appropriate info for the Maven project, such as Group and Artifact ID.

6. Click Finish.

OK, cool, now we have a GWT project in Eclipse. In fact, you can run it if you right-mouse click on the project, Run/Maven Build…, and set the goal to gwt:run.

But the project will have a lot of Red ‘X’.

And it won’t run in Eclipse, which means I can’t debug it. But it will run just fine in Maven. But I don’t want it to run in Maven, I want it to run in Eclipse. Why do I want it to run in Eclipse? Because I want to use all of those really nifty debug capabilities. Otherwise, why bother using GWT, I could just use some other Javascript framework, like Jquery, or Dojo. So, how do I get to the point where I can run and debug?

First things last. Lets get rid of all of those ugly errors. One of the biggest causes of the red ‘X’ is the reliance on the generated source files that Maven builds for the Internationalization and the Asyncronous interface. So I need to get these files there. The easiest way is to have Maven generate the source files for me and copy them over.

First, I go to Run/Maven – Generate Sources.

This will create the source files under /target/generated-sources/gwt//. Since most of these errors are coming from missing client source, I just need to copy them all over to the /src/main/java//client folder.

Now, I need to tell Maven not to generate these files, otherwise I will get an error telling me there are duplicate classes. Edit the POM, and remove the generateAsync and i18n goals. That section should look like the following when done.

<groupId>org.codehaus.mojogroupId>

<artifactId>gwt-maven-pluginartifactId>

<version>2.4.0version>

<goals>

<goal>compilegoal>

<goal>testgoal>

goals>

execution>

executions>

But there are still some Red X. Why? The field verifier class is not being found. To fix this, I just went to Project/Clean. Strange, but that fixed it.

So, I still have a red X on my project, but I will ignore that since this is some Maven specific junk.

So, I want to try to run my project in Eclipse now to see what happens.

Run/Maven Build…, and set the goal to gwt:eclipse.

This will generate a Launch file. Refresh the project and it will appear. But there is a problem. If I try to launch it, I will get the following error.

This will resolve itself if I go to Run Configuration, and edit the Run configuration for the new project, and go to any of the other tabs. If it doesn't, find the DevMode class from the Search Dialog. But another problem manifests itself at this point. No modules appear under Available Modules.

You’re killing me… If I try to run this, I just get the help dialog for the GWT Dev Mode. But this is a simple fix also. All I need to do is Close this dialog. Right-Mouse click on the project or hit Alt-Enter to bring up the Projects Property Editor, and go under the Source section. Under the Source section, select the Excluded item under Sample/src/main/resource, and hit the Remove button.

When I go back to edit the Run Configuration, my SampleModule will be back.

And not only did this step fix the problem with the Launch configuration, it also fixed another issue where files could not be opened with the GWT Designer Window Builder editor.

I visited a lot of sites researching this issue, and that last step was nowhere to be found, and was erroneously reported as being some issue with Eclipse not finding the gwt.xml unless it was in the first source directory it encounters. This may have been the case in previous version of Eclipse, but in Indigo this solved my problem.

So there you go. If you followed these steps, you should have a setup that is as close to the project that Maven generated and still be able to run in Eclipse so you can use it’s debugging capabilities. This definitly isn’t as nice as the New Project wizards, but hey, its Mavenized, and it’s a GWT project. Or at least it’s a GWT-RPC based GWT project, and not a RequestFactory one. But that’s another story…

BIRT: Dynamically Hiding/Showing Table Columns in a Report Design

2012-04-10T11:42:00.002-06:00

This question gets asked quite often in the BIRT Exchange Forums. How can I dynamically show/hide columns in a table based on user input/some object property.

The first inclination is to try to dynamically build the table on the fly. This is an often time consuming and cumbersome way of approaching the problem, and will more often than not cause unforeseen errors. The easiest approach is to just have the table display normally, and hide the column using Visibility Expressions.

So for example, I have a table that displays Customer information. I want to give the user the ability to show/hide columns that they want displayed in their reports.

1. Select the table in the report

2. Select a column

3. In the Property Editor, select Visibility Expression.

4. Check the Hide Element option.
5. Enter an expression that will return True when the column should be hidden.

In my case, I have a function defined globally that will check for the existence of a keyed value in a global map. This map gets set in the reports beforeFactory event. Realistically, you would just test the report parameters value, but I am demonstrating this from objects instead of report parameters.

The example report is below. In it, if you check/uncheck a parameter, it will show or hide that field in the table.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905 Build &lt;3.7.1.v20110905-1820></property>
    <property name="units">in</property>
    <method name="initialize"><![CDATA[//
//Predefined function to help check if a field is set to be hidden in the map
//
function checkField(fieldToCheck)
{
    //make sure the global variable is not null
    if (reportContext.getGlobalVariable("hideMap") != null)
    {
        //get the appropriate field. If this is set, then we know this is set and
        //we can return true. Otherwise return false, meaning we want to show the field.
        if (reportContext.getGlobalVariable("hideMap").get(fieldToCheck) != null)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    else
    {
            return false;
    }
}

]]></method>
    <method name="beforeFactory"><![CDATA[//initialize the global variable
reportContext.setGlobalVariable("hideMap", new Packages.java.util.HashMap());

//set the appropriate values in the global HashMap based on if it is set in the report parameter
if (params["ShowCustomerNumber"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("CUSTOMERNUMBER", Boolean.TRUE);
}

if (params["ShowCustomerName"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("CUSTOMERNAME", Boolean.TRUE);
}

if (params["ShowCONTACTLASTNAME"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("CONTACTLASTNAME", Boolean.TRUE);
}

if (params["ShowCONTACTFIRSTNAME"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("CONTACTFIRSTNAME", Boolean.TRUE);
}

if (params["ShowPHONE"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("PHONE", Boolean.TRUE);
}

if (params["ShowADDRESSLINE1"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("ADDRESSLINE1", Boolean.TRUE);
}

if (params["ShowCITY"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("CITY", Boolean.TRUE);
}

if (params["ShowSTATE"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("STATE", Boolean.TRUE);
}

if (params["ShowPOSTALCODE"].value == false)
{
    reportContext.getGlobalVariable("hideMap").put("POSTALCODE", Boolean.TRUE);
}]]></method>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="ShowCustomerNumber" id="91">
            <text-property name="promptText">Uncheck to hide field CustomerNumber</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowCustomerName" id="92">
            <text-property name="promptText">Uncheck to hide field CustomerName</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowCONTACTLASTNAME" id="93">
            <text-property name="promptText">Uncheck to hide field CONTACTLASTNAME</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowCONTACTFIRSTNAME" id="94">
            <text-property name="promptText">Uncheck to hide field CONTACTFIRSTNAME</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowPHONE" id="95">
            <text-property name="promptText">Uncheck to hide field PHONE</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowADDRESSLINE1" id="96">
            <text-property name="promptText">Uncheck to hide field ADDRESSLINE1</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowCITY" id="97">
            <text-property name="promptText">Uncheck to hide field CITY</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowSTATE" id="98">
            <text-property name="promptText">Uncheck to hide field STATE</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="ShowPOSTALCODE" id="99">
            <text-property name="promptText">Uncheck to hide field POSTALCODE</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">True</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
            <property name="odaURL">jdbc:classicmodels:sampledb</property>
            <property name="odaUser">ClassicModels</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="setGetCustomers" id="8">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">CUSTOMERNUMBER</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">CUSTOMERNUMBER</text-property>
                    <text-property name="heading">CUSTOMERNUMBER</text-property>
                </structure>
                <structure>
                    <property name="columnName">CUSTOMERNAME</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">CUSTOMERNAME</text-property>
                    <text-property name="heading">CUSTOMERNAME</text-property>
                </structure>
                <structure>
                    <property name="columnName">CONTACTLASTNAME</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">CONTACTLASTNAME</text-property>
                    <text-property name="heading">CONTACTLASTNAME</text-property>
                </structure>
                <structure>
                    <property name="columnName">CONTACTFIRSTNAME</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">CONTACTFIRSTNAME</text-property>
                    <text-property name="heading">CONTACTFIRSTNAME</text-property>
                </structure>
                <structure>
                    <property name="columnName">PHONE</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">PHONE</text-property>
                    <text-property name="heading">PHONE</text-property>
                </structure>
                <structure>
                    <property name="columnName">ADDRESSLINE1</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">ADDRESSLINE1</text-property>
                    <text-property name="heading">ADDRESSLINE1</text-property>
                </structure>
                <structure>
                    <property name="columnName">ADDRESSLINE2</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">ADDRESSLINE2</text-property>
                    <text-property name="heading">ADDRESSLINE2</text-property>
                </structure>
                <structure>
                    <property name="columnName">CITY</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">CITY</text-property>
                    <text-property name="heading">CITY</text-property>
                </structure>
                <structure>
                    <property name="columnName">STATE</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">STATE</text-property>
                    <text-property name="heading">STATE</text-property>
                </structure>
                <structure>
                    <property name="columnName">POSTALCODE</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">POSTALCODE</text-property>
                    <text-property name="heading">POSTALCODE</text-property>
                </structure>
                <structure>
                    <property name="columnName">COUNTRY</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">COUNTRY</text-property>
                    <text-property name="heading">COUNTRY</text-property>
                </structure>
                <structure>
                    <property name="columnName">SALESREPEMPLOYEENUMBER</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">SALESREPEMPLOYEENUMBER</text-property>
                    <text-property name="heading">SALESREPEMPLOYEENUMBER</text-property>
                </structure>
                <structure>
                    <property name="columnName">CREDITLIMIT</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">CREDITLIMIT</text-property>
                    <text-property name="heading">CREDITLIMIT</text-property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">CUSTOMERNUMBER</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">CUSTOMERNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">CONTACTLASTNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">CONTACTFIRSTNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">PHONE</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">ADDRESSLINE1</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">ADDRESSLINE2</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">CITY</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">STATE</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">POSTALCODE</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">COUNTRY</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">SALESREPEMPLOYEENUMBER</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">CREDITLIMIT</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">CUSTOMERNUMBER</property>
                    <property name="nativeName">CUSTOMERNUMBER</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">CUSTOMERNAME</property>
                    <property name="nativeName">CUSTOMERNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">CONTACTLASTNAME</property>
                    <property name="nativeName">CONTACTLASTNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">CONTACTFIRSTNAME</property>
                    <property name="nativeName">CONTACTFIRSTNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">PHONE</property>
                    <property name="nativeName">PHONE</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">ADDRESSLINE1</property>
                    <property name="nativeName">ADDRESSLINE1</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">ADDRESSLINE2</property>
                    <property name="nativeName">ADDRESSLINE2</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">CITY</property>
                    <property name="nativeName">CITY</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">STATE</property>
                    <property name="nativeName">STATE</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">POSTALCODE</property>
                    <property name="nativeName">POSTALCODE</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">COUNTRY</property>
                    <property name="nativeName">COUNTRY</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">SALESREPEMPLOYEENUMBER</property>
                    <property name="nativeName">SALESREPEMPLOYEENUMBER</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">CREDITLIMIT</property>
                    <property name="nativeName">CREDITLIMIT</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select *
from CLASSICMODELS.CUSTOMERS]]></xml-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>2.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CUSTOMERNUMBER</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CUSTOMERNUMBER</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CUSTOMERNUMBER</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CUSTOMERNAME</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CUSTOMERNAME</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CUSTOMERNAME</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CONTACTLASTNAME</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CONTACTLASTNAME</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CONTACTLASTNAME</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CONTACTFIRSTNAME</design:name>
              <design:position>4</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CONTACTFIRSTNAME</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CONTACTFIRSTNAME</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>PHONE</design:name>
              <design:position>5</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>PHONE</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>PHONE</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>ADDRESSLINE1</design:name>
              <design:position>6</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>ADDRESSLINE1</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>ADDRESSLINE1</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>ADDRESSLINE2</design:name>
              <design:position>7</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>ADDRESSLINE2</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>ADDRESSLINE2</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CITY</design:name>
              <design:position>8</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CITY</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CITY</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>STATE</design:name>
              <design:position>9</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>STATE</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>STATE</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>POSTALCODE</design:name>
              <design:position>10</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>15</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>POSTALCODE</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>POSTALCODE</design:label>
            <design:formattingHints>
              <design:displaySize>15</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>COUNTRY</design:name>
              <design:position>11</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>COUNTRY</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>COUNTRY</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>SALESREPEMPLOYEENUMBER</design:name>
              <design:position>12</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>SALESREPEMPLOYEENUMBER</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>SALESREPEMPLOYEENUMBER</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CREDITLIMIT</design:name>
              <design:position>13</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>15</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CREDITLIMIT</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CREDITLIMIT</design:label>
            <design:formattingHints>
              <design:displaySize>22</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" 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>
        <style name="crosstab" id="6">
            <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="9">
            <property name="dataSet">setGetCustomers</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">CUSTOMERNUMBER</property>
                    <text-property name="displayName">CUSTOMERNUMBER</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">CUSTOMERNAME</property>
                    <text-property name="displayName">CUSTOMERNAME</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CUSTOMERNAME"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CONTACTLASTNAME</property>
                    <text-property name="displayName">CONTACTLASTNAME</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CONTACTLASTNAME"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CONTACTFIRSTNAME</property>
                    <text-property name="displayName">CONTACTFIRSTNAME</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CONTACTFIRSTNAME"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">PHONE</property>
                    <text-property name="displayName">PHONE</text-property>
                    <expression name="expression" type="javascript">dataSetRow["PHONE"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">ADDRESSLINE1</property>
                    <text-property name="displayName">ADDRESSLINE1</text-property>
                    <expression name="expression" type="javascript">dataSetRow["ADDRESSLINE1"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">ADDRESSLINE2</property>
                    <text-property name="displayName">ADDRESSLINE2</text-property>
                    <expression name="expression" type="javascript">dataSetRow["ADDRESSLINE2"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CITY</property>
                    <text-property name="displayName">CITY</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CITY"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">STATE</property>
                    <text-property name="displayName">STATE</text-property>
                    <expression name="expression" type="javascript">dataSetRow["STATE"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">POSTALCODE</property>
                    <text-property name="displayName">POSTALCODE</text-property>
                    <expression name="expression" type="javascript">dataSetRow["POSTALCODE"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">COUNTRY</property>
                    <text-property name="displayName">COUNTRY</text-property>
                    <expression name="expression" type="javascript">dataSetRow["COUNTRY"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">SALESREPEMPLOYEENUMBER</property>
                    <text-property name="displayName">SALESREPEMPLOYEENUMBER</text-property>
                    <expression name="expression" type="javascript">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">CREDITLIMIT</property>
                    <text-property name="displayName">CREDITLIMIT</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CREDITLIMIT"]</expression>
                    <property name="dataType">float</property>
                </structure>
            </list-property>
            <column id="78">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("CUSTOMERNUMBER");</expression>
                    </structure>
                </list-property>
            </column>
            <column id="79">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("CUSTOMERNAME")</expression>
                    </structure>
                </list-property>
            </column>
            <column id="80">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("CONTACTLASTNAME")</expression>
                    </structure>
                </list-property>
            </column>
            <column id="81">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("CONTACTFIRSTNAME")</expression>
                    </structure>
                </list-property>
            </column>
            <column id="82">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("PHONE")</expression>
                    </structure>
                </list-property>
            </column>
            <column id="83">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("ADDRESSLINE1")</expression>
                    </structure>
                </list-property>
            </column>
            <column id="85">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("CITY")</expression>
                    </structure>
                </list-property>
            </column>
            <column id="86">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("STATE")</expression>
                    </structure>
                </list-property>
            </column>
            <column id="87">
                <list-property name="visibility">
                    <structure>
                        <property name="format">all</property>
                        <expression name="valueExpr" type="javascript">checkField("POSTALCODE")</expression>
                    </structure>
                </list-property>
            </column>
            <header>
                <row id="10">
                    <cell id="11">
                        <label id="12">
                            <text-property name="text">CUSTOMERNUMBER</text-property>
                        </label>
                    </cell>
                    <cell id="13">
                        <label id="14">
                            <text-property name="text">CUSTOMERNAME</text-property>
                        </label>
                    </cell>
                    <cell id="15">
                        <label id="16">
                            <text-property name="text">CONTACTLASTNAME</text-property>
                        </label>
                    </cell>
                    <cell id="17">
                        <label id="18">
                            <text-property name="text">CONTACTFIRSTNAME</text-property>
                        </label>
                    </cell>
                    <cell id="19">
                        <label id="20">
                            <text-property name="text">PHONE</text-property>
                        </label>
                    </cell>
                    <cell id="21">
                        <label id="22">
                            <text-property name="text">ADDRESSLINE1</text-property>
                        </label>
                    </cell>
                    <cell id="25">
                        <label id="26">
                            <text-property name="text">CITY</text-property>
                        </label>
                    </cell>
                    <cell id="27">
                        <label id="28">
                            <text-property name="text">STATE</text-property>
                        </label>
                    </cell>
                    <cell id="29">
                        <label id="30">
                            <text-property name="text">POSTALCODE</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="37">
                    <cell id="38">
                        <data id="39">
                            <property name="resultSetColumn">CUSTOMERNUMBER</property>
                        </data>
                    </cell>
                    <cell id="40">
                        <data id="41">
                            <property name="resultSetColumn">CUSTOMERNAME</property>
                        </data>
                    </cell>
                    <cell id="42">
                        <data id="43">
                            <property name="resultSetColumn">CONTACTLASTNAME</property>
                        </data>
                    </cell>
                    <cell id="44">
                        <data id="45">
                            <property name="resultSetColumn">CONTACTFIRSTNAME</property>
                        </data>
                    </cell>
                    <cell id="46">
                        <data id="47">
                            <property name="resultSetColumn">PHONE</property>
                        </data>
                    </cell>
                    <cell id="48">
                        <data id="49">
                            <property name="resultSetColumn">ADDRESSLINE1</property>
                        </data>
                    </cell>
                    <cell id="52">
                        <data id="53">
                            <property name="resultSetColumn">CITY</property>
                        </data>
                    </cell>
                    <cell id="54">
                        <data id="55">
                            <property name="resultSetColumn">STATE</property>
                        </data>
                    </cell>
                    <cell id="56">
                        <data id="57">
                            <property name="resultSetColumn">POSTALCODE</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="64">
                    <cell id="65"/>
                    <cell id="66"/>
                    <cell id="67"/>
                    <cell id="68"/>
                    <cell id="69"/>
                    <cell id="70"/>
                    <cell id="72"/>
                    <cell id="73"/>
                    <cell id="74"/>
                </row>
            </footer>
        </table>
    </body>
</report>

BIRT: Running a Multi-Select Parameter Report from Java

2012-03-05T08:54:00.003-07:00

Below is an example of how to call a multi-select parameter report from Java using the BIRT Report Engine API.


import org.eclipse.birt.core.exception.BirtException;
import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.engine.api.EngineConfig;
import org.eclipse.birt.report.engine.api.EngineException;
import org.eclipse.birt.report.engine.api.IReportRunnable;
import org.eclipse.birt.report.engine.api.IRunAndRenderTask;
import org.eclipse.birt.report.engine.api.PDFRenderOption;
import org.eclipse.birt.report.engine.api.impl.ReportEngine;

public class MultiParamCall {
public static void main(String[] args) {
 try {
  String designFIle = "C:\\Users\\jwward\\workspace\\Examples\\MultiValue.rptdesign";
 
  //create engine config, start engine and platform
  EngineConfig config = new EngineConfig();
  Platform.startup();
  ReportEngine engine = new ReportEngine(config);
 
  //open the report design and create a new run task
  IReportRunnable reportDesign = engine.openReportDesign(designFIle);
  IRunAndRenderTask runTask = engine.createRunAndRenderTask(reportDesign);
 
  //the multi-select values to use. This just needs to be Object[].
  String[] values = {"V1", "V2", "V3"};
  runTask.setParameterValue("ListParam", values);
 
  //set the render outputs
  PDFRenderOption renderOption = new PDFRenderOption();
  renderOption.setOutputFileName("C:/TEMP/output.pdf");
  renderOption.setOutputFormat("PDF");
  runTask.setRenderOption(renderOption);
 
  //run report, close the task, and destroy the engine.
  runTask.run();
  runTask.close();
  engine.destroy();
 } catch (EngineException e) {
  e.printStackTrace();
 } catch (BirtException e) {
  e.printStackTrace();
 }
}
}

The XML for the report design is below.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905 Build &lt;3.7.1.v20110905-1820></property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="ListParam" id="7">
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <list-property name="selectionList">
                <structure>
                    <property name="value">V1</property>
                </structure>
                <structure>
                    <property name="value">V2</property>
                </structure>
                <structure>
                    <property name="value">V3</property>
                </structure>
            </list-property>
            <property name="paramType">multi-value</property>
            <property name="controlType">list-box</property>
            <property name="mustMatch">true</property>
            <property name="fixedOrder">true</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" 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>
        <style name="crosstab" id="6">
            <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>
        <data id="8">
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">ListParam</property>
                    <expression name="expression" type="javascript">params["ListParam"].toString()</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <property name="resultSetColumn">ListParam</property>
        </data>
    </body>
</report>

BIRT: Showing Top 10 and Still Displaying Total Count

2012-02-24T10:58:00.002-07:00

A question on the BIRT Exchange asked how could you display the top 10, but still show the total count for the entire table.

This is fairly easy, and uses a combination of Aggregations, the Visibility Expression, Sorts, and the row._rownum property of a table.

So, lets say I have a query like:

select 
    CLASSICMODELS.CUSTOMERS.CUSTOMERNAME,
    CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
    sum(CLASSICMODELS.ORDERDETAILS.PRICEEACH * CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED) totalOrders
from 
    CLASSICMODELS.CUSTOMERS,
    CLASSICMODELS.ORDERS,
    CLASSICMODELS.ORDERDETAILS
where
    CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
    and CLASSICMODELS.ORDERS.CUSTOMERNUMBER = CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
group by
    CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
    CLASSICMODELS.CUSTOMERS.CUSTOMERNAME

My total sales for each customer is handled in the query. What I want is to display the Top 10 Customers. So, I will create a data set, and drag that data set over to the report designer. Once there, I will add a sort in descending order based on the totalOrders column. This will list all customers in descending order based on total sales, leaving the top buying customers at the top.

If I add a Count Aggregation to the table and put it in the footer, it will display the total count of customers. The next step is to filter on the Top 10. The way I would do this is select the Detail row in the table, and set a Visibility expression like so:

row.__rownum > 9

__rownum is based on the order it is in the Tables binding, and gets set on fetch. So why use a Visibility Expression instead of a Filter? Because Filter does not have access to the __rownum property, and it would affect the Tables aggregation, so there would be an inaccurate count of customers.

The resulting Top 10 can now be used in a Dashboard by being called as a Reportlet, and the Total Count aggregation can be set as the drill down link for the full list.

The example reports XML is below.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905 Build &lt;3.7.1.v20110905-1820></property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
            <property name="odaURL">jdbc:classicmodels:sampledb</property>
            <property name="odaUser">ClassicModels</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="totalDataSet" id="8">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">CUSTOMERNAME</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">CUSTOMERNAME</text-property>
                    <text-property name="heading">CUSTOMERNAME</text-property>
                </structure>
                <structure>
                    <property name="columnName">CUSTOMERNUMBER</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">CUSTOMERNUMBER</text-property>
                    <text-property name="heading">CUSTOMERNUMBER</text-property>
                </structure>
                <structure>
                    <property name="columnName">TOTALORDERS</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">TOTALORDERS</text-property>
                    <text-property name="heading">TOTALORDERS</text-property>
                </structure>
            </list-property>
            <list-property name="parameters"/>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">CUSTOMERNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">CUSTOMERNUMBER</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">TOTALORDERS</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">CUSTOMERNAME</property>
                    <property name="nativeName">CUSTOMERNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">CUSTOMERNUMBER</property>
                    <property name="nativeName">CUSTOMERNUMBER</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">TOTALORDERS</property>
                    <property name="nativeName">TOTALORDERS</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select 
    CLASSICMODELS.CUSTOMERS.CUSTOMERNAME,
    CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
    sum(CLASSICMODELS.ORDERDETAILS.PRICEEACH * CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED) totalOrders
from 
    CLASSICMODELS.CUSTOMERS,
    CLASSICMODELS.ORDERS,
    CLASSICMODELS.ORDERDETAILS
where
    CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
    and CLASSICMODELS.ORDERS.CUSTOMERNUMBER = CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
group by
    CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
    CLASSICMODELS.CUSTOMERS.CUSTOMERNAME
    ]]></xml-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>2.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CUSTOMERNAME</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CUSTOMERNAME</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CUSTOMERNAME</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CUSTOMERNUMBER</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CUSTOMERNUMBER</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CUSTOMERNUMBER</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>ORDERNUMBER</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>ORDERNUMBER</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>ORDERNUMBER</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>PRICEEACH</design:name>
              <design:position>4</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>15</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>PRICEEACH</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>PRICEEACH</design:label>
            <design:formattingHints>
              <design:displaySize>22</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>QUANTITYORDERED</design:name>
              <design:position>5</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>QUANTITYORDERED</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>QUANTITYORDERED</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" 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>
        <style name="crosstab" id="6">
            <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="77">
            <property name="dataSet">totalDataSet</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">CUSTOMERNAME</property>
                    <text-property name="displayName">CUSTOMERNAME</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CUSTOMERNAME"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CUSTOMERNUMBER</property>
                    <text-property name="displayName">CUSTOMERNUMBER</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">TOTALORDERS</property>
                    <text-property name="displayName">TOTALORDERS</text-property>
                    <expression name="expression" type="javascript">dataSetRow["TOTALORDERS"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">TotalCustomerCount</property>
                    <property name="dataType">integer</property>
                    <property name="aggregateFunction">COUNT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <list-property name="sort">
                <structure>
                    <expression name="key" type="javascript">row["TOTALORDERS"]</expression>
                    <property name="direction">desc</property>
                    <property name="strength">-1</property>
                </structure>
            </list-property>
            <column id="103"/>
            <column id="96"/>
            <column id="97"/>
            <column id="98"/>
            <header>
                <row id="78">
                    <property name="backgroundColor">#808080</property>
                    <property name="fontWeight">bold</property>
                    <property name="textAlign">left</property>
                    <cell id="100">
                        <label id="105">
                            <text-property name="text">LINE NUMBER</text-property>
                        </label>
                    </cell>
                    <cell id="79">
                        <label id="82">
                            <text-property name="text">CUSTOMER NUMBER</text-property>
                        </label>
                    </cell>
                    <cell id="81">
                        <label id="99">
                            <text-property name="text">CUSTOMER NAME</text-property>
                        </label>
                    </cell>
                    <cell id="83">
                        <label id="84">
                            <text-property name="text">TOTAL ORDERS</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="85">
                    <list-property name="highlightRules">
                        <structure>
                            <property name="operator">eq</property>
                            <property name="backgroundColor">#C0C0C0</property>
                            <property name="fontSize">10pt</property>
                            <expression name="testExpr" type="javascript">row.__rownum % 2</expression>
                            <simple-property-list name="value1">
                                <value type="javascript">1</value>
                            </simple-property-list>
                        </structure>
                    </list-property>
                    <list-property name="visibility">
                        <structure>
                            <property name="format">all</property>
                            <expression name="valueExpr" type="javascript">row.__rownum > 9</expression>
                        </structure>
                    </list-property>
                    <cell id="101">
                        <text-data id="104">
                            <expression name="valueExpr">row.__rownum + 1</expression>
                            <property name="contentType">html</property>
                        </text-data>
                    </cell>
                    <cell id="86">
                        <data id="89">
                            <property name="resultSetColumn">CUSTOMERNUMBER</property>
                        </data>
                    </cell>
                    <cell id="88">
                        <data id="87">
                            <property name="resultSetColumn">CUSTOMERNAME</property>
                        </data>
                    </cell>
                    <cell id="90">
                        <data id="91">
                            <structure name="numberFormat">
                                <property name="category">Currency</property>
                                <property name="pattern">$#,##0.00{RoundingMode=HALF_UP}</property>
                            </structure>
                            <property name="resultSetColumn">TOTALORDERS</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="92">
                    <cell id="102">
                        <property name="backgroundColor">yellow</property>
                        <property name="fontWeight">bold</property>
                        <label id="106">
                            <text-property name="text">Total Customers:</text-property>
                        </label>
                    </cell>
                    <cell id="93">
                        <data id="107">
                            <property name="resultSetColumn">TotalCustomerCount</property>
                        </data>
                    </cell>
                    <cell id="94"/>
                    <cell id="95"/>
                </row>
            </footer>
        </table>
    </body>
</report>

BIRT: Dynamic Hide Table and Not Execute Dataset

2012-02-23T13:23:00.001-07:00

An interesting question came up on the BIRT Exchange. Given a particular parameter or some business logic, how could you “hide” a table. And by hide, we mean remove a table so that it does not execute the Data Set it is bound to. This is actually pretty simple. The below report demonstrates removing a table dynamically based on a parameter set to true or false. The catch is that you need to give the table a name in the Property Editor.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905 Build &lt;3.7.1.v20110905-1820></property>
    <property name="units">in</property>
    <method name="beforeFactory"><![CDATA[if (params["prmHideTable"].value)
{
    reportContext.getDesignHandle().findElement("TableToHide").drop();
}]]></method>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="prmHideTable" id="7">
            <text-property name="promptText">Should we hide the table?</text-property>
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">False</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="srcClassicModels" id="9">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
            <property name="odaURL">jdbc:classicmodels:sampledb</property>
            <property name="odaUser">ClassicModels</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="setCustomers" id="10">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">CUSTOMERNUMBER</property>
                    <text-property name="displayName">CUSTOMERNUMBER</text-property>
                    <text-property name="heading">CUSTOMERNUMBER</text-property>
                </structure>
                <structure>
                    <property name="columnName">CUSTOMERNAME</property>
                    <text-property name="displayName">CUSTOMERNAME</text-property>
                    <text-property name="heading">CUSTOMERNAME</text-property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">CUSTOMERNUMBER</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">CUSTOMERNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">srcClassicModels</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">CUSTOMERNUMBER</property>
                    <property name="nativeName">CUSTOMERNUMBER</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">CUSTOMERNAME</property>
                    <property name="nativeName">CUSTOMERNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select 
    CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
    CLASSICMODELS.CUSTOMERS.CUSTOMERNAME
from 
    CLASSICMODELS.CUSTOMERS]]></xml-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>2.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CUSTOMERNUMBER</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
            <design:precision>10</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CUSTOMERNUMBER</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CUSTOMERNUMBER</design:label>
            <design:formattingHints>
              <design:displaySize>11</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>CUSTOMERNAME</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CUSTOMERNAME</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CUSTOMERNAME</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" 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>
        <style name="crosstab" id="6">
            <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>
        <label id="8">
            <text-property name="text">I am a report. I have a table that will display if my hide parameter is set to false.</text-property>
        </label>
        <table name="TableToHide" id="11">
            <property name="dataSet">setCustomers</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">CUSTOMERNUMBER</property>
                    <text-property name="displayName">CUSTOMERNUMBER</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">CUSTOMERNAME</property>
                    <text-property name="displayName">CUSTOMERNAME</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CUSTOMERNAME"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="25"/>
            <column id="26"/>
            <header>
                <row id="12">
                    <property name="backgroundColor">silver</property>
                    <property name="fontWeight">bold</property>
                    <property name="textAlign">left</property>
                    <cell id="13">
                        <label id="14">
                            <text-property name="text">CUSTOMERNUMBER</text-property>
                        </label>
                    </cell>
                    <cell id="15">
                        <label id="16">
                            <text-property name="text">CUSTOMERNAME</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="17">
                    <list-property name="highlightRules">
                        <structure>
                            <property name="operator">eq</property>
                            <property name="backgroundColor">#E1E1E1</property>
                            <expression name="testExpr" type="javascript">row.__rownum % 2</expression>
                            <simple-property-list name="value1">
                                <value type="javascript">0</value>
                            </simple-property-list>
                        </structure>
                    </list-property>
                    <cell id="18">
                        <data id="19">
                            <property name="resultSetColumn">CUSTOMERNUMBER</property>
                        </data>
                    </cell>
                    <cell id="20">
                        <data id="21">
                            <property name="resultSetColumn">CUSTOMERNAME</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="22">
                    <cell id="23"/>
                    <cell id="24"/>
                </row>
            </footer>
        </table>
    </body>
</report>

Things in the works.

2012-01-16T01:57:00.002-07:00

Lots of changes recently. I am unemployed now. Could not have come at a worst time, but at the same time I have made good use of my free time. Read lots of books, specifically about Specification by Example to address some of the short comings I have encountered with Agile methodologies, and I have taken the time to learn a few new languages. Groovy, Ruby, and a few others. Learned a lot about Magento as an eCommerce platform, and surprisingly it is very comparable to some of the big boys, even in its community edition. I have also refreshed my memory on Solr/Lucene.

I will have some new articles coming up. I let too much B.S. keep me from maintaining this site previously, which is a shame because I really enjoyed it. Onward and upward.

BIRT: Using Resource Bundles

2011-09-21T21:10:00.006-06:00

A question that has recently been posted on the BIRT Exchange has got me revisiting an old problem with BIRT, localization. BIRT has a localization mechanism built in, but this only works for labels with the UI. You can also use Javascript and the report context to access messages. But I wanted to look at another way to accomplish this same task? It would stand to reason that since BIRT is running inside OSGi, and OSGi is just a fancy layer on top of Java, that we should have access to the localization features in Java, right? That would be correct.

I prefer to use Java Event Handlers for this. It is possible using Javascript event handlers, but that is a bit of a pain. So, in the following example, I will show a simple Java Report Event Adapter that will load up a Resource Bundle based on the Locale passed in from BIRT, and initialize a HashMap that can be used in BIRT to retrieve those values.

The first thing I do is create a separate Java project, and extend the ReportEventAdapter class. I then created a initialize event, although this would work in the beforeFactory event as well. All you need to do is use the same coding you would use in Java to load the ResourceBundle, and retrieve your keys and values. Using the reportContext passed in, you can load the Locale, and set a global variable that can be used in the report design to retrieve those values. The Java code is below.

package com.digiassn.blogspot.birt.event.handlers;

import java.util.HashMap;
import java.util.ResourceBundle;

import org.eclipse.birt.report.engine.api.script.IReportContext;
import org.eclipse.birt.report.engine.api.script.ScriptException;
import org.eclipse.birt.report.engine.api.script.eventadapter.ReportEventAdapter;

public class ResourceReportEventAdapter extends ReportEventAdapter {
    private static String LABEL_KEY = "myLabel";
    private static String RESOURCE_NAME = "myResource";
    
    @Override
    public void initialize(IReportContext reportContext) throws ScriptException {
        super.initialize(reportContext);
        
        ResourceBundle resourceBundle = ResourceBundle.getBundle(RESOURCE_NAME, reportContext.getLocale());

        String stringValue = resourceBundle.getString(LABEL_KEY);
        
        HashMap<String, String> resourceValues = new HashMap<String, String>();
        resourceValues.put(LABEL_KEY, stringValue);
        
        reportContext.setGlobalVariable("resources", resourceValues);
    }

}

The next piece of the puzzle is where to put the .properties files. You should put them into the projects /src folder. If you put them under a package, you would reflect that in the getBundle call above. I just kept mine at the root.

So now, how do you leverage this in a report? Create a new report project. Right-mouse click in the Navigator, and go to Properties. Select Report Design/Classpath. Click on the Add Projects button, and select the Java project with your Event Adapter.

In my example report, I dropped a Dynamic Text Element in, and used the following expression:

var resourceMap = reportContext.getGlobalVariable("resources");

resourceMap.get("myLabel");

And that’s it. Its read for preview. I can now localize this however I choose. If I wanted to, in my data set, I could have an additional column with the key to retrieve, and just retrieve it from my map. This allows for external localization.

Be sure to check the BIRT Internationalization FAQ at http://wiki.eclipse.org/BIRT/FAQ/Internationalization. You can use a standard reportContext.getMessage call in a similar manner.

BIRT 3.7 Released

2011-06-22T14:27:00.003-06:00

Imagine my surprise, BIRT 3.7 was released today. I didn't even know until a client pointed it out to me =)

You can get it over at the Eclipse BIRT Homepage at http://www.eclipse.org/birt, along with a list of what is new and notable in this release.

Tech: Nintendo 3DS

2011-03-28T16:34:00.003-06:00

I am once again crossing that threshold between professional writings and personal for this article. It has been over a day since I purchased the Nintendo 3DS, the newest hand held gaming device by big N. Let me cut to the chase. Is it worth it? In the short term, no. But this has nothing to do with the hardware, or the novelty of the 3D, which is, in a word, phenomenal. No, the shortcoming is with the game library that came out at launch. Don't get me wrong, Super Street Fighter 4 was the tipping point for me, but as of this writing, that all there really is. I'm thinking of getting Ridge Racer, and Pilotwings, but truth be told, I'm only considering that as a justification to use more of the 3D features. In the long run, this is more evolutionary than revolutionary, and when Zelda comes out, along with several other titles, this will be the device to be had, even if it will be in its inevitable 3Ds Lite form.

Now for the long description. I purchased the 3DS since I am a pretty heavy mobile gamer due to my traveling schedule. I usually carry on me my DS Lite, and my original PSP fat (hacked of course) so that I can keep myself entertained on planes, airports, and hotels. So the 3DS was an enticing option.

The 3DS is, in a nutshell, an updated version in the DS and DSi line. All titles for those platforms are playable, with the addition of the new 3DS titles. Covering 3 generations of the platform is pretty impressive, considering that the DS only covered the DS and Gameboy Advance, and the DSi dropped the Advance and only played DS and DSi titles. The problem for me, however, is that I do still have a good collection of Advance titles, such as the re-releases of Zelda 1 and 2, Phantasy Star, and several Final Fantasy installments. So, for me, it looks like I'll still be carrying around the DS Lite. Which brings up a major issue with the 3DS, the battery. The battery, for me, lasted around 3 - 4 hours. Of course, I did crank the 3D the entire time, but from what I have read, turning the 3D off doesn't make that big of a difference. So on a plane ride for me its no big deal, but I might be switching over to the Lite mid flight.

Once the 3Ds is turned on, it borrows a lot of its "feel" from the Wii. Thats hard to describe in words, but the overall tone, color schemes, and sound effects seemed very Wii'ish. Thats not a bad thing by any means, and navigating the menus is a very intuitive. The 3D camera is really slick, as is the AR games.

But the real meat is in the gaming. I spent all my time playing Street Fighter, of course. And to be honest, I was blown away by the 3D. It really is unlike any gaming experience I have ever had. Just something about landing that final special move, and the camera panning around with real perceived depth is just breath taking. I was a little disappointed that the two hood rats were missing from the background of the North American Diner stage, but I suppose there is only so much processing power in this handheld, and processing the "Oh Snaps" might have been too much.

There are several features that have a notice that it will be featured in some future update, such as the web browser, which means there are pieces of the entire 3DS experience that are missing. But I guess thats what I get for being an early adopter.

Like I said above, this is a really neat device. But the short term benefit just seems lacking. Long term this can really be THE device to have, especially once the game library grows, especially considering that DS and DSi titles cannot take advantage of the 3D capabilities. But once the Zelda, Mario, and Laytons come out that do take advantage of these features, this is going to be a great system. And something about the Professor Laytons stylized art might be really slick with the 3D option turned on =)

BIRT: Connecting to MS Sql Server Database

2011-03-09T23:53:00.003-07:00

Download the Microsoft JDBC driver from http://msdn.microsoft.com/en-us/sqlserver/aa937724
Note: If youre using Java 1.5, you will use sqljdbc.jar, if your using Java 1.6, you will use sqljdbc4.jar.
Open Eclipse
Create a new Report or open an existing report
Open the Data Explorer Tab
If this is an existing report, Double Click on an existing Data Source, otherwise create a new Data Source. Call it whatever.
From the Data Source editor, click on the Manage Drivers button.

In the Manage JDBC Drivers Dialog, click on Add…

Navigate to where you have either the sqljdbc.jar or sqljdbc4.jar file, and click Open. This will add the driver to the BIRT Designer.
Now, click on the Drivers Tab.
Double click on the SqlServerDriver entry to edit it. Put in a name, and a URL template that will prompt you on the correct URL pattern to use.

Click on OK, and OK, until you get to the Data Source Editor Dialog.
Select the SQL Server driver from the drop down list. It will automatically put in the template. Replace the IP Address, and Database name with the ip of your Sql Server Database, and the name of the database.

Enter the correct User Name and Password.

That’s it, your done. Test Connection to make sure the information is correct, and hit OK.

Tech: Asus Motherboard Box Doubles as PC Case

2011-03-02T15:24:00.001-07:00

In the "Why didn't they think of this before" category, Asus is beginning a trial where they ship some of their motherboards in a box that, when opened post shipping, just needs you to add components and doubles as the PC case itself. While not exactly the most visually appealing design, it REALLY is something that is worth looking into, especially if your building your own PC and aren't too concerned with the visuals of an all black case and adding "das blinking lights".

http://www.itworld.com/hardware/138740/asus-motherboard-box-doubles-a-pc-case

BIRT: The Arctorus BIRT Emitters

2011-02-28T22:16:00.002-07:00

While doing some research for some work on an emitter for a client, I came across the Arctorus BIRT Emitters. I'd never heard of these guys, just the standard OSS BIRT Emitters, the Commercial BIRT Emitters, and the Tribix Emitters. While these are commercial emitters, and are not free, they do offer a 30 day trial. These are the formats that are supported.

DOCX
XLSX
PPTX
ODT
ODS
ODP

I intend to do a review of them and see how well they work.

BIRT: Chart DaVinci

2011-01-28T15:31:00.002-07:00

I don't know how I missed this post over at the BIRT Exchange. This is a really great drop in script that you can use in your charts that will instantly spruce them up. Takes a lot of manual picking at charts to get that professional look out of the design process. Definitively well worth a look if your doing any kind of chart work.

BIRT: Dynamically Adding a Data Set to a Report

2011-01-27T20:56:00.004-07:00

So a co-worker asked me today to help him by dynamically adding a data set to a report. He ended up going a slightly different route using the StructureElementFactory class, but this is what I came up with using the reports existing ElementFactory, and dynamically adding in the parameters and query text. This example can be expanded upon of course to set this up in whatever way you need, in coordination with using the DEAPI to dynamically add a table for a more dynamic report. It will even save off the report design at the end for future reference. I used the beforeFactory event, but this will work just as well in the Initialize event as well.

public class ReportEventHandler extends ReportEventAdapter {

    @Override
    public void beforeFactory(IReportDesign report, IReportContext reportContext) {
        super.beforeFactory(report, reportContext);
            
        try {
            ReportDesignHandle reportDesign = reportContext.getDesignHandle();
            OdaDataSetHandle dataSet = reportDesign.getElementFactory().newOdaDataSet("Data Set", "org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet");
            
            dataSet.setDataSource("Data Source");
            dataSet.setQueryText("select employeenumber from employees where employeenumber = ?");
            
            OdaDataSetParameter param = new OdaDataSetParameter();
            
            param.setName("param_1");
            param.setParamName("empNo");
            param.setNativeName("");
            param.setDataType("integer");
            param.setNativeDataType(4);
            param.setPosition(1);
            param.setIsInput(true);
            param.setIsOutput(false);
            
            dataSet.getPropertyHandle(DataSetHandle.PARAMETERS_PROP).addItem(param);
            
            OdaResultSetColumn result = new OdaResultSetColumn();
            result.setColumnName("EMPLOYEENUMBER");
            result.setNativeName("EMPLOYEENUMBER");
            result.setDataType("integer");
            result.setPosition(1);
            result.setNativeDataType(4);
            dataSet.getPropertyHandle(DataSetHandle.RESULT_SET_PROP).addItem(result);
            
            ColumnHint resultHint = new ColumnHint();
            resultHint.setProperty(ColumnHint.COLUMN_NAME_MEMBER, "EMPLOYEENUMBER");
            resultHint.setProperty(ColumnHint.COLUMN_NAME_MEMBER, "integer");
            
            dataSet.getPropertyHandle(DataSet.COLUMN_HINTS_PROP).addItem(resultHint);
            
            //this works
            reportDesign.getDataSets().add(dataSet);
            
            //and so does this
            //reportDesign.getSlot(ReportDesignHandle.DATA_SET_SLOT).add(dataSet);
            
            //just saving for debug purposes, you can ignore this
            reportDesign.saveAs("C:/TEMP/MyTestDesign.rptdesign");
        } catch (ContentException e) {
            e.printStackTrace();
        } catch (NameException e) {
            e.printStackTrace();
        } catch (SemanticException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

BIRT: Connecting Data Elements to Existing Table Bindings

2011-01-25T22:08:00.003-07:00

Not sure how I never knew this existed before, but I discovered a really cool little feature in BIRT. Lets say you have an existing table binding in a report. For me, I ran across this when I went into the XML source and copied a binding multiple times to duplicate it and make minor changes. Or, lets say you just added an Aggregation via the Property Editors binding tab instead of dragging and dropping. Now you want to add in a data element to display it. If you try to drop in a new Data Element, it will create a new binding, even if you are just referencing an existing table binding. Thats no good, you dont want duplicates, you just want to reference an existing binding. There is always the option of using a Dynamic Text element, but what if you want to change the underlying expression in the future, and you find the Property Editor tedious. Well, there is a quick way.

Add a Data element in the report designer. Do not change the name or add an expression, just his Escape. It will create a blank placeholder. Then, right-mouse click on this blank data element, and choose Change Data Column. The Select Data Binding dialog will pop up, and you can select which Data Binding to use. Once you hit OK, it will act just like an original Data Report Item. Again, not sure how I never came across that before...

BIRT: BIRT Helper Functions

2011-01-24T23:43:00.001-07:00

The BIRT Functions provide a wealth of useful functionality that typically gets overlooked by developers. Simple operations such as compares, divides, string functions are handled by these functions with special handling for those really annoying gotchas that are typical.

Consider the following example. Lets say you have a real simple divide expression, such as:

numA / numB

That’s simple enough, right? But that’s assuming that numb is never 0, otherwise you have to worry about the dreaded divide by 0 error. Or better yet, what if one of the values is null because it is not present in the dataset? Normally you would need to change the expression to look like:

if ((numA != null) && (numB > 0))

{

numA / numB

}

else

{

null;

}

But that gets tedious, especially if you have a lot of divide expressions. That’s where the BIRT Functions come into play. In the above scenario, the BirtMath.safeDivide() method can help alleviate the need to do that. So, in the above example, I would basically just use the following:

BirtMath.safeDivide(numA, numB, 0);

BIRT is full of helpful functions such as this, such as Round, RoundUp, RoundDown, different comparison functions, and Date Time functions to work with anything from Years, Quarters, down to seconds. Plus, this functionality is expandable via the BIRT Script Library extension point. I typically recommend that most report writers use these functions in favor of the native Javascript functions.