Filtering query by logged in user(using macros)

[dipstm]

Hi All,
I have a query(Query1) in report studio. In tht query i have fileds like user_id,user_login_name,etc. I want to filter tht query for the user who is currently logged on.
Is it possible to achieve this ?
Can anyone plz let me knw the exact syntax of doing this.

Thanx in advance.

[masilabalu]

Hi,

Use this....

#sq($account.defaultName)#

thanks,
Balu.

[hung2k9]

Hi,

How can I pass this #sq($account.defaultName)# to be the default selection of a value prompt or a parameter for the prompt?

I have a report which based on a value prompt (which is list of user names) and I want the login user name to be the default selection, so that when he runs the report, it won't ask for any name, just get the current login username and render the report.

I can not put this macro into the default selection field of this value prompt.

Thanks
Hung