Getting Current User

[glewis1636]

I know that to get the current logged in user I can use the dbase function <<&username>>. However, I need to create a report in the GM+Views browser tab that is targeted to the current user. I've tried to put the above function in my url to pass as a parameter to my SQL Reporting Service report, but it doesn't appear to work. Here's the URL I'm passing...

{ 
window.location = [URL unfurl="true"]http://srv/reportserver?%2fProfessional+SQL+Reporting+Services%2fTest+User+Name&rs:Command=Render&UserName=<<&UserName;>>[/URL] 
}

When I access the report, the parameter is blank.

 

[goner]

try removing the semicolon after "UserName"

Doug Castell
Castell Computers

http://www.castellcomputers.com

 

[glewis1636]

Oops, BUSTED!!! That's what I get for asking the same question on different forums...

Paul

"Uhm..."

 

[goner]

yep!

I'm everywhere!

Doug Castell
Castell Computers

http://www.castellcomputers.com

 

[glewis1636]

Like Kilroy 3.0? (is that the right version?)

Paul

"Uhm..."