Web Search
Using Actuate BIRT Designer Professional
Accessing data
Supported data sources
How a report accesses data
Accessing data in a JDBC database
Using database data in a report
Accessing data using the SQL query builder
Connecting to a database
Specifying the data to retrieve
Creating computed columns and complex expressions
Filtering data rows
Grouping data
Filtering groups
Creating data objects
About data objects
Design considerations
Designing data objects for dashboards
Designing data objects for reports created with Actuate BIRT Studio
Designing data objects for reports created with Actuate BIRT Designer
Building a data object
Creating new items for a data object
Exporting items to a data object
Creating a shared dimension for cubes
Configuring data set columns for summary tables
How to set the analysis type of a data set column
Creating hyperlinks to provide drill-down capability
Hiding data sets from users
Providing cached data
Publishing a data object
Enabling incremental updates
How to enable incremental updates
How to apply incremental updates to a .data file stored in the file system
Managing user access
Maintaining a data object
Accessing data in a data object
Using data object data in a report
Connecting to a data object
Specifying the data to retrieve from a data object
Using a cube in a data object
Accessing data in an information object
Using information object data in a report
Connecting to an information object
Specifying the data to retrieve from an information object
Accessing data in a report document
Using report document data
Creating a report document
Specifying bookmark names
Specifying element names
Connecting to a report document
Specifying the data to retrieve from a report document
Accessing data in an e.report
Using ActuateOne for e.Reports Data Connector
About ActuateOne for e.Reports Data Connector functionality
Accessing an e.report using Page Level Security
Accessing an e.report having multiple sections
Connecting to an e.report
How to create an ActuateOne for e.Reports data source
Specifying the data to retrieve from an e.report
How to create an ActuateOne for e.Reports data set
Accessing data in Amazon DynamoDB
Using Amazon DynamoDB data in a report
Connecting to Amazon DynamoDB
Specifying the data to retrieve from Amazon DynamoDB
Filtering data
Filtering by a composite primary key
Filtering by an attribute
Accessing data in Amazon Relational Database Service
Using Amazon RDS data in a report
Connecting to Amazon RDS
Specifying the data to retrieve from Amazon RDS
Accessing data in a Hadoop system
Using Hadoop data in a report
Connecting to a Hadoop system
Specifying the data to retrieve from a Hadoop system
Accessing data in Salesforce.com
Using Salesforce.com data in a report
Connecting to Salesforce.com
Specifying the data to retrieve from Salesforce.com
Accessing data in a POJO
Using POJO data in a report
Connecting to a POJO
Specifying the data to retrieve from a POJO
Combining data from multiple data sources
Ways to combine data
Creating a union data set
How to create a union data set
Creating a joined data set
How to create a joined data set
Joining on more than one key
Specifying a join condition not based on equality
Formatting a report
Formatting features in Actuate BIRT Designer
Removing the default themes
Hiding columns in a table
Using a Quick Response (QR) code to link to content
Designing for optimal viewer performance
Building HTML5 charts
About HTML5 charts
Comparing HTML5, Flash, and BIRT charts
Rendering platform
Creating an HTML5 chart
Formatting an HTML5 chart
Applying a chart theme
Creating a chart theme
Creating a general chart theme
How to create a general chart theme
Creating a JavaScript chart theme
How to create a JavaScript chart theme
Writing event handlers
Writing event handlers that respond to user interactions
Writing event handlers that respond to chart events
About the HTML5 chart events
Setting chart options through scripting
Scripting example 1
Scripting example 2
Scripting example 3
Using Flash objects in a report
About Flash
Software requirements
Ways to add Flash objects in a report
Output formats that support Flash
Using built‑in Flash charts and gadgets
About Flash charts and gadgets
Creating a Flash chart and gadget
Formatting a Flash chart
Formatting a Flash gadget
General properties
Scale properties
Needle properties
Needle base or pivot properties
Number formatting properties
Region properties
Tick properties
Threshold properties
Anchor properties
Plot properties
Value indicator properties
Tooltip properties
Font properties
Padding and margin properties
AddOn properties
Using animation and other visual effects
Creating effects
How to create an effect
How to apply an effect to multiple parts in a chart or gadget
Managing effects
Animation effect
Bevel effect
Blur effect
Font effect
Glow effect
Shadow effect
Creating a Flash chart
Create a new report
Build a data source
Build a data set
Add a Flash chart to the report
Select data for the Flash chart
Animate the x-axis labels
Animate the y-axis labels
Change the animation effect of the columns
Creating a Flash gadget
Add a Flash gadget to the report
Select data for the linear gauge
Divide the data area into regions
Add thresholds
Animate the region labels
Animate the sales value
Add a glow effect to the needle
Limitations
Using the Flash object library
About the Flash object library
About Flash charts
About Flash gadgets
About Flash maps
About Flash power charts
Flash object components
Inserting a Flash object in a report
Providing data to a Flash object
Generating the XML data
Using the dataXML variable to pass XML data
Using the dataURL variable to pass XML data
Using the Flash object library documentation
Creating a Flash map that gets data through the dataXML variable
Create a new report
Build a data source
Build a data set
Find a suitable Flash map
Review the map specifications
Map the data set values to the Flash map entity values
Add the Flash map to the report
Generate an XML data string
Create the dataXML variable and pass the data
Format the Flash map
Creating a Flash chart that gets data through the dataURL variable
Create a new report
Build a data source
Build a data set
Add a Flash chart to the report
Create a plug-in
Define an extension
Create a Java class
Implement methods in the class
Deploy the plug-in
Create the dataURL variable
Debugging a Flash object
Using the Flash object’s debug mode
Resolving errors
Writing expressions using EasyScript
About EasyScript
Choosing between EasyScript and JavaScript
Syntax rules
Using the EasyScript expression builder
Changing the default expression syntax
Functions
ABS( )
ADD_DAY( )
ADD_HOUR( )
ADD_MINUTE( )
ADD_MONTH( )
ADD_QUARTER( )
ADD_SECOND( )
ADD_WEEK( )
ADD_YEAR( )
BETWEEN( )
CEILING( )
DAY( )
DIFF_DAY( )
DIFF_HOUR( )
DIFF_MINUTE( )
DIFF_MONTH( )
DIFF_QUARTER( )
DIFF_SECOND( )
DIFF_WEEK( )
DIFF_YEAR( )
FIND( )
IF( )
IN( )
ISNULL( )
LEFT( )
LEN( )
LIKE( )
LOWER( )
MATCH( )
MOD( )
MONTH( )
NOT( )
NOTNULL( )
NOW( )
QUARTER( )
RIGHT( )
ROUND( )
ROUNDDOWN( )
ROUNDUP( )
SEARCH( )
SQRT( )
TODAY( )
TRIM( )
TRIMLEFT( )
TRIMRIGHT( )
UPPER( )
WEEK( )
WEEKDAY( )
YEAR( )
Operators
Specifying filter conditions at report run time
About report parameters and filters
Enabling the user to specify a filter condition
Creating a dynamic filter report parameter
Creating a dynamic filter
Getting information about queries
Displaying cross tab data by relative time periods
About relative time periods
Aggregating data by a relative time period
How to aggregate data by a relative time period
Examples of relative time period aggregations
Supported time periods
Using the * to Date and Trailing N * time periods
Adding HTML buttons to a report
About HTML buttons
Creating an HTML button
Writing code for an HTML button
Accessing report data
How to add a variable to an HTML button
Using the Actuate JavaScript API
Testing an HTML button
Changing the appearance of an HTML button
Controlling user access to report pages and data
About the security model
About access control lists (ACLs) and security IDs
ACL expression syntax
Controlling user access to report pages
Adding page-level security to a report
Enabling and disabling page-level security
Configuring page numbers
Testing page-level security
Controlling user access to data
Adding security to a data object
Adding security to a data set
Adding security to a cube
Enabling and disabling data security
Testing data security
Accessing iServer environment information
Writing event handlers to retrieve iServer environment information
Writing a JavaScript event handler
Writing a Java event handler
About the serverContext object
JavaScript event handler example
Java event handler example
Debugging event handlers that use the iServer API
iServer API reference
appendToJobStatus( )
getAuthenticationId( )
getServerWorkingDirectory( )
getUserAgentString( )
getUserRoles( )
getVolumeName( )
setHeadline( )
setVersionName( )
Performing impact analysis
About impact analysis
Searching for database items used in BIRT objects
How to search for files that use a specific database, table, or column
Identifying the files impacted by a BIRT object
Viewing the relationships among files in a project
Assessing the impact of changes in an Actuate BIRT iServer volume
How to create a new iServer profile
How to download content from an iServer volume
Deploying BIRT reports to iServer
About deploying BIRT reports
Publishing a report to iServer
How to create a new iServer profile
How to publish a report design to iServer
Publishing a report resource to iServer
How to change the Resource folder on an Encyclopedia volume
How to publish a resource from the Resource folder to iServer
Deploying Java classes used in BIRT reports
How to configure BIRT reports and deploy a JAR file to an Encyclopedia volume
How to deploy a JAR file to an iServer /resources folder
Installing a custom JDBC driver
Installing custom ODA drivers and custom plug-ins
Configuring data source connections in iServer
About data source connection properties
Using a connection profile
Creating a connection profile
How to create a connection profile from Data Source Explorer
Managing a connection profile
Exporting connection profiles
Importing connection profiles
Editing connection profile properties
Deploying a connection profile
Encrypting connection profile properties
Binding connection profile properties
Binding Connection Profile Store URL property
Binding a connection profile name to a report parameter
Using a connection configuration file
Setting up the connection configuration file
Understanding how iServer uses the connection configuration file
Setting the location of a connection configuration file
Encrypting the connection properties
Externalizing the connection profile properties on the iServer
Accessing BIRT report design and BIRT resource path in custom ODA plug‑ins
Accessing resource identifiers in the run-time ODA driver
Accessing resource identifiers in the design ODA driver
Configuring fonts in iServer
About configuring fonts
Understanding font configuration file priorities
Understanding how the BIRT engine locates a font
Understanding the font configuration file structure
<font-aliases> section
<composite-font> section
<font-paths> section
Working with BIRT encryption in iServer
About BIRT encryption
About the BIRT default encryption plug-in
About supported encryption algorithms
About the components of the BIRT default encryption plug-in
About acdefaultsecurity.jar
About encryption.properties
About META-INF/MANIFEST.MF
About plugin.xml
Creating a BIRT report that uses the default encryption
Deploying multiple encryption plug-ins
How to create a new instance of the default encryption plug-in
Deploying encryption plug-ins to iServer
How to deploy a new encryption plug-in instance to iServer
Generating encryption keys
How to generate a symmetric encryption key
How to generate a public key using RSA encryption
Creating a custom encryption plug-in
Using encryption API methods
Using custom emitters in iServer
About custom emitters
Deploying custom emitters to iServer and Information Console
Rendering in custom formats
How to deploy a custom emitter to iServer
How to deploy and use a custom emitter in Actuate BIRT Designer
How to export a BIRT report in iServer Management Console
How to export a BIRT report from Information Console or iServer
How to export a BIRT report from Actuate BIRT Viewer or Actuate BIRT Interactive Viewer
Configuring the default export options for a BIRT report
Using the BIRT data object API
About generating data objects from an application
Generating data object elements for BIRT report designs
Creating data object data sets for BIRT report designs
Creating data object data cubes for BIRT report designs
Creating a data element using the Design Engine API
Set up a project
Create a GenerateDataObject Java class
Create the main( ) method to test the code
Run the code