-
Enable Interactivity using JSAPI
The attached code sample uses enableIV() in a callback to submit() function that enables the interactive viewing features, here is the code excerpt:viewer.submit(function(v){v.enableIV();});
-
Changing Resource Folder on BIRT iServer
In the Encyclopedia volume, by default, the Resource folder is set to /Resources. All the libraries and templates used by reports are accessed from this folder. If your resource folder in the Encyclopedia volume is different from the default,before publishing a resource, you need to specify the resource folder in…
-
Custom parameter collection using JSAPI
JSAPI actuate.Parameter class enables a web page to display and gather parameters from users before processing and downloading a report to the client. This works well for the most common needs, however if you like to use your own custom parameter collector from a we page, you can use viewer.setParameters(...) function to…
-
Create Union Data Set
The UNION operator can be used to combine the result-set of two or more SELECT statements. However this approach works only if your data set is derived from a single relational data. BIRT gives you the flexibility to pull in data from multiple sources that may or may not support SQL statements to perform a union. <br />…
-
Accessing values from a different dataset in table
Here is a simple example that uses customer names from a different data set (Customer1) and displays it as a tooltip when you hover the mouse over customer numbers column of a table that is bound to a different dataset (Customer2). This is achieved using simple javascript array that is constructed in a hidden table. To…
-
Display special messages in your group footer based on group row count
The attached report uses report variable to count rows for each group(counter is initialized and incremented in onCreate handler of group header and detail row) and displays a special message if the count is below a threshold.
-
Use parameters to pass data to Flash Objects
<p><br /> The following example uses scripting to build XML (dataXML) inside a BIRT report at run time using report parameter values in a web (HTML) page<br /> <br /> To set up this example in your environment:<br />* Copy FlashObjectReport.rptdesign to "Public" folder of your BIRT iServer<br /> * If BIRT iServer is…
-
Hide chart markers based on parameter
Sets the markers visibility in beforeDrawMarker event handler based on the parameter value.
-
Display parameter section of a BIRT report by default
The attached example report when run in Infomtation Console opens up the parameter section by default just below report view area. This is achieved by adding the following simple script in onContentUpdate event handler:this.getViewer().showParameterPanel();
-
Using DEAPI to modify BIRT Report Design
A reporting application typically generates a report from a report design. Sometimes business logic requires programmatically changing an existing report design before generating the report.<br /> Here is a simple example that replaces a data set element with an image element using the BIRT Design Engine API to modify the…
-
BIRT Cheat Sheet from DZone Refcardz
<p><span><span><a href=\"/config/devshare/visit.php?aid=1331\" target=\"_top\"><img style=\"margin: 10px; float: left;\" title=\"BIRTRefcard\" src=\"/org/uploads/blog/BIRTRecard.PNG\" alt=\"BIRT Refcard\" width=\"188\" height=\"277\" /></a><span>DZone.com BIRT Refcardz is a free cheat sheets for developers to…
-
Avoid sorting a presorted data
<p>Progressive Viewing is a popular feature designed to decrease response times when executing designs ondemand and viewing them in the Web Viewer. In Actuate 11 SP2 this feature has been enhanced to decrease response times even further by allowing content authors to specify that the data for a design is already sorted on…
-
Share your dashboards with other users
<p>Shared dashboards use Actuate file permissions and users can save them to a private or shared folder. Users subscribing to a dashboard receive the latest version the next time refresh their browser or log in to Information Console. The following video shows how you can share a dashboard with specific…
-
Building BIRT based Dashboard
<p>The article discusses four categories of gadgets and how to use them.</p>http://birtworld.blogspot.com/2011/01/building-birt-based-dashboards.html
-
Export BIRT Report to multiple excel worksheets
<p>The Excel content can be displayed in multiple worksheets based on the page break logic in BIRT design. This short video demonstrates how this can be achieved.</p> <p>Ashwini Verma</p>http://download.birt-exchange.com/products/demos/A11/Live Excel/MultipleWorksheets/Multiple Worksheet.html
-
Add dynamic parameter handling in BIRT
<p>In Dynamic Parameters, the business user can also select the condition in addition to choosing the value of the parameter. Hence, the business users can explore and ask many different questions from the same BIRT report through these Dynamic Parameters. This short video demonstrates the feature.</p> <p> </p> <p>Ashwini…
-
Hide/show table columns based on input parameter selection
The following example makes use of the hide property of the report element to show the table column based on the user selection.<br /> <br /> The table consists of three columns: customernumber, customername and country. The user is presented with these three choices in the input parameter screen where he can choose a…
-
Export specific objects from BIRT output to Excel
<p>Here is a short video that captures this new capability.</p>http://download.birt-exchange.com/products/demos/A11/Live Excel/Export Specific Objects/Export Specific Objects.html
-
Preserve images from BIRT output in Excel
<p>This short video shows off this new capability.</p>http://download.birt-exchange.com/products/demos/A11/Live Excel/Preserve Images/Preserve Images.html
-
Convert BIRT crosstabs to Excel pivot tables
<p>These pivot tables can be furthur used to analyse information based on different dimensions. Here is a short video that captures this functionality.</p>http://download.birt-exchange.com/products/demos/A11/Live Excel/Pivot Table/Pivot Table.html
-
Export BIRT output to Excel with Live Formulas
<p>This short video demonstrates this feature.</p>http://download.birt-exchange.com/products/demos/A11/Live Excel/Aggregation and Calculation Functions/Aggregation and Calculation Functions.html
-
Deploying Java classes used in BIRT reports
<p>A BIRT Report Designer can use scripts to implement custom functionality. For example, you can use scripts to create a scripted data source or provide custom processing for a report element. When you deploy such a BIRT report design to iServer (Express) or Java Components (Actuate Viewer, Interactive Viewer or…
-
Sample BIRT report with grouping
The example report shows a list of customers and groups them by country. Key BIRT features that are covered in this report are grouping, page breaks, table of contents, and aggregating data per group or as a total.<br /> The attached example was built using BIRT 2.2.2<br /> <br /> See Live Report<br /> <br /> Ashwini Verma
-
Sample BIRT report that uses functions
BIRT offers a number of out of box functions including functions for comparision, date/time and finance. The attached BIRT report illustrates the use of some of these functions.<br /> The attached example was built using BIRT 2.3<br /> <br /> See Live report<br /> <br /> Ashwini Verma
-
Sample BIRT report with a dynamic parameter
BIRT provides the capability to build queries and define filter conditions prior to running the query. The example here uses a separate dataset (OrderNumber) to present the user with a list of dynamic parameter values to choose from in a combo box. The selected value is used as a filter condition inside a SQL query that…
-
Sample drill down BIRT Reports
The master report list orders and allows the report user to click on a particular order number to drill into a detail report for the selected order. This example illustrates using a simple parameter to cull results in the detail report and the hyperlink property within the master report to pass this parameter to the detail…
-
Sample BIRT report with combination chart
The combination chart presents the outstanding debt for the top 5 customers in Bar Chart format with a Line series representing each customer’s credit limit superimposed. The bars within the chart are then linked to order details for each customer.<br /> <br /> See Live Report<br /> <br /> The attached example was built…
-
Sample BIRT report with cascaded parameter group
A cascaded parameter group allows a group of parameters to be interlinked, where selecting a value for the first parameter affects the choices available in the subsequent parameters. Cascaded parameters can be tied to one or more Data Sets. The Data Sets populate each level of the cascade. Combined with Data Set parameters…
-
Sample BIRT Report that implements BIRT supplied extension point
While BIRT Designer provides a number of functions for most common needs, often times there is a need for custom function to address the business needs. The following example implements a custom Optimistic Sum Aggregation Function as a plug-in. The attachment includes the BIRT design, plug-in project and the compiled…
-
Customizing Interactive Viewer toolbar
Interactive Viewer provides very powerful features to modify the report format and consequently the report design. You could remove any of the function from the IV toolbar by modifying the file [InstallDir]\iPortal\webapps\iportal\iportal\iv\pages\control\IVToolbarFragment.jsp<br />The toolbar fragment defines each…
