用数据透视表报表替换交叉表,忽略条件范围。
Replace crosstab table with PivotTable report ignoring criteria range.
这个例子的报表将是一个交叉表。
动态交叉表和数据立方体特性。
下图显示了交叉表布局的这些更改。
The following image displays these changes to the layout of the crosstab.
该交叉表如下面的屏幕截图所示。
This crosstab is also illustrated in the following screen capture.
这个已投射的交叉表如下图所示。
This crosstab projected is illustrated by the following image.
动态交叉表及数据立方体(data cube)元素。
只能将选择、交叉表和联合查询保存为这种格式。
You can only save select, crosstab , and union queries to this format.
报告作者还决定在Productline 上分区交叉表。
The report author also decides to section the crosstab on Product line.
对于该报表运行,仅在交叉表的行和列边缘上抑制了nulls。
For this report run only nulls are being suppressed on both the row and column edge of the crosstab.
有关更高级的帮助,请参阅主题创建选择或交叉表查询。
For more advanced help, see the topic Create a select or crosstab query.
一种替代解决方案是将切片器替换为嵌套在交叉表边上的显式计算。
An alternative solution is to replace the slicer by an explicit calculation nested on one of the edges of the crosstab.
有关选择查询的详细信息,请参阅主题创建选择或交叉表查询。
For more information about select queries, see the topic Create a select or crosstab query.
当在“数据表”视图中打开选择或交叉表查询时,实际是在执行查询。
When you open a select or crosstab query in Datasheet view, you are actually executing the query.
为了让分类统计的显示效果更清晰,提倡使用交叉表查询显示查询结果。
In order to make the classified results more clearly, we advocate to use the intersection table to show the inquiry results.
有关选择查询的详细信息,请参阅主题创建选择或交叉表查询(MDB)。
For more information about select queries, see the topic Create a select or crosstab query (MDB).
也有些人会这样问“我怎么把东西放到筛选区域或列区域上建立交叉表?”
I can also hear some other folks asking "how do I get things to the Filter area or the Column area to build a crosstab?"
使用基于olap或dmr的包时,在分区的交叉表包含摘要过滤器的报告将生成以下错误。
When using OLAP or DMR based packages, reports which contain summary filters in a sectioned crosstab will produce the following error.
它提供的特性可以让我们直观地给报表应用增加列表、图表、交叉表、文档以及复合报表。
It provides features to visually add Lists, Charts, Cross Tabs, Documents and Compound Reports to report applications.
在下面的交叉表中,报告作者将Year投射为行,将一个使用tuple函数的计算投射在列上。
Within the following crosstab the report author projected the Year as the rows and a calculation which USES the tuple function on the columns.
交叉表的分区将Productline查询项目放置到标头中,生成了一个“主-细节”关系。
The sectioning of the crosstab places the Product line query item into the header and generates a master-detail relationship.
此文结合实例对交叉表查询的创建进行了研究,由简单到复杂,一步步得出最终解决方案。
Combined with some examples, this thesis studies the establishment of the intersection table from simple to more difficult ones and finally comes to the solution.
这些报表示例包括简单的表格报表、两种样式的分层深入报表、交叉表和几个GDI +图表。
The reporting examples include simple tabular reports, two styles of hierarchical drill-down reports, cross tabs, and several GDI + charts.
交叉表将Salesregion、Productline和Country分别映射到交叉表的行上。
A crosstab projects the Sales region, Product line, and the Country respectively on the rows of the crosstab.
交叉表将Salesregion、Productline和Country分别映射到交叉表的行上。
A crosstab projects the Sales region, Product line, and the Country respectively on the rows of the crosstab.
应用推荐