根据当前用户过滤报告。 [英] Filter the report based on the current user.
问题描述
亲爱的朋友们，
我正在使用A2010版本。我有一个报告显示所有用户的数据，我想要纠正并只显示数据当前用户。
现在为您提供基本信息：
我有2个表：
1）AddUser（EmployeeId {Numeric }，职称，SecurityId ....）
2）任务（ID，EmployeeId，标题，描述，开始日期，截止日期......）
现在，当前用户单击命令按钮时，它会重定向到报告。报告包含像
EmployeeId，EmployeeName，Title，Description，Start Date，截止日期这样的字段。
现在，EmployeeId和EmployeeName通过Row中的组合框查询显示资源。
请注意：EmployeeId和所有细节都是从任务中提取的。表，而EmployeeName是从联系人中提取的。表。
最后，我想根据EmployeeId过滤数据。
我经常冲浪并遇到很多解决方案但是既没有解决我的问题，也没有明白如何做到这一点。
请帮帮我。
期待有用的回复。 ：）
Dear Friends,
I am using A2010 Version.I have a report which is displaying the data of all the users, which I want to rectify and display only the data of the current user.
Now to give you basic info:
I have 2 tables:
1)AddUser(EmployeeId{Numeric},Job Title,SecurityId....)
2)Tasks(ID,EmployeeId,Title,Description,Start Date, Due Date,..)
Now when the current user click on the command button, it redirect to the report. Report contains Fields like
EmployeeId,EmployeeName,Title,Description,Start Date,Due Date.
Now EmployeeId and EmployeeName is displayed through the combobox query in Row Source.
Please note: EmployeeId and all the details are fetched from "Tasks" table, while EmployeeName is fetched from "Contacts" table.
At last , I want to filter the data based on the EmployeeId.
I surfed a lot and came across so many solutions but neither are solving my problem, or I am not getting a clear idea how to do that.
Please help me out.
Looking forward for helpful reply. :)
推荐答案
确切的答案取决于您如何存储当前登录的员工。但是，总体思路如下：
The exact answer would depend on how you are storing the currently logged in employee. However, the general idea would be something like the following:
Hi Seth，
谢谢你的回复。
我试过了。但报告中没有显示任何记录。
Hi Seth,
Thanks for your reply.
I have tried it. But the report is not displaying any records in it.
Seth的方法是做你所询问的最简单，最简单的方法，所以如果它不适合你，您可能希望发布您正在使用的代码，我们可以帮助您使用它。
Seth''s approach is the most straightforward and easiest way of doing what you are asking about, so if it is not working for you, you may want to post the code you are using and we can help you get it working.
这篇关于根据当前用户过滤报告。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
