PART III in Java

Creation QR Code ISO/IEC18004 in Java PART III

Functions tab Contains the many functions that can be used in formulas Operators tab Contains the operators used to perform numeric and comparison operations in your formulas To create a formula using the Formula Editor in the Java Report panel, do the following: 1 Insert and select a blank cell or table column in a report 2 Click the Show/Hide Formula Toolbar button from the Web Intelligence report toolbar 3 Click the Formula Editor button from the formula toolbar The Formula Editor button will toggle the Formula Editor on and off

4 In the Formula Editor, drag, double-click, or type the components (universe object variables, user-defined variables, functions, operators) into the Formula Editor as shown in Figure 22-1 From the Data tab drag the Revenue object for the formula text box on the right Note that Web Intelligence automatically inserts the equal (=) sign at the beginning of the formula Click the Operators tab and double-click the multiplication operator (*) from the list String and numeric constants are not available in a list and must be typed in directly To complete the formula, place

Part III:

your cursor at the end of your formula in the formula text box by clicking after the multiplication operator and type in the numeric constant 11 5 Click the Validate button in the Formula Editor

The Data tab displays the universe variables and user-defined variables that can be used in a formula The Functions tab displays all of the functions that are provided by Web Intelligence The Operators tab displays the operators used to perform numeric calculations and comparison operations in formulas

22:

the Formula Editor To create a formula using the formula toolbar, follow these steps: 1 Insert and select a blank cell or table column in a report 2 Click the Show/Hide Formula Toolbar button from the Web Intelligence report toolbar 3 Type the formula into the formula text box on the formula toolbar Alternatively, you can drag the variables into the formula text box and type the remaining operators, functions, and constants to complete the formula

Regardless of how you create formulas in the Web Intelligence Java Report panel, either by using the Formula Editor or by typing them directly into the formula toolbar, you must follow these guidelines: Always start the formula with an = sign When you reference a base report variable or variable name, it must be enclosed in square brackets ([]) For example, the formula =[Revenue] * 110 contains a base report variable, [Revenue] Spaces between the components of the formula make the formula easier to read Carriage returns can be added to formulas by using CTRL+ENTER or ALT+ENTER to make the formula easier to read String constants in formulas are always surrounded by double quotation marks like "Year: " For example, if you want to concatenate a label "Year: " to the year returned by the universe object variable, you would enter ="Year: " + [Year] Numeric constants are not surrounded by quotation marks Numeric constants should be entered without any formatting such as dollar signs or thousands separators For example, if you want to add $500,00000 to the [Revenue] universe object variable, you enter =[Revenue] + 500000

As discussed in 17, BusinessObjects XI has multiple report panels with slightly different interfaces and capabilities You set your default panel in your InfoView Preferences Regardless of your default report panel, the concepts behind creating formulas and using them in your reports remains the same; only the user interface is different Following is a brief look at the HTML Report panel s Formula Editor The remainder of this chapter uses the Java Report panel Figure 22-2 shows the Formula Editor in the HTML Report panel To create a formula using the Formula Editor in the HTML Report panel: 1 Insert and select a blank cell or table column in a report

Part III: