MSSQL Reporting Services - custom report by who the auth'ed user is.

MSSQL Reporting Services - custom report by who the auth'ed user is.

Need pointers about constructing this:

Given multiple authenticated users of Reporting Services.
Custom reports from a table filtered by whoever is logged in.
Schematically:
select * from table where table.user = [the person who is browsing the report]
LVL 1
weinerkAsked:
Who is Participating?
Advertise Here
 
DarthModConnect With a Mentor Commented:
Submitted to PAQ with points refunded (500)

DarthMod
Community Support Moderator
0
 
Ken SelviaRetiredCommented:
You can use;

select * from table where table.user = suser_sname()

suser_sname() will contian the current users DOMAIN\username if you are using Windows Authentication



0
 
weinerkAuthor Commented:
kselvia,
I am not using windows auth.
Moreover probably using the nondescript/anonymous connection from ASP.net application.

0
 
weinerkAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.