BIRT : a field guide / Diana Peh, Nola Hague, Jane Tatchell

Author: Peh, Diana
Published: Upper Saddle River, NJ : Addison-Wesley, 2011.
Edition: 3rd ed.
Physical Description: xxx, 801 pages : illustrations ; 24 cm.
Additional Creators: Hague, Nola and Tatchell, Jane

Availability

Finding items...

Series

Eclipse series

Contents

Machine generated contents note: pt. I Installing BIRT -- ch. 1 Introducing BIRT Report Designers -- Understanding BIRT components -- Understanding Eclipse BIRT packages -- About types of BIRT builds -- ch. 2 Installing a BIRT Report Designer -- Installing BIRT Report Designer Full Eclipse Install -- Installing BIRT RCP Report Designer -- Troubleshooting installation problems -- Avoiding cache conflicts after you install a BIRT report designer -- Specifying a Java Virtual Machine when starting BIRT report designer -- Installing a language pack -- Updating a BIRT Report Designer installation -- Updating BIRT RCP Report Designer installation -- pt. II Getting Started -- ch. 3 Learning the Basics -- About BIRT reports -- Overview of the report design process -- About the report design environment -- Starting BIRT Report Designer -- Report design views -- Report editor -- Palette -- Data Explorer -- Resource Explorer -- Property Editor -- Navigator -- Outline -- Problems -- Tutorial 1 Building a simple listing report -- Task 1 Create a new project -- Task 2 Create a new report -- Task 3 Build a data source -- Task 4 Build a data set -- Task 5 Lay out the report -- Task 6 Sort the data -- Task 7 Format the report -- Edit the column headings -- Format the column headings -- Display first and last names on the same line -- Increase the space between rows -- Task 8 Create a report title -- Next steps -- About report files and supported formats -- Report design files -- Report output formats -- Previewing a report -- Viewing sample reports -- ch. 4 Planning Your Report -- Identifying the content of the report -- Determining how the report will be viewed -- Considering international reporting requirements -- Deciding the layout and format of the report -- Drawing a mock-up -- Considering reuse of report components -- Managing report design resources -- Deciding how the report will be deployed -- pt. III Accessing and Binding Data -- ch. 5 Connecting to a Data Source -- About BIRT data sources -- Connecting to a database using JDBC -- Creating a JDBC data source -- Managing JDBC drivers -- Addinga JDBC driver -- Deletinga JDBC driver -- Restoring a JDBC driver -- Connecting to a text file -- Text file structure -- Text file data types -- Creating a flat file data source -- Connecting to an XML file -- Connecting to a web service -- Creating reusable data sources -- Creating a connection profile -- Using a connection profile -- Setting connection properties when a report runs -- Setting the folder path for text files at run time -- Setting the database user name and password at run time -- Troubleshooting data source problems -- ch. 6 Retrieving Data -- About data sets -- Selecting data -- Using a SQL query to retrieve data from a JDBC data source -- Writing a basic SQL query -- Combining data from multiple tables -- Using a stored procedure to retrieve data from a JDBC data source -- Specifying what data to retrieve from a text file -- Specifying what data to retrieve from an XML data source -- Specifying what data to retrieve from a web service -- Viewing and changing output columns -- Adding a computed field to a data set -- Joining data sets -- Verifying the data returned by a data set -- Specifying the data to retrieve at run time -- About the Query Text property -- Specifying a value for the Query Text property -- ch. 7 Binding Data -- Understanding column bindings -- Descriptive names -- Dynamic updates of calculated data -- Creating column bindings -- Editing and deleting column bindings -- Copying data elements -- More about column-binding expressions -- pt. IV Designing Reports -- ch. 8 Laying Out a Report -- Understanding the layout model -- About the report layout elements -- Overview of the layout process -- Creating the sections of a report -- Organizing elements in a grid -- Adding rows and columns -- Deleting rows and columns -- Organizing elements in a table -- Deciding where to place elements in a table -- Binding a table to a data set -- Adjusting table rows and columns -- Organizing elements in a list -- Deciding where to place elements in a list -- Binding a list to a data set -- Placing report elements -- Placing report elements side by side -- Inserting a data set field -- Inserting a computed field -- Inserting an image -- Resizing an image -- Providing a text alternative -- ch. 9 Displaying Text -- Types of textual elements -- Deciding which textual element to use -- Using a dynamic text element -- Using a label element -- Using a text element -- Applying multiple style formats to text -- Combining a JavaScript expression and static text -- Combining a value from a data set field and static text -- Formatting dynamic values in a text element -- Displaying data set field values that are stored as HTML text -- Displaying text from right to left -- Setting text flow direction for a report -- Setting text flow direction for an element -- ch. 10 Formatting Report Content -- Formatting data -- Formatting numeric data -- Formatting numeric data in a data element -- Formatting numeric data in a text element -- Formatting date-and-time data -- Formatting date-and-time data in a data element -- Formatting date-and-time data in a text element -- Formatting string data -- Formatting text in a data element -- Formatting text data in a text element -- Copying formats -- Formatting with styles -- Creating styles -- Reusing CSS styles -- Importing styles -- Linking a CSS file -- Applying a style -- Modifying a style -- Deleting a style -- Formatting data based on conditions -- Creating a formatting rule -- Modifying a formatting rule -- Creating multiple formatting rules -- Deleting a formatting rule -- Alternating row colors in a table -- Specifying alignment of content in a table or grid -- Aligning text horizontally -- Aligning content vertically -- Adjusting the spacing of content in a report -- Wrapping text onto multiple lines -- Resizing rows and columns -- Resizing margins, borders, and padding of elements -- Specifying auto-expand layout for HTML output -- Displaying data values in one row -- Displaying content across multiple columns -- Specifying alternate values for display -- Hiding elements based on conditions -- ch. 11 Sorting and Grouping Data -- Sorting data -- Ways to sort data -- Setting the sort strength -- Sorting string data ignoring capitalization -- Grouping data -- Grouping data by intervals -- Grouping string data by intervals -- Grouping numeric data by intervals -- Grouping date-and-time data by intervals -- Sorting data at the group level -- Disabling group sorting -- Creating multiple groups -- Changing the order of groups -- Adding group headings -- Inserting group header rows -- Displaying group headings in the detail row -- Specifying expressions for group headings -- Tutorial 2 Grouping report data -- Task 1 Open the report design -- Task 2 Save the report as a new file -- Task 3 Add the credit limit field to the data set -- Task 4 Add credit limit data to the report -- Task 5 Group customer data by credit limit -- Task 6 Display credit limit ranges in the group header -- Task 7 Display aggregate information -- Display the number of customers in each group -- Display the total number of customers in the report -- Task 8 Format the report -- Adjust the column widths -- Remove credit limit data from the detail rows -- Display group headings on the first row of each group -- Separate each group with a line -- Display the number of customers text on one line -- Task 9 Preview the report in the BIRT report viewer -- Task 10 Display credit limit ranges in the table of contents -- ch. 12 Aggregating Data -- Types of aggregate calculations -- Placing aggregate data -- Creating an aggregation -- Filtering aggregate data -- Excluding null values from an aggregate calculation -- Counting unique field values in a set of rows -- Calculating percentages -- Creating a summary report -- Hiding details -- Creating a top n report -- ch. 13 Writing Expressions -- Basic concepts -- Data types -- Case sensitivity -- Multiline expressions -- Using the expression builder -- Creating an expression -- Validating an expression -- Manipulating numeric data -- Computing values from multiple numeric fields -- Order of operations -- Division by zero -- Converting a number to a string -- Manipulating string data -- Substituting string values -- Combining values from multiple fields -- Removing null values from combined fields -- Removing spaces from the ends of strings -- Getting parts of a string -- Matching string patterns -- Using pattern-matching in filter conditions -- Using pattern-matching to search and replace string values -- Converting a string to a number -- Converting a string to a date -- Manipulating date-and-time data -- Displaying the current date -- Getting parts of a date or time as a number -- Calculating the time between two dates -- Calculating a date -- Using specific dates in an expression -- Using Boolean expressions -- ch. 14 Filtering Data -- Filtering opportunities -- Specifying conditions on row retrieval -- Filtering database data -- Types of SQL filter conditions -- Filtering XML data -- Filtering data after row retrieval -- Deciding where to filter in BIRT -- Types of BIRT filter conditions -- Creating a filter condition -- Creating multiple filter conditions -- ch. 15 Enabling the User to Filter Data -- About report parameters -- Planning to use report parameters -- User filtering options -- Enabling user filtering at query run time -- Creating a report parameter -- Inserting a parameter marker in the SQL query -- Defining a data set parameter and binding it to the report parameter -- Creating a SQL query at run time -- Enabling user filtering after data retrieval -- Creating a report parameter -- Updating a filter condition when the report runs -- Designing the presentation of report parameters -- Providing a default value --, Contents note continued: Providing the user with a list of values -- Creating a static list of values -- Creating a dynamic list of values -- Enabling the user to select multiple values -- Formatting report parameter values -- Enabling the user to specify null or blank values -- Organizing report parameters in groups -- Creating cascading report parameters -- Changing the order in which report parameters appear -- Testing the report parameters -- Tutorial 3 Creating and using report parameters -- Task 1 Create a new report -- Task 2 Build a data source -- Task 3 Build a data set -- Task 4 Lay out the data -- Task 5 Create a report parameter that prompts for a minimum product quantity -- Task 6 Create a report parameter that prompts for a vendor name -- Task 7 Edit the query -- Task 8 Create data set parameters and bind them to the report parameters -- Task 9 Test the report parameters -- Task 10 Provide the option to select all vendors -- Task 11 Create a title that uses the report parameter values -- ch. 16 Building a Report That Contains Subreports -- Creating the report structure -- Building a report with independent subreports -- Building a report with linked subreports -- Creating the structure of a report with linked subreports -- Linking master and detail reports -- Tutorial 4 Building a report containing side-by-side subreports -- Task 1 Create a new report -- Task 2 Build a data source -- Task 3 Build a data set for the customer report -- Task 4 Build a data set for the orders subreport -- Task 5 Build a data set for the payments subreport -- Task 6 Create the customer master report -- Task 7 Create the orders subreport -- Task 8 Link the orders subreport to the customers master report -- Task 9 Create the payments subreport -- Task 10 Link the payments subreport to the customers master report -- Task 11 Display only customers that have orders or payments -- Task 12 Display the subreports next to one another -- Task 13 View tike outline of the report -- Task 14 Format the report -- Highlight the customer names -- Edit and format the column headings -- Change the date formats -- Change the number formats -- Increase the vertical space between elements -- ch. 17 Using a Chart -- Surveying the types of charts -- About area charts -- About bar charts -- About tube, cone, and pyramid charts -- About line charts -- About meter charts -- About pie charts -- About scatter charts -- About bubble charts -- About stock charts -- About difference charts -- About Gantt charts -- Tutorial 5 Creating a stand-alone chart -- Task 1 Set up and query the data source -- Task 2 Add the chart to the report -- Task 3 Provide data for a chart -- Task 4 Enlarge the chart and preview the report -- Task 5 Change the chart and value series titles -- Task 6 Refine the chart appearance -- Exploring the chart builder -- Creating a chart with depth or three dimensions -- Using chart subtypes -- Understanding chart output formats -- Using a chart in a table -- ch. 18 Displaying Data in Charts -- Linking data to a chart -- Linking to data from a container -- Linking to data from a data set, data cube, or report item -- Understanding the axes of a chart -- About the axes -- Defining the axes -- Plotting different chart types -- Plotting the x- and y-axes -- Grouping and sorting category data -- Grouping date-and-time data -- Grouping textual data -- Grouping numeric data -- Sorting category data -- Grouping optional Y value data -- Grouping Y values in a bar chart -- Grouping multiple y-axis values in a stock chart -- Using multiple y-axes -- Transposing chart axes -- Filtering data -- Changing default report parameters -- Creating data bindings -- Previewing data and chart -- Creating a combination chart -- Defining a meter chart -- Using multiple meters in a chart -- Using multiple dials in a chart -- ch. 19 Laying Out and Formatting a Chart -- Overview of formatting -- Formatting specific types of charts -- Formatting an area chart -- Formatting a line or a scatter chart -- Formatting a bar chart -- Formatting a bubble chart -- Formatting a difference chart -- Formatting a Gantt chart -- Formatting a meter chart -- Working with the dial size -- Working with the dial scale and tick marks -- Working with needle formats -- Working with multiple meters -- Working with meter chart labels -- Working with dial regions -- Formatting a pie chart -- Working with aspect ratio and rotation -- Working with leader lines -- Working with pie slices -- Exploding pie slices -- Arranging multiple pies -- Formatting a stock chart -- Formatting a three-dimensional chart -- Working with chart rotation -- Working with the space between elements -- Setting the wall and floor colors -- Setting the series depth of a chart -- Setting chart area format attributes -- Setting the background color for a chart -- Outlining a chart -- Adding padding around the chart -- Formatting the chart legend, plot, and title -- Working with the plot area -- Setting the color, outline, or shadow for the plot -- Placing and adding space around the plot -- Specifying the plot size -- Formatting the chart title text -- Formatting the title area -- Working with the legend -- Setting the color, outline, or shadow for the legend -- Placing and adding space around a legend -- Showing series item values in a legend -- Formatting the legend text -- Formatting a legend title -- Formatting axis titles, markers, lines, and labels -- Working with an axis title -- Working with axis markers -- Adding an axis marker -- Adding a marker line -- Adding a marker range -- Formatting axis markers -- Working with an axis line -- Working with axis labels -- Defining the axis data type and number format -- Defining where one axis intersects the other -- Defining the scale of an axis -- Formatting a series -- Stacking series -- Hiding a series -- Making a series translucent -- Setting the color palette for a series -- Formatting numbers, dates, and times -- Working with data points and data point labels -- Adding and formatting a curve-fitting line -- ch. 20 Presenting Data in a Cross Tab -- Tutorial 6 Creating a cross tab -- Task 1 Create a new report -- Task 2 Build a data source -- Task 3 Build a data set -- Task 4 Set up data for the cross tab -- Task 5 Add a cross tab to the report -- Task 6 Add grand totals -- Task 7 Format the cross tab -- Expand the width of the cross tab to fit the data -- Display a string in empty cells -- Change the format of the numbers -- Edit the column headings -- Use darker lines around the cross tab and the cells -- Setting up data for a cross tab -- About cubes -- Planning the data -- Designing the cube -- Designing data sets for a cube -- Comparing OLTP and OLAP -- Designing a single data set -- Designing multiple data sets in a star schema -- Building a multi-dataset cube -- Building a cross tab -- Areas of a cross tab -- Displaying multiple dimensions in row and column areas -- Displaying or hiding dimension levels -- Displaying multiple measures -- Adding a derived measure -- Adding subtotals and grand totals -- Displaying totals before the detail data -- Displaying totals as charts -- Displaying empty rows and columns -- Displaying user-defined values in row and column headings -- Sorting cross tab data -- Limiting the amount of data the cross tab displays -- ch. 21 Presenting Different Views of the Same Data -- Ways to share data -- Sharing a data set -- Sharing a cube -- Sharing data defined in another report element -- Guidelines for selecting a data-sharing method -- Building a dashboard report -- Using data from a table -- Using data from a cross tab -- Using data from a chart -- pt. V Enhancing Reports -- ch. 22 Designing a Multipage Report -- Planning the page layout -- Controlling pagination -- Inserting page breaks -- Inserting page breaks in a report with multiple sections and groups -- Inserting page breaks in a master-detail report -- Avoiding page breaks in a section -- Specifying the number of rows per page -- Customizing the master page -- Viewing the master page -- Designing the page header and footer -- Displaying page numbers, the current date, and other text -- Displaying an image -- Specifying a header size -- Specifying a footer size -- Excluding header content from the first page -- Displaying an image in the background -- Designing the appearance of the background image -- Positioning the background image -- Displaying different content in different output formats -- Specifying page size, orientation, and margins -- Using multiple master pages -- ch. 23 Adding Interactive Viewing Features -- Creating hyperlinks -- Linking two sections in a report -- Defining a bookmark -- Defining a hyperlink -- Linking to a section in a different report -- Linking to external content -- Creating a table of contents -- Using the default table of contents -- Defining a custom table of contents -- Adding interactive chart features -- Defining interactivity events and actions -- Chart formats and supported actions -- Adding interactive elements to an HTML report -- Identifying report elements for data export -- ch. 24 Building a Shared Development Framework -- Sharing report elements using a library -- Understanding dynamic library behavior -- Creating a library -- Developing library report elements -- Grouping library styles into a theme -- Comparing themes and CSS files -- Sharing a library with other report developers -- Placing a library in the resource folder -- Organizing resources -- Updating a shared library -- Designing libraries for a shared environment -- Designing a general library -- Designing a structures library -- Designing structure elements -- Designing data binding for library table elements -- Defining a project library -- Using a library -- Understanding libraries in Resource Explorer -- Using library report elements -- Understanding library name space -- Modifying a library-based element --, and Contents note continued: Using a library table having standardized data binding -- Using styles from a library -- Trouble-shooting library problems -- Sharing a report layout as a template -- Developing a custom template -- Designing template report items -- Registering a template with the New Report wizard -- Using a custom template -- ch. 25 Localizing Text -- Overview of the localization process -- Assigning a resource file to a report -- Assigning resource keys -- Assigning a resource key to a label or text element -- Changing localized text in a label or text element to static text -- Assigning a resource key to chart text -- Changing localized chart text to static text -- Assigning a resource key to a data value -- Assigning a resource key to a report parameter -- Editing a resource file -- Previewing a report in different locales.

Subject(s)

ISBN

0321733584
9780321733580

Note

Includes index.

View MARC record | catkey: 6970116