Solved

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

Posted on 2004-08-17
5
211 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now