Skip to main content
Solved

ot able to display username in report

  • 20 May 2024
  • 3 replies
  • 44 views

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.

3 replies

Userlevel 7
Badge +12

Hi @Harshita 

Please refer Inventory balance report.

To get the display name

use==Report.GetDefUI('RowAccessInfo.DisplayName')

Userlevel 6
Badge +3

Hi @Harshita 

Please refer Inventory balance report.

To get the display name

use==Report.GetDefUI('RowAccessInfo.DisplayName')

Hello @manikantad18 ,
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.

Userlevel 4
Badge +1

Hi @Harshita ,

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.

Reply