Solved

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

Posted on 2004-08-17
5
219 Views
Last Modified: 2008-02-26
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]
0
Comment
Question by:weinerk
  • 2
5 Comments
 
LVL 12

Expert Comment

by:kselvia
ID: 11826232
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
 
LVL 1

Author Comment

by:weinerk
ID: 11826642
kselvia,
I am not using windows auth.
Moreover probably using the nondescript/anonymous connection from ASP.net application.

0
 
LVL 1

Author Comment

by:weinerk
ID: 11826644
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 12142684
Submitted to PAQ with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question