Using current user as parameter to report studio report

[rhollas]

Hello Comnunity users.

I am creating a report template using report studio (HOPEX V1R2), created as  View not Macro.

My objective is to have a report showing each user which objects the should consider cleaning in the "Objects to be cleaned".

This means the report parameter value would differ based on the logged in user. 

The query is quite straight forward, my issue is to pass in the value

Query-code:

Select [Generic Object]
 Where [Folder of Favorites]
   And [Folder of Favorites].[Name] Like "#Main Objects with no User#"
   And [Creator Name]  = &"Current User"

Any sugguestions?

Is it possbile?

Regards

Rune 

[rhollas]

That Solved it.

 Tried CurrentUser (without space) instead of Current User.

That way the report generator catches it from the context, and I did not have to send "CurrentUser" in as report paramater

Thanks!

Rune

[pvandeginste · Accepted solution]

Hi,

Have you tried using "[Creator] = &CurrentUser" instead of "[Creator Name] = &CurrentUser"?

Philippe