交叉表查询报告未显示所有数据 [英] crosstab query report not showing all data

问题描述

我一直在尝试创建一个报告，该报告可以在数据透视表"种方式.当我意识到数据透视表在印刷中看起来很可怕时，我已经走了很远……

I have been trying to create a report that would give me information in a "Pivot table" kind of way. I was getting pretty far with the pivot table when I realized it looked horrible in print...

为了提供一些背景知识:我必须在过去6个月中每月报告各种测试的结果，我需要找到一种方法来展示不会出现在19页上的数据(我们有大约40个不同的测试，每个测试6个月，这太可怕了.
我重新设计了驱动报告的表格，过去是每条记录都用于测试，每个月都有一列，文件数，根本原因等.每条记录大约有60列；大多数与记录无关.  现在 每个月每个测试1条记录，共7列.制作报告的旧方法是更改​​报告中所有列和框的记录源.这是它的样子:

To give a bit of background: I have to report results for various test on a monthly basis for the prior 6 months, I need to find a way to present the data that would not end up on 19 pages (we have about 40 different tests, 6 months each, it's horrible).
I have re-designed the tables driving the reports, it used to be that each record was for a test and there was a column for each month, #of files, root cause etc. There were about 60 columns for each record; most were not relevant to the record. Now it's 1 record per test per month which is 7 columns. The old way of making the report was to change the record source of all the columns and boxes in the report; this is what it looked like:

我发现交叉表查询给了我我想要的感觉，并且我试图以多种方式创建报告，但我似乎无法弄清楚…….
这是我的问题.创建交叉表查询时，我会获取所需的所有数据((无法找到仅过去6个月的数据，年份的变化或如何每月更改)，但这是另一个问题完全).

I found that the Crosstab Query sort of gives me the feel I want to get and I tried to create reports in so many ways I just can't seem to figure it out....
Here is my issue. When I create a crosstab query I get all the data I need, (can't find how to get the last 6 months only, what happens for the change of year or how to have it change on a monthly basis but that's another question entirely).

查询视图中的交叉表查询结果

Crosstab query result in Query view

但是，当我选择查询并单击报告"时，让Access可以创建报告，它为我提供了这一点:

However when I select the query and click "Report" to let access create the report, it gives me this:

我不知道我在做什么错，但是我实际上是在让访问创建这个，这就是我得到的！

I have no idea what I'm doing wrong but I'm literally letting access create this and that's what I get!

我看了这么多的youtube视频，这么多的google搜索和论坛....我真的很沮丧.

I looked at so many youtube videos, so many google search and forums.... I'm getting really frustrated.

请帮助！

推荐答案

由于此问题与Access的开发有关，建议您将其发布到相应的论坛，在那里您将获得更多帮助和确定的答案.

As this question is more relate to the development of Access, I suggest you post it to the corresponding forum, you will get more help and confirmed answers there.

social.msdn.microsoft.com/Forums/office/zh-CN/home?forum=accessdev

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

最诚挚的问候，

李刘

这篇关于交叉表查询报告未显示所有数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！