报告页脚会跳过记录 [英] Report Footer skips record

问题描述

我正在尝试生成一份报告，以显示赠款的余额。当授权中有多个项目时，它不起作用。 rptGrantBalance基于qryExpDetail。字段包括ProjectNo / Budget / Expense / Balance


如果只有一个授权我得到了正确的结果但是如果有多个项目，预算只会为第一个项目提取预算费用增加了所有项目的费用。 GroupHeader包括GrantNo和ProjectNo。


如何解决这个问题？


如果需要进一步的信息，请告诉我。谢谢。

I am trying to generate a report to show remaining balance on a grant. It does not work when there are more than one project in a grant. rptGrantBalance is based on qryExpDetail. Fields include ProjectNo / Budget / Expense / Balance

If there is only one grant I get correct result but if there is more than one project, the budget only pulls budget for the first project although the Expense adds expenes for all projects. GroupHeader includes, GrantNo and ProjectNo.

How can I fix this problem?

Let me know if further information is needed. Thanks.

推荐答案

您可能按项目分组，然后授予。您需要按授权分组，然后按项目分组，因为一个授权可以涵盖多个项目。将您的报告放在设计视图中，单击工具栏上的排序/分组图标并相应地进行修复。

You are probably grouping by project, then grant. You need to group by grant, then by project since there can be more than one project covered by one grant. Place your report in design view, click the sorting/grouping icon on tool bar and fix accordingly.

不，我检查了，我已正确排序。当我查看作为此报告来源的查询时 - 一切看起来都没问题。为什么它会这样做呢？这是一个谜。我今天必须解决这个问题而且我不知道怎么做。这也令人沮丧。


感谢您的建议。

No, I checked and I have it sorted correctly. When I looked at the query which is the source of this report - everything looks okay. Why it will do this then? This is such a mystery. I have got to fix this problem today and I don''t know how. This is also frustrating.

Thanks for your suggestion though.

如果您在设计视图中使用图标栏上的排序和分组工具，它覆盖了查询中完成的任何排序或分组，因此查看并回发排序/分组工具中显示的内容。

If you used the sorting and grouping tool on the icon bar in design view, it over-rides any sorting or grouping done in the query, so look and post back what is showing in the sorting/grouping tool.

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