User manual BUSINESS OBJECTS WEB INTELLIGENCE BUILDING REPORTS HTML REPORT PANEL

[. . . ] Building reports using the Web Intelligence HTML Report Panel Building reports using the Web Intelligence HTML Report Panel Copyright © 2008 Business Objects. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 5, 857, 205; 6, 289, 352; 6, 247, 008; 6, 490, 593; 6, 578, 027; 6, 831, 668; 6, 768, 986; 6, 772, 409; 6, 882, 998; 7, 139, 766; 7, 299, 419; 7, 194, 465; 7, 222, 130; 7, 181, 440 and 7, 181, 435. Business Objects and the Business Objects logo, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Desktop Intelligence, Inxight, the Inxight Logo, 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. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Web Intelligence applies the new sort order to the table. Building reports using the Web Intelligence HTML Report Panel 85 13 Sorting data in tables To prioritize multiple sorts on a table 86 Building reports using the Web Intelligence HTML Report Panel Applying sorts to sections 14 14 Applying sorts to sections To sort values in a section A section contains two elements: · · the section cell ­ contains a value for a selected dimension or detail the section ­ contains a block (table, chart, or form) displaying data grouped according to the value in the section cell When you apply a sort to a section, you sort the values displayed in the section cells for that section. For example, if you apply a descending sort on the Year section in the above report, the first section cell and table will display data for 2002 and the next section cell and table will display data for 2001. To sort values in a section 1. Make sure you are in Edit mode with the HTML Report Panel open and verify you are on the Properties tab. If the Properties tab is not visible, select the More report options check box. The name of the selected report appears in the Current report drop-down list box. Leave the displayed report selected, or select a different report by clicking the arrow next to the Current report drop-down list box, and then select a different report from the list. Click Run, if you are generating the results for the first time, or click Apply, if you have already generated the results once. Web Intelligence applies the sort to the results displayed in the report. 88 Building reports using the Web Intelligence HTML Report Panel Breaks 15 15 Breaks Breaks defined Breaks defined A break is a division within a block in which data is grouped according to a selected dimension, detail, or measure into self contained sections. These sections are represented as smaller tables within the same block of data. You use breaks to display all the data for each unique value of an object in separate parts. Using breaks has two main advantages: · · You can more efficiently organize how your data is represented. You can display subtotals. Breaks compared to sections A section breaks up the data into multiple free-standing cells called section headers. Each section header contains one value for a dimension, with a block of data that corresponds to the dimension value. One column contains the values for a dimension, detail, or measure, which are repeated for each other row of values in the block. Default sort order in breaks When you insert a break on an object, the values for the object are automatically sorted in ascending order as follows: · · If the values are numeric, the lowest value appears in the first row of the table, the highest in the last row. If the values are alphabetical characters, then the values are sorted in alphabetical order from top to bottom. You can change this sort order at any time. You can set multiple breaks and set a sort priority on each break, so that you control how the data is displayed when you insert multiple breaks across several dimensions details, or measures. 90 Building reports using the Web Intelligence HTML Report Panel Breaks To insert a break 15 To insert a break 1. Make sure you are in Edit mode with the HTML Report Panel open and verify you are on the Properties tab. If the Properties tab is not visible, select the More report options check box. The name of the selected report appears in the Current report drop-down list box. Leave the displayed report selected, or select a different report by clicking the arrow next to the Current report drop-down list box, and then select a different report from the list. On the Result Preview pane, click the part of the block on which you want to apply or remove a break. If you are working with a table or crosstab you can select the columns, or rows, or body. [. . . ] To deactivate and remove the calculation, press the Shift bar . · Remove a calculation. The check box for the selected calculation is unchecked. The calculation will not be applied to the values for the selected object when you run the report. To generate the reports with the sorts, breaks, and calculations, press Ctrl+Shift+a. Navigating the Format tab The Format tab is where you can modify the formatting of individual reports. To move to the previous item in the frame, press Shift+Tab. Defining formatting for reports The following table lists the keyboard shortcuts that enable you to define formatting for reports. 158 Building reports using the Web Intelligence HTML Report Panel Keyboard shortcuts for accessibility in the HTML Report Panel Navigating the HTML Report Panel frames 27 Task Shortcuts · Press the Tab key until you reach the zone on the Report Preview pane that represents the part of the report you want to format. The objects on the selected report area are displayed in the pane on the right of the Report tab. [. . . ]