Printing the Username on a Report
If you need to print the Username of the person who ran an ARM (Analytical Report Manager) financial report writer report, you can use the following formula:
I recommend putting it in the Column Set header and right justifying it like this:
So it prints on the report like this:
Haha, naw, I just finally got around to knocking out some of the items that have been on my list for a while. Still a lot more on my list that I haven't been able to get to yet.
Regarding report page footer, that would be awesome if there was a way to do that. Do you know of a way? As far as I can tell, you can only do a report page header.
Is there a way to print the "Real Name" of the user? We are using federated authentication and the email address does not look as nice, nor is it as short. I have used the following formula to get the username without the domain name but I still would prefer the actual name.
='Printed By: ' + Left(CStr(Report.GetDefUI('RowAccessInfo.DisplayName')), Instr(CStr(Report.GetDefUI('RowAccessInfo.DisplayName')), '@'))
Thanks for the reply. When I use 'Username', I get the same results as 'DisplayName' (the full email address). On a whim, I decided to try other potential fields based on the Inspect Element on the user screens but all of them resulted in an error that prevented the entire string from displaying. I tried FullName, LastName and AcctName (again with no results).
Is there a resource that documents all of the objects that can be used in the ARM reports? I have looked in the training guides, user guides and googled Report.GetDefUI to see if I could find any documents to no avail. I am reusing items that I have found in other reports but it would be nice to have a complete list. Thanks again.