cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Using current user as parameter to report studio report

rhollas
Super Contributor

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 

2 Replies

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
Honored Contributor

Hi,

 

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

 

Philippe