Solved

ot able to display username in report

  • 20 May 2024
  • 3 replies
  • 41 views

Userlevel 6
Badge +3

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.

icon

Best answer by malinthawarnakulasooriya08 22 May 2024, 09:06

View original

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

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


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved