动态交叉表报告仅显示1行数据 [英] Dynamic Crosstab Report only displays 1 row of data
问题描述
我正在尝试创建一个动态交叉表报告，该报告将显示每天由主管分组处理的呼叫数量（我为呼叫中心工作）。
我有一个交叉表查询（Query1），其中包含以下字段：
SPID（主管ID），总计：分组依据，行标题
日期，总计：分组依据，作为列标题
处理的呼叫，总计：总和，作为值
日期，总计：其中，之间的标准[StartDate]和[EndDate] - 这是从表单中获取的，[SelectDate]
当我运行查询（在表单中输入的开始和结束日期）时，它返回正确的数据（42行）。
我根据这篇MS文章创建了一份报告：
http://support.microsoft.com/kb/328320
它在页眉中有9个标题，详细信息部分有9列，报告页脚中有9个总框，所有这些都是按照文章中的建议设置的。
这是报告背后的VBA ：
Hi,
I am trying to create a dynamic crosstab report which will display number of calls handled (I work for a call centre) per day grouped by supervisor.
I have one crosstab query (Query1) which has the following fields:
SPID (supervisor ID), total:group by, as row heading
Date, total:group by, as column heading
Calls handled, total:sum, as value
Date, total:where, criteria between [StartDate] and [EndDate] - this is taken from a form, [SelectDate]
When I run the query (start and end dates entered in the form), it returns the correct data (42 rows).
I have created a report based on this MS article:
http://support.microsoft.com/kb/328320
It has 9 headings in the page header, 9 columns in the detail section and 9 total boxes in the report footer, all set up as suggested in the article.
Here is the VBA behind the report:
推荐答案
Olly，
你的交叉表查询似乎是总计查询，您需要报告的详细信息，制作查询的副本，将其放在设计视图中;然后单击工具栏上的希腊符号（Sigma）关闭并将查询更改为详细的交叉表，并将其用于您的报告。
Olly,
Your crosstab query appears to be a totals query, and you need the details for the report, Make a copy of your query, place it in design view;then click the Greek symbol (Sigma) Off on your toolbar and change your query to a detail crosstab, and use this for your report.
感谢您的回复，但这不起作用。
Sigma在这个查询的设计视图中是灰色的 - 我不知道它是如何帮助的，因为查询正如我想要的那样工作并显示所有的数据 - 它是基于查询的报告，它不显示所有行。
查询给我42行，报告只显示1行！
其他人吗？
Thanks for the reply, however this doesn''t work.
Sigma is greyed out in design view for this query - I don''t see how it would help anyway as the query is working exactly as I want it to and displays all of the data - it''s the report based on the query which is not displaying all of the rows.
Query gives me 42 rows, report is showing only 1!
Anyone else?
感谢您的回复，但这不起作用。
Sigma在这个查询的设计视图中是灰色的 - 我不知道它是如何帮助的，因为查询正如我想要的那样工作并显示所有的数据 - 它是基于查询的报告，它不显示所有行。
查询给我42行，报告只显示1行！
其他人吗？
Thanks for the reply, however this doesn''t work.
Sigma is greyed out in design view for this query - I don''t see how it would help anyway as the query is working exactly as I want it to and displays all of the data - it''s the report based on the query which is not displaying all of the rows.
Query gives me 42 rows, report is showing only 1!
Anyone else?
1.您是否使用相同的查询（未经修改）作为报告的记录来源？
2.您使用的是查询和报告中的分组级别相同吗？
3.您是否已协调查询与报告之间总金额的差异？你能把这种差异与任何东西联系起来吗？
1. Are you using the same exact query (without modification) as the record source of your report?
2. Are you using the same grouping levels in both, the query and the report?
3. Have you reconciled the difference in total amounts between the query and the report? Can you tie that difference to anything?
这篇关于动态交叉表报告仅显示1行数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
