User manual BUSINESS OBJECTS ENTERPRISE XI 3.1 BUILDING REPORT USING THE JAVA REPORT PANEL

[. . . ] Building reports using the Java Report Panel BusinessObjects Enterprise XI 3. 0 Copyright © 2008 Business Objects, an SAP company. patents, which may cover products that are offered and licensed by Business Objects: 5, 295, 243; 5, 339, 390; 5, 555, 403; 5, 590, 250; 5, 619, 632; 5, 632, 009; 5, 857, 205; 5, 880, 742; 5, 883, 635; 6, 085, 202; 6, 108, 698; 6, 247, 008; 6, 289, 352; 6, 300, 957; 6, 377, 259; 6, 490, 593; 6, 578, 027; 6, 581, 068; 6, 628, 312; 6, 654, 761; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998; 6, 892, 189; 6, 901, 555; 7, 089, 238; 7, 107, 266; 7, 139, 766; 7, 178, 099; 7, 181, 435; 7, 181, 440; 7, 194, 465; 7, 222, 130; 7, 299, 419; 7, 320, 122 and 7, 356, 779. Business Objects and its logos, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Cartesis, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Crystal Vision, Desktop Intelligence, Inxight and its logos , LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let There Be Light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. SAP is the trademark or registered trademark of SAP AG in Germany and in several other countries. [. . . ] This symbol changes depending on the default or the last calculation selected for insertion. For example, if the calculation is Sum, the button displays the symbol. Note: If you insert a percentage calculation, the results of the percentage are displayed in an additional column or row of the table. To insert other calculations, click the down arrow next to the Sum icon and select the calculation from the drop-down list. 176 Building reports using the Java Report Panel Calculations, formulas and variables Working with formulas 17 A new row is added at the bottom of the table. The aggregated value appears in the new row cell. To remove a standard calculation 1. · If you are in Result View this is the calculated value · If you are Structure View, this is the cell that contains the aggregate formula 2. Depending on the table type, select Remove Row or Remove Column from the shortcut menu. Working with formulas The Formula toolbar You display the Formula toolbar by clicking the Show/Hide Formula Toolbar button on the Reporting toolbar. Now, when you select a cell, its formula appears in the Formula toolbar. The Formula toolbar has the following buttons, from left to right: Button Description Opens the Formula Editor which allows you to build a formula using a graphical interface Allows you to save a formula as a variable Clears all changes made to the formula since the last save or validation Verifies the formula syntax and replaces the current formula Open Formula Editor Create variable Clear changes Validate formula Building reports using the Java Report Panel 177 17 Calculations, formulas and variables Working with formulas To enter a formula directly into the Formula toolbar without using the Variable Editor, you can type the formula or drag report objects to the formula toolbar. To enter a formula in the Formula toolbar by typing the formula 1. For example, to calculate the average revenue generated per item sold, type: =[Sales Revenue]/[Quantity Sold]. Web Intelligence gives you suggestions for completing the component of the formula you are typing. To select a Web Intelligence suggestion, press the down arrow button to highlight it, then press Return, or select the suggestion with your cursor. To select a Web Intelligence suggestion, press the down arrow button to highlight it, then press Return. To enter a formula in the Formula toolbar by using drag and drop · Drag reports objects onto the Formula toolbar. When you release an object, it appears in the Formula toolbar at the cursor position as if you had typed it directly. To build a formula using the Formula Editor 1. Click the Formula Editor button on the Formula toolbar to display the Formula Editor. On the Data, Functions and Operators tabs, double-click the report objects, functions and operators you want to include in the formula, or type the formula directly. For example, to create the formula =Average([Revenue]), double-click the Average() function, then double-click the Revenue object. When you double-click a function to include it in a formula, Web Intelligence places the cursor between the function parentheses. 178 Building reports using the Java Report Panel Calculations, formulas and variables Working with variables 17 Working with variables To create a variable from a formula 1. Type your formula in the Formula toolbar or select a cell containing a formula. Click Create Variable on the Formula toolbar The "Create Variable" dialog box appears. If you select Detail, an "Associated Dimension" box appears. next to the box to open the "Objects and Variables" dialog box and select the dimension you want to associate with the detail. The variable appears in the list of report variables in the Data tab. To create a variable using the Variable Editor 1. [. . . ] You can create documents using the link object as you would with any other object. Users can then click the hyperlinks to access more detailed documents related to the link object. To create a link object, use the openDocument function in the object's Select statement. The Select statement for a link object follows this order: '<a href="http://<servername>:<port>/OpenDocument/<platformSpe cific>?sDocName=<document name>&sType=<document type>&iDo cID=<document id>&lsS<prompt message>='+object SELECT+'">'+ob ject SELECT+'</a>' The concatenation operator (+) applies for Microsoft Access databases. [. . . ]