-
Aggregate Function to subtract previous Row value
Be sure to look at John Wards article on Aggregate functions:<br /> <br /> http://www.birt-exchange.org/devshare/designing-birt-reports/1102-working-with-extension-points-aggregations/#description<br /> <br /> This funciton is a simple with very little error checking aggregate that supplies the diffference between two rows…
-
Turning a Chart series off in script
In the BeforeGeneration chart event you can get access to the chart design time series to turn its visibility off. When you use the chart builder to construct a chart with axes with multiple series, a series definition is created for each. So for example if you define a chart with axes that has two series (bar and line)…
-
Crosstab Script Example
This example illustrates script on a xtab that shows how to reference a particular cell by id or by type (ie header) and how to evaluate dimensional values when that cell is being created.
-
Mouse Over Details for a Chart
This example uses the invokeScript action to display a table below the chart with specific details about the datapoint. The example uses a Text element with client side JavaScript and hidden tables.<br /> <br /> See http://birtworld.blogspot.com/2009/12/calling-client-side-javascript-from.html for a detailed writeup of the…
-
Set Chart Axis Label Interval with Script
See the beforeGeneration script for details on how this is done.
-
Using Chart Script to Define a specific series color
When a Chart Runs you can redefine the palette colors based on the number of datapoints or some other script value. An example of that approach is located here:<br /> <br /> http://www.birt-exchange.org/devshare/designing-birt-reports/826-chart-script-to-alter-palette-gradient-pie/#description<br /> <br /> This example…
-
Simple bread crumb example
This example contains three reports. Each report drills to another report, so we have 3 levels deep. A simple scheme for bread crumbs is implemented using session variables. In the beforeFactory event of each report we store the current url in a session variable similar to this:tst =…
-
hide row client side
This example provides a button on each row of a table to hide the row. No button is provide to unhide it but the example could be changed to offer it. It uses a bookmark on each row and two text elements with script tags. The text element above the table uses a script tag to enclose function that just sets the display for…
-
Collapse groups client side
Collapses groups using script tag in text element. Does not work across pages.
-
BIRT 2.5 Integration Webinar
The recording is availble at Eclipse Live:<br /> <br /> http://live.eclipse.org/node/856
-
Crosstab Scripting Java/JavaScript
Scripting example with example Java Event handler as well.<br /> <br /> Example described at http://birtworld.blogspot.com/2010/02/birt-crosstab-scripting.html
-
Setting Marker Line based on Date Parameter
Charts with date time axis use com.ibm.icu.util.Calendar. Date time parameters use java.util.Date. This example shows a report that has a date time parameter which is compared to the values of a date axis and used to add a marker line.function afterDataSetFilled( series, dataSet, icsc ){…
-
BIRT Engine Deployed to Struts 2
Example Ant Project showing how to deploy BIRT engine under Struts 2.<br /> <br /> See this post for details:<br /> <br /> http://birtworld.blogspot.com/2010/02/birt-and-struts-2.html
-
Group Row Count
Aggregation Element example that shows group row count.<br /> <br /> Look a the last column's aggregation element
-
Dynamic Xtab Creation Using Script
This example has a report with a pre-created cube and some imported styles. It has 3 parameters one for the column dimension one for the row dimension and one for the measure. Once the parameters are selected there is a beforeFactory script that creates a cross tab based on the parameters you choose.
-
Chart Builder Example
This project is from the BIRT source code.<br /> <br /> Example Eclipse Java Project to launch the Chart Builder.<br /> <br /> Check the build path and make sure all jars from the chart runtime download are in the classpath:<br /> <br /> birt-charts-2_5_1DeploymentRuntimeChartEngine
-
EclipseCon 2010 BIRT Metal PPT
BIRT to the Bare Metal: Framework and API PPT and examples<br /> If deploying the WebViewer as a plugin see this product configuration file<br /> <br /> http://www.birt-exchange.org/devshare/deploying-birt-reports/1194-eclipse-product-configuration-file-for-webviewer-in-rcp/#description
-
Change the last Runtime Series in a chart using Script
This example uses a crosstab multiview item and converts the last series in the chart to a line series using an afterdataset filled event and a beforeGeneration event.
-
Eclipse Product Configuration File for WebViewer in RCP
The Product configuration file shows which plugins must be packaged with the Hello World RCP application to call the BIRT WebViewer plugin when deployed in an RCP application. See<br /> <br /> http://www.birt-exchange.org/devshare/deploying-birt-reports/1187-eclipsecon-2010-birt-metal-ppt/#description<br /> for an example…
-
Repaginate Birt Examples
Three example. 2 Examples use page variables and page scripts, one just uses persistent global variables and an onrender script on the master page. Select the outline view->script to see how each example works.<br /> <br /> These examples were updated for 2.5.2<br /> <br /> Note that these examples require separate run and…
-
Default value all with multi-select parsmeter
This example uses a scripted dataset and a joint dataset to add a default value of all to a multiselect parameter. The query is then modified based on these values. If you do not use multiselect just use this example:<br /> <br />…
-
Add Sort to Crosstab using DE API in script
Look at the beforeFactory script to see how a sort element is created and added to a crosstab level view.
-
Multi-View Table/Chart select using parameter
See:<br /> <br /> http://birtworld.blogspot.com/2010/04/multi-view-report-items.html<br /> <br /> for details
-
Set the color of one bar based on parameter
Example script looks for the base value and compares to a report parameter to set the color of a bar to YELLOW.function beforeDrawDataPoint( dph, fill, icsc ){var hl = icsc.getExternalContext().getScriptable().getParameterValue("HighlightColumn"); if( dph.getBaseDisplayValue() == hl ){ importPackage(…
-
Add highlight rule using script to specific rows and columns
The report takes 4 parameters start and end row and start and end columns and applies a highlighrule based on these parameters. The highlight rule is in the beforeFactory…
-
Chart Invoke Script Event Variables
See this post:<br /> <br /> http://birtworld.blogspot.com/2010/05/more-on-chart-interactivity.html
-
Toggle Visibility of Series Based on Client Side Script
Look at the chart script, legend interactivity and the text element to see scripts associated with this example. This example allows the user to decide which series are displayed in a chart.
-
Flat File Filter with Hidden Parameter
To run the example extract the csv file and change the datasource to point to that folder. The data set has a filter that is tied to a hidden report parameter. The parameter value is set in the beforeOpen script of the dataset.
-
Adding Filter to table/dataset Dynamically
See the beforeFactory and onPrepare scripts in the example report.
-
Resize Pie Chart based on optional grouping count
This report resizes the chart based on the number of optional groups (individual pie charts). When using optional grouping a new dataset is created automatically, so we can use the the afterdataset event to count the number of groups that get created. After all the data is processed the beforeGeneration event is fired and…
