-
Using a multivalue parameter in an in clause
Example beforeOpen Scriptvar parmcount = params["parmorders"].value.lengthvar whereclause = "";if ( parmcount > 0 ){ whereclause = " where customernumber in ( "}for ( i=0; i < parmcount; i++ ){ if( i == 0 ){ whereclause = whereclause + params["parmorders"].value[i]; } else { whereclause = whereclause + " , " +…
-
Change Group Based on Parameter
The group expression is defined asif(params["Grp"].value == "Order") { row["ORDERNUMBER"];}else{ row["PRODUCTCODE"];}
-
EclipseCon 2009 Integrating BIRT
Attached are the slides for the Integrating BIRT class presented at EclipseCon 2009.<br /> <br /> The RCP Examples include sample targets and launch configurations for deploying the Chart Engine, Report Engine, and Viewer Plugin to an RCP application. The targets may need to be modified depending on required BIRT…
-
Crosstab highlight using script
This example uses the cell ids to locate when a row changes and to apply the highlight.
-
Chart Script to Alter Palette - Gradient Pie
See Chart Script in the example.
-
Cacade Report Parameter List Culling
See<br /> <br /> http://birtworld.blogspot.com/2009/04/birt-cascaded-parameters.html
-
Cascade Parameter List Culling using a Scripted Datasource
The first level in the cascaded uses a scripted datasource to set dataset parameter for the second level dataset.<br /> <br /> See<br /> <br /> http://birtworld.blogspot.com/2009/04/birt-cascaded-parameters.html
-
Scripted Data Set with Hibernate
This article is older but should still work (BIRT 2.3.2.1) . The example and source is available at this entry:<br /> <br /> http://www.birt-exchange.org/devshare/designing-birt-reports/704-how-to-integrate-eclipse-birt-with-hibernate/#description
-
RCP APP with BIRT and Scripted Datasource
This example illustrates setting the parent classloader using the app context extension. It also shows running a report that uses a scripted datasource where the event is defined by a class in the plugin. Be certain to look at the plugin.xml for the extension point and the dependecies in the manifest to see what plugins…
-
Change Chart Series Type with Script
This example uses two parameters to change the chart model. The chart has two y-axes. The second axis is changed to allow the end user to choose the specific series (Line, Bar, Area) displayed on this axis. Additionally the chart can be displayed as a study chart or a non study chart based on a boolean parameter. See…
-
Adjust BAR Location in Bar Chart
This example was done with BIRT 2.5 but should work with 2.3. It only uses one script on the chart.function beforeDrawSeries( series, seriesRenderer, context ){ if( series.getSeriesIdentifier() == "Series 1" ){ var dpharray = seriesRenderer.getSeriesRenderingHints().getDataPoints(); for( j=0;j<dpharray.length;j++){ var…
-
All Option On Dynamic Parameter
This example adds an all option to a dynamic parameter by using a Joint Dataset. The Joint DS combines a reqular SQL ds with a scripted dataset that returns one row labeled all. The join is a full outer join and a computed column is added to combine the columns. This joint dataset set is used by a dynamic parameter. The…
-
ALL Option on Dynamic Parameter pt2
This example offers the all option by just setting the default value to a text string. The query used in the report is modified based on the selected value.
-
Calling the Chart Engine from a servlet
The BIRT Chart Engine is very flexible and can be called in many ways. You can use the Chart Tag libraries to include the chart engine in a web app or you can write your own code. If you use the Chart tag libraries download the WTP Integration to include the chart engine module in a Dynamic web project. You can also see an…
-
Burst PDF Report using Script
It is probably much better to just write are RE API program to do this but the script engine does have access to the report engine. This example contains two reports. The first report entitled BurstPDF.rptdesign has one table that list customer numbers (currently it is filtered to list 3) . This table has an onCreate…
-
Create Data Cube & Xtab DE API example
Compile the attached class with the libs from the report runtime download:<br /> birt-runtime-2_5_0ReportEnginelib<br /> <br /> Also set BIRT home in the code to wherever you runtime download is: eg DesignConfig config = new DesignConfig( ); config.setBIRTHome("C:/birt/birt-runtime-2_5_0/ReportEngine");
-
Using the Chart API to Serialize the Chart Model
This example first creates the chart model and then stores it in a file. It then reads the file, binds the data to it and renders it. The chart engine was used in stand alone mode.
-
Integrating BIRT PPT
This presentation details the integration points available with open source BIRT.
-
Scripting Event Handler Samples
This download contains an eclipse workspace that illustrates scripting event hanlders in Java and JavaScript.
-
BIRT API Examples
This workspace contains examples of using the DE, RE, and CE apis including different deployment models (Servlets and RCP).
-
Use JS vars to create a chart for every row in a table
This example uses one table with 2 detail rows. The first row shows some values. The second detail row plots the points on a chart.<br /> <br /> This example uses two scripts. The first script loads values into a map in the oncreate of the first detail row of the table. The second script is a chart script that reassigns…
-
Mult-Hyperlink Chart Sample
Contains two reports. One with a chart that has multiple hyperlinks. And one report that acts as the detail for a drillthough set on the chart.<br /> <br /> See blog post - http://birtworld.blogspot.com/2009/10/multiple-hyperlinks-on-birt-charts.html
-
Accessing Spring Beans from BIRT Reports
This example illustrates adding the Spring Context to the BIRT context so that Spring Beans can be called from BIRT expressions and scripts. See the readme for information on how to build and deploy the example.
-
Page Script Samples
The pv_paged_group.rptdesign shows how to show page numbers per group.<br /> <br /> The pagebymasterpage.rptdesign show how to show page number by master page.<br /> <br /> These examples were done with BIRT 2.5.1
-
Client Side Script on Crosstabs
BSCCrossTabSample.rptdesign example just animates and shows in red a cell when a value is low.<br /> <br /> MouseOverBSCCrossTabSample.rptdesign implements a mouse over and mouse out event.
-
Remote Spring Beans From BIRT
The example contains two ant projects for deploying a simplistic Spring application with a remote client. The remote client can then be called from the Open Source Viewer or the Actuate Interactive Viewer. The readmes describe both deployments.<br /> <br /> See<br /> <br />…
-
drop group with script
This report uses a check box parameter and a beforeFactory script to drop a group from a table.
-
add column to table dynamically
This report uses a beforeFactory script to add a table column, add a data item and a label item, and appropriate column binding for the new data item, to an existing table.<br /> <br /> Note that it is assumed that the column is already in the dataset.
-
Calling Spring Objects from the Expression Builder
This zip contains a Spring J2EE app and an eclipse plugin to access the Spring app in the expression builder. See the readme for details.<br /> <br /> See<br /> <br /> http://birtworld.blogspot.com/2009/11/accessing-spring-beans-from-birt.html<br /> <br /> for more details
-
Example plugin for Expression Builder
This example shows how to implement the ScriptFunctionServcie extension on provides a MyCategory with a test function that just reverses a string. The example was done with BIRT 2.5.1 The zip includes the source and the exported plugin to test with.<br /> <br /> This example is for this blog entry:<br /> <br />…
