5-CognosReportStudio练习试卷.doc

{0Demo 6-1: Create a Complex Report }0{演示６-１：建立一个复杂报表0} {0Purpose:We have been asked by the Vice President of Sales to provide a report showing the quantity sold, revenue and gross profit on all products and related ordering information. }0{目的：销售副总要求我们提供一个报表显示所有产品的销售数量、收入和毛利以及相关的定购信息。0} {0To do this, we will include a list, chart, and crosstab in the same report each reporting on a different measure. }0{为此，我们将在同一个报表中引用一个列表、图表和交叉表，对不同的度量进行报告。0} {0We will also add a header to the report to explain its content. }0{我们将给报表添加一个表头解释其内容。0} 注意：报表中使用模型路径为“公共文件夹”-“Samples”-“Model”-“GO 销售(查询)” {0Task 1. }0{任务1.0} {0Add items to a list report. }0{将对象添加到列表型报表。0} {0Create a new Blank report. }0{创建一个新的Blank报表。0} {0In the Insertable Objects pane, click the Toolbox tab, and then drag and drop a Table onto the work area. }0{在Insertable Objects0}出现Insert Table对话框。 {0Leave the number of columns and rows as 2 and 1 respectively, and click OK. }0{让列数和行数分别为2和1，点击OK。一个有左右两个单元格的表格出现在工作区顶部。0} {0Drag and drop a List into the left cell of the table. }0{将一个List(列表)拖到表格的左边单元格。出现Create - List对话框。0} {0Under Based on, with New query selected, type List to name the query, and then click OK. }0{在Based on区域中的New Query处输入’List’，对查询进行命名，然后点击OK。结果显示如下：0} {0Notice that the list does not take up the entire left table cell. }0{注意该列表并不会占用整个左边的表格单元格。0} {0The space to the right of the list is still part of the left table cell. }0{列表右边的空间仍然是左边表格单元格的一部分。0} {0The right table cell is the thin cell on the far right. }0{右边的表格单元格是最右边的窄单元格。0} {0Drag and drop a Chart into the right cell of the table. }0{将一个Chart（图表）（柱状图）拖放到表格的右边单元格。0} {0Name the new query Chart, and then click OK. }0{把这个新查询命名为Chart，然后点击OK。0} {0In the Insert Chart dialog box, accept the default setting of a column chart, and then click OK. }0{在弹出的Insert Chart对话框中接受柱状图的默认设置，然后点击OK。0} {0Drag and drop a Crosstab to the right of the table to place it below the table. }0{拖放一个Crosstab（交叉表）到表格最右端，这实际是要将图表放在表格下面。0} {0Name the new query Crosstab, and then