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. Business Objects owns the following U. S. 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. [. . . ] For example, to retrieve data for exam grades lower than 40, create the filter "[Exam Grade] Less Than 40". Less Than Or Equal To operator Use the Less Than Or Equal To operator to retrieve data less than or equal to a value. For example, to retrieve data for customers whose age is 30 or less, create the filter "[Age] Less Than Or Equal To 30". Between operator Use the Between operator to retrieve data between and including two values. 184 Building reports using the Java Report Panel Filtering reports Report filter operators 18 For example, to retrieve data for weeks starting at week 25 and finishing at 36 (including week 25 and week 36), create the filter "[Week] Between 25 and 36". Not Between operator Use the Not Between operator to retrieve data outside the range of two values. For example; to retrieve data for all the weeks of the year, except for and not including weeks 25 through 36, create the filter "[Week] Not between 25 and 36". In List operator Use the In List operator to retrieve data corresponding to values in a list of values. For example, to retrieve data for the US, UK and Japan only, create the filter [Country] In List ("US";"UK";"Japan"). Not In List operator Use the Not In List operator to retrieve data that does not correspond to multiple values. For example, if you do not want to retrieve data for the US, UK and Japan, create the filter [Country] Not In ("US";"UK";"Japan"). Is Null operator Use the Is Null operator to retrieve data for which there are no values in the database. For example, to retrieve customers without children (the children column in the database has no value), create the filter [Children] Is Null. Building reports using the Java Report Panel 185 18 Filtering reports Creating, editing and deleting report filters Is Not Null operator Use the Is Not Null operator to return data for which there is a value in the database. For example, to return customers with children, create the filter [Children] Is not Null. Creating, editing and deleting report filters To create a report filter using the Quick Filter option 1. Click the report tab of the report you want to filter. If you want to filter a block (that is, a table, chart, or form), then click the top edge of the block to select it. If you want to filter a section, and not just the section cell, click View Structure and then select either the start section or end section divider. Click the arrow to the right of the Add Filter button on the Report toolbar and select Add Quick Filter. The values for the selected section or block are listed. Select the value(s) you want to display in the section or block. The selected section or block only displays values that correspond to the value you selected. To delete the quick filter, click the arrow to the right of Add Filter and select Remove Filter. To create a report filter using the Filter Editor 1. Click the report tab of the report you want to filter. 186 Building reports using the Java Report Panel Filtering reports Creating, editing and deleting report filters 18 2. On the Report toolbar, click the Show/Hide Filter Pane button to display the Report Filters pane. Select the part of the report you want to filter. The Report Filters pane displays the name of the selected part of the report. For example, if you select a table, the Report Filter pane displays the name of the selected table. In the Data tab, select the object you want to filter. Drag the selected object onto the Report Filters pane. [. . . ] 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. Use the operator appropriate to your target RDBMS. For more details on the Select statement, creating link objects, and using link objects in InfoView, refer to the Designer's Guide. Working with hyperlinks To link to another document from a hyperlink To link to another document from a hyperlink, the hyperlink must first have been created. Hover your mouse pointer over the cell to display the tooltip if a tooltip is defined. Note: If you used the Hyperlink dialog box to define the link and the Formula Bar is displayed, the hyperlink syntax generated by Web Intelligence appears in the Formula Bar. [. . . ]