将复选框链接到另一个表中存储的条件
我需要为学生创建报告,其中将指定他们尚未完成的任务。该报告当前显示每个任务的复选框以及完整的标准列表,无论他们是否已完成该任务。如果任务尚未完成,那么我希望显示存储在另一个表中的该任务的条件。同样,如果已经完成,我不希望显示标准。
玩过 if、组合框和查找,但大脑现在已经冻结了。
I need to create reports for students, which will specify which tasks they have not yet completed. The report currently shows check boxes for each task and the full list of criteria whether they have completed the task or not. If the task has not been done, then I want the criteria for that task which is stored in another table to show. Likewise, if it has been done, I would not want the criteria to show.
Have played with if, combo boxes and lookups, but brain freeze has now set in.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我不确定我完全理解这个问题,也不清楚数据结构是什么,但在我看来,您可以使用子报表并使用详细视图的 OnFormat 事件来隐藏/显示子报表。
也就是说,在详细信息的 OnFormat 事件中:
想法是创建一个报表,始终在每个任务的子报表中显示条件,然后添加此代码以在不需要时隐藏它。
但是,当然,我可能对你的数据结构了解不够,所以这可能行不通。
I'm not sure I completely understand the question, and it's not clear what the data structure is, but it seems to me that you could a subreport and use the Detail view's OnFormat event to hide/reveal the subreport.
That is, in the OnFormat event of the Detail:
The idea is to create a report that displays the criteria in a subreport for every task all the time, and then add this code to hide it when it's not needed.
But, of course, I may not understand enough about your data structure, so this might not work.