访问:选择多条记录打印报告
我正在尝试设计一个表单,可以在其中选择多个记录,然后单击按钮打开包含所选记录 ID 的报告。
我想也许制作一个连续的表单,其中添加了未绑定的复选框控件,用户可以在其中选择他们想要在报告中显示的适当记录。我不确定稍后如何将其读入 do.cmd OpenReport criteria 属性。 如果有更简单的方法,请告诉我。
I am trying to design a form where I can select multiple records and on button click open the report with the selected records IDs.
I am thinking maybe make a continuous form with an added unbound check box control where the user selects the appropriate records they want to display in the report. I am unsure how to later read this into a do.cmd OpenReport criteria property.
If there is an easier way to this please let me know.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
查看 http://support.microsoft.com/kb/135546 或 http://allenbrowne.com/ser-50.html。您可以采取的另一种方法是创建一个临时表,其中包含记录 ID 的单个字段。使用链接中的代码,使用已选择的记录 ID 填充临时表。然后您需要做的就是更改驱动报表的查询以与临时表进行内部联接。
Take a look at http://support.microsoft.com/kb/135546 or http://allenbrowne.com/ser-50.html. Another approach you could take is create a temporary table that contains a single field for your record ID. Using the code from the links, fill the temporary table with the record IDs that have been selected. Then all you need to do is change the query that drives your report to do an inner join with the temporary table.
您可以在数据集中添加一列,以便他们可以确定要打印哪些行吗?例如,您可以添加 printMe Y/N 列,然后使用该字段值来限制报告的行。
Can you add a column to your dataset where they can determine which rows to print? You could add a printMe Y/N column, for example, and then use that field value to limit the rows for the report.