Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Adding Other Report Elements

You can resize report band items and use the tools available on the Format toolbar to change properties such as number, font, alignment, border, and background.

You can also add graphic items and fields from the Catalog pane to enhance your report. For example, use the Text Label tool to add text labels that identify values for numeric report group headers. Review the following topics for information on:

Working with Graphic Elements

Working with Fields

Working with Computed Fields

Inserting Limit Values

Working with Graphic Elements

Intelligence Clients provides a complete set of graphic elements to assist you in designing presentation-quality reports (see the Report Section Graphic Elements table). Lines, rectangles and ovals are considered vector graphics. Vector graphics consist of commands for creating the measures and shape of each line, rectangle, arc, and so on. The resolution of the output device defines the look of the vector graphic, since a vector graphic has no fixed resolution. This property enables you to resize the vector graphic without changing its resolution. Since a vector graphic contains only the instructions for creating an image, it requires less disk space.

Pictures are considered bitmapped graphics. A bitmap graphic consists of pixels, which have the appearance of small points. In computer memory, a pixel is shown as one or more bits, containing instructions for color, density and appearance for each pixel shown. As a result, bitmaps use more disk space and have a fixed resolution. If you resize a bitmap image, it may distort the original image.

To insert a graphic object from the Catalog pane:

  1. Go to the Catalog pane and expand the folder containing the desired graphic object.
  2. Click the graphic object; then, drag and drop the object into the Contents pane.

To insert a graphic object from the Report menu:

  1. Report then Insert Graphic.
  2. Select a graphic object from the menu that appears.
  3. Click the Contents pane to insert the graphic.
  4. Report Section Graphic Elements 

    Element
    Description
    Line
    Creates a line that you can rotate.
    Hz Line
    Creates a horizontal line.
    Vt Line
    Creates a vertical line.
    Rectangle
    Creates a rectangle.
    Round Rectangle
    Creates a rectangle with rounded corners.
    Oval
    Creates an oval.
    Text Label
    Creates a text label that you can use as a caption.
    Picture
    Allows you to insert bitmaps (.bmp extension).
    Name
    Sets the object’s name.
    Visible
    Allows the object to be visible during Run Mode. Use this to hide objects.
    Locked
    Locks an object. Use this to lock objects so they cannot be changed.

Working with Fields

a computable field and predefined fields to assist you constructing and producing reports (see the Report Section Fields table). You can drag and drop these fields anywhere within the report page, body, report group header, report header/footer, and page header and footer. You can also customize how numbers, dates, time, and text fonts appear in your report. For numbers, you can choose whether to use commas, decimals place, dollar signs or percentage symbols. For text items, you can choose fonts styles and sizes. For Query and Result limits, you can select specific limits.

Report Section Fields 

Field Name
Description
Field
Inserts a computed field.
Query Limit
Inserts a selected query limit.
Result Limit
Inserts a selected result limit.
Query SQL
Inserts the last SQL sent to the database when you process a query.
Page Number
Inserts a page number.
Number of Pages
Inserts the total number of pages.
Page X of Y
Inserts the current page of the total number of pages.
Last Saved
Inserts date on which the report was last saved in MM/DD/YYYY format.
Last Printed
Inserts date on which the report was last printed in MM/DD/YYYY format.
Date
Inserts and stamps the current date in MM/DD/YYYY format.
Time
Inserts and stamps current time in HH:MM:SS format.
Date & Time
Inserts and stamps date and time in MM/DDYYYY and HH:MM:SS format.
Date Now
Inserts the current date in MM/DD/YYYY format.
Time Now
Inserts the current time in HH:MM:SS format.
Date & Time Now
Inserts the current date and time in MM/DDYYYY and HH:MM:SS format.
File Name
Inserts the document (.bqy) name.
Path Name
Inserts the full path name of the document.
Report Name
Inserts the report name.


Working with Computed Fields

A computed field contain a single value based on a calculation. You can create customized JavaScript expressions or modify JavaScript syntax for an existing report element.

To create a computed field:

  1. Choose Report then Insert Field.
  2. The cursor changes to a crosshair.

  3. Left-click and hold your left mouse button to position your cursor in the report component where you want to insert the field, and then drag to create the table.
  4. A field labeled Empty Field is inserted.

  5. Click the empty field to select it, and then enter JavaScript syntax in the Expression line.
  6. You can copy and paste JavaScript syntax from existing report items into the Expression line to build the expression. To do this, select an existing item and copy the syntax in the Expression line. Then select the new field and paste the syntax into the Expression line.

  7. When you have defined the equation, click the check icon.
  8. The field displays the computed value.

A computed field repeats itself based on the band, header, or footer in which you insert it as shown below:

Report Element
Repeats
Report Group Header
Every Header band
Report Body
Every Body band
Report Header
Very first page
Report Footer
Very last page
Page Header
Every page
Page Footer
Every page


Inserting Limit Values

You can select and show limits applied in the Query and Results sections to aid in the visual construction and production of the report.

To use a limit value in a report:

  1. Choose Report then Insert Predefined Field then Query Limit or Result Limit.
  2. The cursor changes to a crosshair.

  3. Left-click and hold your left mouse button to position your cursor in the report component where you want to insert the limit field, and then drag to create the field.
  4. The Insert Limit Values dialog box appears.

    Insert Limit Values dialog box

  5. In the Query or Result Sections list, select the section that contains the limits that you want to show.
  6. A list of applied limits populates the Limit Names list.

  7. Select the Limit Name that you want to use from the Limit Names list.
  8. To show the operator used in the expression, select the Include Limit Operator check box.

  9. Click OK.

To modify the Limit field name or the values being shown:

*

Double-click the Limit field and modify the statement on the Expression line.

The JavaScript expression for the Limit Value field appears in the Expression line.

JavaScript expression for the Limit Value field in the Expression line


Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.