每个过滤记录的打印报告 [英] Print Report for each Filtered Record

问题描述

好的，


我的报告是通过过滤某个人的设备托管收据卡（ECR）打开的。在此报告中有两个子报表，这些子报表链接到报表上的主字段以过滤每个子报表。我可以打开此报告并使用基于表单的参数单独打印。我想要做的是为每个人打印一份报告，或者在我的主表上为每个人的信息打印[SSN]。请参阅以下链接，了解导致此问题的链接。

http://bytes.com/topic /access/answer...subreport-load


这是打开报告的内容：

Ok,

I have a report that is opened up with a filter to a certain person''s Equipment Custody Receipt card(ECR). Within this report are two subreports that are linked to the master field on the report to filter each subreport. I can open this report up and print it individually using a form based parameter. What I want to do is print a report for each person or [SSN] on my master table with each persons info. See the link below for the question leading to this one.

http://bytes.com/topic/access/answer...subreport-load

This is what opens up the report:

展开 | 选择 | Wrap | 行号

推荐答案

如果我理解正确，那么您需要做的就是从 DoCmd.OpenReport中删除 WhereCondition 参数（ ）调用（第一个代码块中的第5行）：

If I understand you correctly then all you need to do is to remove the WhereCondition parameter from your DoCmd.OpenReport() call (Line #5 from your first code block) :

展开 | 选择 | 换行 | 行号

NeoPa，


好​​的，它的作用是打印一份报告，其中一半来自一个社交，其余来自另一个。不确定是什么导致的。


我的目标是为每个人打印单独的报告（在不同的表格上）。


我是我的我觉得这样......


对于[SSN]中的每个SSN，打印出一份单独的报告

NeoPa,

Ok so what this does is it prints one report with half of the data coming from one social and the rest coming from another. Not sure what causes that.

My goal here is to print out separate reports (on different sheets) for each person.

Im my head I see it like this...

For each SSN in [SSN] print out an individual report

过滤（WhereCondition参数）确定报告中应包含哪些数据（记录）。报告如何单独处理每条记录取决于报告的设计。

The filtering (WhereCondition parameter) determines which data (records) should be included in the report. How the report deals with each record individually is down to the report''s design.

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