报告帮助 [英] Report Help

问题描述

我需要一个报告来从2个查询中提取数据（qryProduction和qryAggregate。我已经开始报告，但只有qryProduction的数据，直到我看到如何组合2个查询。我还需要它来显示数据打开的表单并非所有记录。谢谢

I need a report to pull data from 2 queries (qryProduction and qryAggregate. Ive started a report but only has data from qryProduction until I see how to combine the 2 queries. I need it to also to only show the data for the form that is open not all records. Thanks

附加文件

Database.zip （303.1 KB，4 views）

Attached Files

Database.zip (303.1 KB, 4 views)

推荐答案

我们会很快处理这个问题，因为这是一个设计要求而不是技术问题而且我们在这里做的并不是真的。


如果你是来自多个来源的ed数据然后您可以构建一个既包含作为源又包含（非常重要）定义它们之间关系的查询。然后，您的报告将使用此新查询作为 RecordSource 。


至于仅选择当前记录，有一个名为<$的参数c $ c> WhereCriteria 过程 DoCmd.OpenReport（），它允许您指定在报告时应用于报告的过滤打开。您的代码（可能从表单中运行）会将过滤设置为仅包含表单的当前记录。注意 FilterName 参数。这是其他的东西，并且已经知道会混淆不少。


另一个参数， OpenArgs ，也可供您使用将您可能需要的任何其他内容传递到报告中。并不总是需要你的任务，但有时是有帮助的。


NB。作为一般规则，请仅在您的工作被要求时发布。很多成员似乎认为：

We''ll deal with this quickly because that''s a design request rather than a technical question and that''s not really what we do here.

If you need data from multiple sources then you can build a query that incorporates both as sources and also (very importantly) defines the relationship between them. Your Report would then use this new query as RecordSource.

As for selecting just the current record there is a parameter called WhereCriteria of the procedure DoCmd.OpenReport() which allows you to specify filtering to be applied to the report when it''s opened. Your code, presumably run from the Form, would set the filtering to include just the current record of the Form. Be careful of the FilterName parameter. This is something else and has been known to confuse not a few.

Another parameter, OpenArgs, is also available for you to pass into the Report anything else you may need. Not always needed for your task but is sometimes helpful.

NB. Please, as a general rule, only ever post your work if it''s been requested. Far too many members seem to be of the opinion that :

1. 这里的专家没有比花时间深入调查问题更好的了，实际上，海报的责任是首先明确表达。
2. 每个人都使用相同版本的Access，因此他们拥有一个甚至可以打开工作的系统。通常表示甚至没有发布他们的数据库存储在哪个版本。

你可以相信，如果和时间（因为它确实发生）任何个别专家都准备好看进入你的实际数据库然后他们会明确要求复制。

You can trust that if and when (because it does happen) any individual expert feels prepared to look into your actual database for you then they will be clear about requesting a copy.

这很好，我更容易看到一切都是得出结论，但我的行工作是不同的，往往需要大局，所以它只是习惯。

That''s fine, its easier for me to see what everything is to have a conclusion but my line of work is different and often requires the big picture so its just habit.

NeoPa：

至于仅选择当前记录，有一个名为 WhereCriteria 的参数 DoCmd.OpenReport（）允许您指定在打开报告时应用于报告的过滤。您的代码（可能从表单中运行）会将过滤设置为仅包含表单的当前记录。

NeoPa:
As for selecting just the current record there is a parameter called WhereCriteria of the procedure DoCmd.OpenReport() which allows you to specify filtering to be applied to the report when it''s opened. Your code, presumably run from the Form, would set the filtering to include just the current record of the Form.

目前报告使用宏从我的表单打开。我将DoCmd.OpenReport（）添加到where条件，但它现在有{ 解释 } 感叹号标记。

Currently the report opens from my form using a macro. I added DoCmd.OpenReport() to the where condition but it has {a explanation} an exclamation mark now.

展开 | 选择 | Wrap | 行号

这篇关于报告帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！