cancel
Showing results for 
Search instead for 
Did you mean: 

Using current user as parameter to report studio report

Solved
Highlighted
Occasional Contributor

Using current user as parameter to report studio report

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 

Tags (2)
2 Replies
Frequent Contributor

Re: Using current user as parameter to report studio report

Hi,

 

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

 

Philippe

Occasional Contributor

Re: Using current user as parameter to report studio report

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