I have a report that lists the Primary Owner for devices in the report, but they are displayed as the full LDAP object, for example CN=Dummy User,OU=DemoAccounts,DC=your,DC=domain,DC=com. Because this report is for select end users, they will have a hard time reading the LDAP format. Also, it makes the report hundreds of pages long because the long LDAP text wraps to 2 or even 3 lines in some cases.
I would like the report to simply display the username, preferrably as DOMAIN\User.Name but just plain User.Name would also be acceptible.
Is there any way in the Report Designer do accomplish this? Also, is there any training or documentation specifically for Report Designer?
I would say there is not a way to do this in active reports. Your best bet is to export the report as a csv and import into Excel. You can then write a function to extrapolate the data you want into another column. I usually use this site to spark some ideas http://www.cpearson.com/excel/topic.aspx