Cognos 简明教程
Cognos - Crosstab Report
系统将提示您选择要创建的报告类型。您可以从不同的报告类型中进行选择。
You will be prompted to select the type of report you want to create. You have option to select from different report types.

选择交叉表作为报告类型并单击确定。
Select Crosstab as type of the report and click OK.
交叉表报告的结构将按以下屏幕截图所示打开。
The structure of a Crosstab report is opened as shown in the following screenshot.

在可插入对象窗格中的源选项卡上,单击要添加到交叉表的 data 项目并将其拖动至行或列。
In the Insertable Objects pane, on the Source tab, click the data item you want to add to the crosstab and drag it to the Rows or Columns.

黑色条表示您可以放置 data 项目的位置。重复上述步骤以插入其他 data 项目。
A black bar indicates where you can drop the data item. Repeat the above given steps to insert additional data items.
您可以将维度添加到行或列,并将度量值添加到交叉表,将要度量值拖动至度量值。
You add dimensions to rows or columns and to add measures to the crosstab, drag the measures you want to Measures.

当您运行报表时,将生成具有一个边缘的交叉表报表。
When you run the report, a crosstab report is generated that has one edge.
Formatting a Crosstab
您还可以设置交叉表格式,以使其外观符合要求。当您为所有行、列、数据单元格或交叉表指定格式时,该格式将自动应用于您添加的任何新项目。
You can also format the crosstab to give them appearance as per the requirement. When you specify formatting for all rows, columns, fact cells, or the crosstab, the formatting is automatically applied to any new items you add.
Crosstab Style order
当您应用诸如字体颜色等样式、行和列、交叉点时,将按以下顺序应用这些样式。
When you apply styles such as font color, rows and columns, intersections this is applied in the following order.
-
Crosstab fact cells
-
Fact cells in the outermost rows
-
Fact cells in the innermost rows
-
Fact cells in the outermost columns
-
Fact cells in the innermost columns
-
Crosstab intersections
若要设置交叉表的格式,请点击交叉表中的任何位置。点击属性窗格标题栏中的选择祖先按钮,然后点击交叉表,如下图所示。
To do formatting of crosstab, click anywhere in the Crosstab. Click the select ancestor button in the title bar of the Properties pane and then click Crosstab as shown in the following screenshot.

在属性窗格中,点击所需的属性,然后指定值。例如,如果您要指定背景颜色,请点击背景颜色,然后选择要使用的颜色。
In the Properties pane, click the property you want and then specify a value. For example, if you want to specify a background color, click on Background Color and choose the color you want to use.

您还可以右键点击行或列并点击选择成员实际单元格。在属性窗格中,点击所需的属性,然后指定值。
You can also right-click the row or column and click Select Member Fact Cells. In the Properties pane, click the property you want and then specify a value.
