访问报告页脚 - =总和（xxxxxx）不会显示在报告视图中 [英] Access Report Footer - =sum(xxxxxx) won't display in Report View

问题描述

Access 2010


我有一个报表页脚，用于汇总详细信息部分中显示的字段。在报表视图中，详细信息项正确显示，但报表页脚中的总和显示为0，除非我单击页脚中的单个控件并显示总计。在打印预览模式下，报告页脚中的总计显示正确。


这必须简单，但我已经在属性框中使用了不同的选项，但显然不是全部。


有人可以给我一条线吗？

解决方案

报告中的总结在过去几次修订中没有太大变化;因此，请从这开始：
在报告中总结


然后，我使用的为数不多的向导之一是用于分组和总和的报告：看看这里：
创建分组或摘要报告 - 我通常使用这些向导创建的报告将它们用作起点，然后根据需要进行修改。


OR


我会用它们作为例子从头开始构建我自己的，因为向导在处理预打印的报表时并不总是有效。


如果您正在处理子报告并希望在主报告中得到总数，那么您将需要：带来总fr om一个子报告回到主要报告--Allen Browne


如果这些都没有让我们知道，我们会更深入地研究这个。

感谢您的回复。我的问题非常简单。根据您的建议，我使用向导创建了一个新报告。我在Detail部分放了一个名为cfooLaneMiles的字段（它是一个Number，Double Type）并执行了Report View。它工作正常，正确列出44作为表中三个记录中该字段的值。


然后我将字段（文本框）从详细信息部分复制到报表页脚在数据选项卡的控制源行中，使用 = sum（___）包围了字段名称。访问括号，使其现在读取

展开 | 选择 < span class =codeDivider> | Wrap | 行号

我很生疏，只是离开我的电脑所以无法测试对于你，但我认为你需要控件名称而不是 Sum（）引用中的字段名称。 详细信息 部分中控件的名称是什么？

Access 2010

I have a Report Footer that sums fields displayed in the Detail section. In Report View, the detail items display correctly but the sums in the Report Footer shows 0 unless I click on the individual control in the Footer and the total will display. In Print Preview mode the totals in the Report Footer display correctly.

This has to be simple, but I''ve exhausted different options in the properties boxes, but obviously not all of them.

Can someone throw me a line?

解决方案

Summing in reports has not changed much since over the past few revisions; thus, please start out with this:
Summing in reports

Then, one of the few wizards I do use is for reports with grouping and sums: take a look here:
Create a grouped or summary report - what I generally do with these wizard created reports is use them as a starting-point and then modify as needed.

OR

I will use them as an example while building my own from scratch as the wizard doesn''t always work when dealing with pre-printed report forms.

If you''re dealing with a subreport and want total in the main report then you''ll need this: Bring the total from a subreport back onto the main report - Allen Browne

If none of these help let us know and we''ll look into this a tad deeper.

Thanks for the response. My problem is VERY simple. Following your advice I created a new report using the Wizard. I put one Field called cfooLaneMiles (which is a Number, Double Type) in the Detail section and did a Report View. It works fine, listing 44 correctly as the value of that field in the three records in the table.

I then copied the field (Text Box) from the Detail section to the Report Footer section and surrounded the Field Name in the Control Source line in the Data Tab with =sum(___). Access brackets the name so it now reads

Expand|Select|Wrap|Line Numbers

I''m very rusty on this and just leaving my PC so can''t test for you, but I think you need the control name rather than the field name in your Sum() reference. What''s the name of your control in the Detail section?

这篇关于访问报告页脚 - =总和（xxxxxx）不会显示在报告视图中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！