Retrieve the user's User-Group / User-Role as a Session Parameter

[bi4business]

Hi All,

Is there a way (session Parameter?) to retrieve the current user UserGroup / UserRole within a Report of a user ?

I would like to grap the usergroup(s) / Userrole(s) the current user is part of but can't find how to grap that.
Found some post with SQL statements at the Content-Store, but I don't like using the Content-Store for that.

Has anybody done this before within a Report ?

Kind Regards,

[MFGF]

Hi All,

Is there a way (session Parameter?) to retrieve the current user UserGroup / UserRole within a Report of a user ?

I would like to grap the usergroup(s) / Userrole(s) the current user is part of but can't find how to grap that.
Found some post with SQL statements at the Content-Store, but I don't like using the Content-Store for that.

Has anybody done this before within a Report ?

Kind Regards,

Hi,

Often a user will belong to multiple groups and roles. The CSVIdentityNameList() macro function returns all the groups and roles a user belongs to (along with the user's identity).

Cheers!

MF.

[bi4business]

Hi MF,

Thanks a lot, I didn't know about this macro function.
You are never to old to learn  ;D  ;D

Exactly what I needed, thanks again.

Kind Regards,