Exporting full name when running asset to user relations report

[skuzzi]

When running the built in report Asset to User Relations, it exports the RelationUser field as the username, not the display name of a user. For example when I view an asset, under Relations it will populate the Asset / User field with the users full name, but exporting it instead displays the display name. Is there a way for me to update this report to export the display name instead of their username?

Sorry if it's a noob question, but not very familiar with the reports yet. Thank you!

[Esben_D]

You should be able to edit the report and add the table tblADusers. Then you can select the first name and last name from that table to also be shown in the report.