• About Using BIRT Studio - iHub Edition
•  Designing reports using BIRT Studio
  •  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
      • How to save a new report
      • How to save a report and change its name or location
    • Running and viewing a report
  •  Editing and formatting report content
    • Editing and formatting options
    •  Removing items from a report
      • How to select the items to remove or display
    •  Editing labels
      • How to edit a label
    •  Applying a theme
      • How to apply a theme
    • Selecting an item for formatting
    •  Changing font properties
      • How to change font properties
    •  Changing the alignment of text
      • How to change 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
      • How to apply a date‑and‑time format
      • Selecting a standard date‑and‑time format
      • Defining a custom date‑and‑time format
    •  Applying a string format
      • How to apply 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
        • How to select a comparison value from a list of values
        • Comparing to a value in another column
        • How to compare to a value in another column
      • Specifying multiple conditional formatting rules
      • Reverting to default formats
    •  Managing columns
      • How to change the order of columns
      • How to hide a column
      • How to display a hidden column
    •  Merging data into one column
      •  Creating a merged column
        • How to merge data into one column
        • How to merge column headers
      • 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
        • How to set a column’s width
      •  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
        • How to sort data 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
        • How to change 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
      • How to hide the details of a group
      • How to hide the details of a section
      • How to re-display the details of a group or section
    •  Suppressing duplicate values
      •  Avoiding repeated values in a column
        • How to suppress duplicate values in a column
        • How to show hidden duplicate values in a column
      •  Avoiding repeated values in a group
        • How to suppress duplicate values in a grouped column
    •  Starting each group or section on a new page
      • How to set a page break
  •  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
        • How to compare to a value in another column
      •  Defining multiple filter conditions
        • Adding a condition
        • How to define multiple filter conditions
        • Changing a condition
        • Deleting a condition
      •  Defining a filter at the data set level
        • How to create a data set filter using Switch Filter Pane
        • 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
        • Moving a dimension column
        • Deleting a dimension column
      •  Working with an attribute column
        • Inserting an attribute column
        • Modifying an attribute column
        • Moving an attribute column
        • Deleting an attribute column
      •  Working with a measure column
        • Inserting a measure column
        • Modifying a measure column
        • Adding an aggregate calculation
        • Moving a measure column
        • Deleting a measure column
      • Formatting aggregate values
      • Filtering aggregate data
    • Inserting a chart in a summary table
    •  Changing table types
      • How to convert a summary table to a detail table
      • How to convert a detail table to a summary table
  •  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
        • How to save and view 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
        • Applying a chart theme
        • Examining details for axis data
    • 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
        • How to define a bookmark for a report table
        • How to define a bookmark for a report element in a section
      • Modifying a bookmark
      • Deleting a bookmark
    •  Using hyperlinks
      •  Creating a hyperlink
        • How to create a hyperlink
        • Linking two sections in a report
        • How to create a hyperlink that links two sections in a report
        • Linking to a section in a different report
        • How to create a drill‑through hyperlink
        • Linking to a URL
        • How to create a hyperlink to an external 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
      • How to join information objects
    •  Getting current data from an information object
      • How to synchronize data sets
•  Customizing and integrating BIRT Studio
  •  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
      • How to create 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
      • How to create a theme
      • How to associate a library with a template
    •  Publishing a template
      • How to create a resource folder on an Encyclopedia volume
      • How to publish a report template
    •  Setting the default template category
      • How to set the default template category
    •  Publishing resources associated with a template
      • How to publish 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
        • How to create an information object
      •  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
        • How to configure 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
      • How to create a user and a home folder, and assign license options
    •  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
      • How to log in
      • How to open BIRT Studio and load an existing report design

About Using BIRT Studio - iHub Edition

Using the BIRT Studio URLs

file_dirty

boolean_formatting

report_design_browsing

brs_help

new_open_choice

report_template_picking

select_datasource

select_dataset

io_browsing

data_manager

data_set_selector

table_builder

table_builder_filter

saveas

saveas_error

font

number_formatting

datetime_formatting

string_formatting

conditional_formatting

value

manage_column

show_columns

available_data_items

border

column_properties

calculation

data_fields

explore_dataset

advanced_sort

group_detail

select_fields

aggregation

move_to_group

page_break

filter

top_bottom_n

calendar

advanced_filter

parameter

edit_parameter

subtotal_function_selection

confirmation

crosstab_builder

chart_settings

flash_chart_settings

html5_chart_settings

bookmark

hyperlink

open_file

functions

operators

join

add_join

add_join_condition