‎20-08-2018 06:34 PM
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
Solved! Go to Solution.
‎23-08-2018 05:38 PM
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
‎20-08-2018 08:06 PM
Hi,
Have you tried using "[Creator] = &CurrentUser" instead of "[Creator Name] = &CurrentUser"?
Philippe