Web Search
Working with Actuate BIRT Viewers
One
Introducing Actuate BIRT Viewers
Introduction to the viewing environments
Using Actuate BIRT Viewer
Using Interactive Viewer
Comparing the viewers
Navigating a report
About navigation options
Paging through a report
Opening the table of contents
Displaying parameter values
Displaying margins
Working with hyperlinks
Saving a report
How to save a BIRT report design
How to save a BIRT report document
Printing a report
Editing and formatting a report
About editing and formatting options
Formatting a column
Working with data in a merged column
Changing font properties and alignment
How to change font properties
How to change the alignment of text
How to copy font and alignment properties to other columns
Formatting report data based on conditions
How to set conditional formats
Specifying a format for the data
Specifying a condition
Comparing to a literal value
Comparing to a value in another column
Specifying multiple conditional formatting rules
Deleting a conditional formatting rule
Formatting data strings
About data formats
Applying 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 Boolean format
Applying a string format
Selecting a standard string format
Defining a custom string format
Reverting to default formats
Copying a format to other columns
Editing column and group headers
Exporting report data and content
About exporting options
Exporting report data
How to export data in comma‑separated values file (.csv) format
Exporting content
Exporting content to AFP format
How to export a report or report element to AFP format
Exporting content to Microsoft Excel
How to export a report or report element to Excel
Exporting content to PDF format
How to export a report or report element to PDF format
Exporting content to PostScript format
How to export a report or report element to PostScript format
Exporting content to Microsoft Word
How to export a report or report element to Word format
Exporting content to Microsoft PowerPoint
How to export a report or report element to PowerPoint format
Organizing data in a report
About displaying and organizing report data
Modifying the width of a column
Managing a column
How to hide a column
How to display a hidden column
Sorting data
Sorting on a single column
Sorting on multiple columns
Sorting data in a merged column
Reverting 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
How to change the grouping order
Aggregating data
Adding and removing an aggregate value
How to aggregate data
How to add additional aggregate rows to a column
How to aggregate data in a merged column
How to delete an aggregate value
Types of aggregate calculations
Hiding and displaying report elements
Hiding group details
Suppressing duplicate values
Avoiding repeated values in a column
Avoiding repeated values in a group
How to suppress duplicate values in a grouped column
Specifying page breaks
Performing calculations in a report
About calculated data
About expressions
Creating and editing a computed column
Building an expression
Creating a custom expression
Using numbers and dates in a custom expression
How to add days to an existing date value
How to subtract date values in a calculated column
Using reserved characters in a custom expression
Filtering report data
About data filtering
Providing parameter values
How to enter parameter values at run time
How to modify parameter values in the viewers
How to select an operator and specify one or more parameter values
Creating a filter
How to create a filter
Selecting multiple values for a filter condition
Excluding data
Filtering empty or null values
Displaying top or bottom values
Specifying a date as a comparison value
Comparing to a string pattern
Defining multiple filter conditions
Adding a condition
How to define multiple filter conditions
Selecting a logical operator
Specifying the evaluation order
Changing a condition
Deleting a condition
Filtering data in a merged column
Modifying charts
About charts
Types of charts
About bar charts
Side‑by‑side bar chart
Stacked bar chart
Percent stacked bar chart
About tube, cone, and pyramid charts
About area charts
Stacked area chart
Overlay area chart
Percent stacked area chart
About line charts
Overlay line chart
Stacked line chart
Percent stacked line chart
About pie charts
About meter charts
Standard meter chart
Superimposed meter chart
About stock charts
Candlestick stock chart
Bar stick stock chart
About scatter charts
About bubble charts
About difference charts
Modifying charts in Interactive Viewer
Changing chart subtype
Filtering chart data
Formatting the chart
Formatting the legend, title, and size of a chart
How to change the title of a chart
How to change the size of a chart
How to modify the dimension of a chart
How to interchange the axes of a chart
How to format the legend of a chart
Formatting the x‑ and y‑axes of a chart
How to modify the axes labels of a chart
Drilling up or down data hierarchies in a chart
How to drill down through a category series to view detailed information
How to drill up through a category series to view summary information
How to drill down through a value series to view detailed information
How to drill up through a value series to view summary information
Switching views between a chart and a report element
Exporting data from a chart
Exporting a chart
Modifying Flash charts and gadgets
Using Flash gadgets
Meter gadget
Linear gauge gadget
Cylinder gauge gadget
Thermometer gadget
Bullet gadgets
Sparkline gadget
Modifying the subtype of a Flash chart or gadget
Formatting a Flash chart
Formatting a Flash gadget
Modifying general properties
Modifying needle properties
Modifying plot properties
Modifying scale properties
Modifying region properties
Modifying tick marks
Modifying the value property
Filtering data in a Flash chart or gadget
Drilling up or down data hierarchies in a Flash chart
Selecting a legend item to hide specific Flash chart data
Exporting data from a Flash chart or gadget
Exporting a Flash chart or gadget
Printing a Flash chart or gadget
Using effects
Modifying Adobe Flash Player options
Modifying HTML5 charts
Comparing HTML5, Flash, and standard charts
Formatting an HTML5 chart
Filtering data in an HTML5 chart
Drilling up and down data hierarchies
Selecting a legend item to hide specific chart data
Using effects in HTML5 charts
Exporting data from an HTML5 chart
Exporting an HTML5 chart
Printing an HTML5 chart
Modifying cross tabs
About cross tabs
Introducing a cross tab
Parts of a cross tab
Formatting cross tab data
Selecting a cross tab element
Changing font properties and alignment
Reverting to default formats
Displaying details about data values
Changing the width of a column or height of a row
Analyzing cross tab data
Exporting cross tab content
Modifying charts in a cross tab
Printing a cross tab
Saving a cross tab
Modifying summary tables
About summary tables
About columns in a summary table
About modification options
Editing and formatting summary-table data
Organizing data in a summary table
Sorting data
Showing and hiding columns in a report
Moving and deleting a column
Filtering data in a summary table
Modifying a chart in a summary table
Saving a modified summary table
Functions and operators
Functions
Functions used in computed column expressions
% OF( )
% OF DIFFERENCE( )
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( )
DIFFERENCE( )
FIND( )
IF( )
IN( )
ISNULL( )
LEFT( )
LEN( )
LIKE( )
LOWER( )
MOD( )
MONTH( )
NOTNULL( )
NOW( )
PRODUCT( )
QUARTER( )
RANK( )
RATIO( )
RIGHT( )
ROUND( )
ROUNDDOWN( )
ROUNDUP( )
RUNNINGSUM( )
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
Two
Configuring Actuate BIRT Viewer
Configuring the Actuate BIRT Viewer toolbar using iv_config.xml
Configuring Actuate BIRT Viewer using web.xml
Configuring a BIRT Viewer Java Extension
Configuring default export formats
Actuate BIRT Viewer URIs
About the BIRT Viewer servlet
Using open-source BIRT URIs in Actuate BIRT Viewer
Accessing the BIRT Viewer using a URI
Information Console file manager URIs overview
Information Console file manager URIs quick reference
Common URI parameters
Information Console file manager URIs reference
about page
banner page
browse file page
delete file status page
detail page
drop page
error page
execute report page
home page
index page
list page
page not found page
parameters page