Web Search
Using BIRT Studio - iHub Edition
One
Getting started
About BIRT Studio
Starting BIRT Studio
Creating a report
Selecting a template
How to select a template for your report
Selecting a data source
About data sources
Using a data source
How to select a template that includes one or more data sets
How to select an information object
How to select a data object
Selecting and inserting data in a report
How to select and insert data fields in a report design using Table Builder
How to limit the data displayed in a report
How to manually select and insert data fields in a report table
How to use a new data source after previewing data in a report design
Editing and formatting a report
Saving a report
Running and viewing a report
Editing and formatting report content
Editing and formatting options
Removing items from a report
Editing labels
Applying a theme
Selecting an item for formatting
Changing font properties
Changing the alignment of text
Applying a number format
How to apply a number format
Selecting a standard number format
Defining a custom number format
Applying a date‑and‑time format
Selecting a standard date‑and‑time format
Defining a custom date‑and‑time format
Applying a string format
Selecting a standard string format
Defining a custom string format
Working with predefined data formats
Formatting data based on conditions
How to set conditional formats
Specifying a condition
Comparing to a literal value
Comparing to a value in another column
Specifying multiple conditional formatting rules
Reverting to default formats
Managing columns
Merging data into one column
Creating a merged column
Working with data in a merged column
Adding a new column header row
How to add a new row
How to merge column headers to type text that spans multiple columns
Changing the page layout to fit data
Adjusting column widths
Changing the layout type, page size, and orientation
How to set the layout type, page size, and orientation
Inserting calculated data
About calculated data
Creating a computed column
About expressions
How to create a computed column
Creating aggregate data in a computed column
Adding data fields for an expression
How to add a data field
Writing expressions
Using numbers and dates in an expression
About reserved characters in an expression
Organizing data in a report
Sorting data
Sorting on a single column
Sorting on multiple columns
Restoring data to its original order
Organizing data in groups
How to group data
Grouping data on a date‑and‑time column
How to group date‑and‑time data
Grouping on multiple columns
Changing the grouping order
Deleting a group
Organizing data in sections
How to create a section
Displaying additional information in a section heading
How to add content to a section heading
Deleting a section
Aggregating data
How to aggregate data
Formatting aggregate values
Filtering aggregate values
Hiding details
Suppressing duplicate values
Avoiding repeated values in a column
Avoiding repeated values in a group
Starting each group or section on a new page
Filtering data
About data filtering
About filtering options
Creating a filter
Defining a filter at the report table level
How to create a filter at the table level
Selecting multiple values for a filter condition
Excluding data
Filtering empty or blank values
Displaying top or bottom values
Specifying a date as a comparison value
Comparing to a string pattern
Comparing to a value in another column
Defining multiple filter conditions
Adding a condition
How to define multiple filter conditions
Changing a condition
Defining a filter at the data set level
How to create a data set filter using Table Builder
How to modify a data set filter
Prompting for filter values at run time
About report parameters
Choosing a parameter type
Making a filter parameter optional
How to make a prompt value optional
Accepting multiple values
Specifying a display type
Providing the user with a list of values
Creating a static filter parameter
How to create a static filter parameter at the report table level
How to create a static filter parameter with a list of values
How to create a static filter parameter at the data set level
Creating a dynamic filter parameter
How to create a dynamic filter parameter at the report table level
How to create a dynamic filter parameter at the data set level
Creating multiple filter parameters
How to create multiple filter parameters
Working with summary tables
About summary tables
About columns in a summary table
Designing a summary table
Creating a summary table
How to create a summary table
Modifying a summary table
Modifying the report table
Modifying labels
Working with a dimension column
Modifying a dimension column
Working with an attribute column
Working with a measure column
Formatting aggregate values
Filtering aggregate data
Inserting a chart in a summary table
Changing table types
Presenting data in a cross tab
About cross tabs
Obtaining data for a cross tab
Working with cubes
Enabling users to drill through data categories
Creating a cross tab
Selecting data for a cross tab
How to select data for a cross tab
Laying out data in a cross tab
How to lay out data in a cross tab
Displaying aggregate values
How to display aggregate values in a cross tab
Saving and viewing a cross tab
Formatting data in a cross tab
Analyzing data in a cross tab
Presenting data in a chart
About charts
About chart technologies
Software requirements
Supported output formats
Choosing a chart technology
Creating a chart
Inserting a chart
How to insert a chart
Choosing a chart type
About area charts
Stacked area chart
Overlay area chart
Percent stacked area chart
About bar charts
Side‑by‑side bar chart
Stacked bar chart
Percent stacked bar chart
Horizontal bar chart
About line charts
Overlay line chart
Stacked line chart
Percent stacked line chart
About meter charts
Superimposed meter chart
Standard meter chart
About pie charts
About scatter charts
About stock charts
Candlestick stock chart
Bar stick stock chart
Selecting data for a chart
Selecting data for an area, bar, or line chart
Selecting data for a pie chart
Selecting data for a meter chart
Selecting data for a scatter chart
Selecting data for a stock chart
Displaying additional series information
Formatting a chart
Changing the size of a chart
Setting a chart’s width
Setting a chart’s height
Editing and formatting titles and labels
Making a chart look three dimensional
Changing the position of the legend
Formatting labels to fit on the x‑axis
Rotating x‑axis labels
Staggering x‑axis labels
Displaying x‑axis labels by interval
Changing the range of values on the y‑axis
Working with Flash charts
Creating a Flash chart
Selecting data for a Flash chart
How to select data for a column, line, or bar Flash chart
How to select data for a pie Flash chart
Formatting a Flash chart
Formatting a column, line, or bar chart
Formatting a pie or doughnut chart
Working with HTML5 charts
Creating an HTML5 chart
Selecting data for an HTML5 chart
Formatting an HTML5 chart
Deleting a chart
Displaying a chart without the table data
Adding interactive viewing features
About interactive viewing options
About bookmarks
About hyperlinks
Using bookmarks
Creating a bookmark
Modifying a bookmark
Deleting a bookmark
Using hyperlinks
Creating a hyperlink
Linking two sections in a report
Linking to a section in a different report
How to create a drill‑through hyperlink
Linking to a URL
Modifying a hyperlink
Deleting a hyperlink
Working with default hyperlinks
How to enable default hyperlinks in a BIRT report using Table Builder
How to disable default hyperlinks in a BIRT report design using Hyperlink Builder
Functions and operators
Functions
Functions used in computed column expressions
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( )
Functions used in aggregate calculations
Operators
Operators in computed column expressions
Operators in conditional formatting and filter condition expressions
Using data from multiple information objects
Requirements for using multiple information objects
Joining information objects
Getting current data from an information object
Two
Introduction to BIRT Studio customization
About BIRT Studio and Actuate Information Console
Overview of customization tasks
Required Actuate software
Understanding the context root
Creating and publishing report templates
About report templates
Design considerations
Separating or combining visual and data elements
Designing themes
Improving usability
Creating a report template
Providing data with a report template
Using a CSV file as a data source
Excluding a data set
Creating themes for a report template
Publishing a template
Setting the default template category
Publishing resources associated with a template
Providing data
Types of data sources
Using data objects as a data source
Deploying data objects
Deploying cross tab templates
Creating information objects
About design considerations
Organizing data in a suite of information objects
Planning folder names and structure
Specifying the listing order for information object columns
Organizing columns into categories
Creating information objects with the IO Design perspective
Deploying information objects
How to copy information object files to the shared resources folder
How to publish information object files as resources
Simplifying access to information objects
Configuring the starting folder for finding information objects
Hiding folders
Creating a custom data source
Sample ODA data source
Extended sample ODA example
Developing an open data access (ODA) data driver
Developing a custom query builder
Creating the servlet
Compiling the servlet
Deploying the servlet
Registering the servlet
Configuring the extended custom data source
Configuring BIRT Studio
Assigning license options to a user
Enabling or disabling functionality
Configuring toolbar and context menu items
Configurable actions
Configuration examples
Specifying the default position of aggregate values
Using sample data in a preview
Configuring advanced data operations
Configuring the application environment
Actuate BIRT Studio URIs
Accessing BIRT Studio using a URI
Using the BIRT Studio servlet
Using the BIRT Studio URLs