COGNOiSe.com - The IBM Cognos Community

Hello All:

I would like to pass the Report User's name (or just ID) into the Footer of a report. I searched through all the available functions and haven't had much luck looking around. Something like 'ReportAuthor()'.

We are on C10.

Any thoughts?

THANKS,
Kado

Hi Kado,

Please use this function #sq($account.defaultName)#

Thanks,
Anand.

Hi

I tried it like below but it is not showing any user names:

[XXX].[XXXXXX].[DN] = #sq($account.defaultName)#

Hi there,

All you do is add a Data item and enter the expression #sq($account.defaultName)#.  Nothing more just that expression.
Then add the Data Item to the footer by adding a Singleton and then a text item and then converting the text item to a "Data Item Value" and referencing the Data Item created for the username.

Hope this helps
Cheers
Peter

AussiePete!! Awesome! Thank you much!!