Tuesday, 6 August 2013

How to put an SSRS built in variable into SQL variable

How to put an SSRS built in variable into SQL variable

Building a report in SSRS 2008. I need to capture the built-in User!UserId
variable so I can use it in my dataset query. It is part of my report
security. I have tried a couple ways, but niether worked:
DECLARE @currentUser varchar(30) =User!UserID
and inline:
SELECT @retVal = COUNT(*)
FROM MySecurityTable
WHERE ExpirationTime > GETDATE() AND UserName =User!UserId

No comments:

Post a Comment