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
Select [Generic Object]
Where [Folder of Favorites]
And [Folder of Favorites].[Name] Like "#Main Objects with no User#"
And [Creator Name] = &"Current User"
Is it possbile?
Solved! Go to Solution.
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