Hello all,
I have been trying to build out a report and i have the User ID set as parameter . So if any user ID is selected under this parameter and the report is run, the full name of the selected User ID isn’t getting displayed. Kindly let me know what is it that i am doing incorrect.
Thanks in advance.
Best answer by malinthawarnakulasooriya08
Hi
As per my understanding, in your report's table joining the Parent Table should be the 'Users Table'. That’s the reason for not having data for the report from the Users table in your report. Please check the below screenshots.
As an additional point, without joining the Users table AuditHistory table can be filtered by the given UserId. For further reference the herewith i’m attaching the tried two test reports.
+15Hi
Please refer Inventory balance report.
To get the display name
use==Report.GetDefUI('RowAccessInfo.DisplayName')
Hi
Please refer Inventory balance report.
To get the display name
use==Report.GetDefUI('RowAccessInfo.DisplayName')
Hello
Thanks for your prompt reply, but I assume I need to be more specific.
I have a parameter add for User ID in the report as shown below:
So if a UserA is selected under the parameter the report then should display the complete name of this selected UserA.
Hi
As per my understanding, in your report's table joining the Parent Table should be the 'Users Table'. That’s the reason for not having data for the report from the Users table in your report. Please check the below screenshots.
As an additional point, without joining the Users table AuditHistory table can be filtered by the given UserId. For further reference the herewith i’m attaching the tried two test reports.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
