Solved

Pass user's office from active directory 'general' tab to report parameter in report services

Posted on 2010-08-24
4
328 Views
Last Modified: 2012-05-10
Hello All,

We would like to implement a modicum of security in the report manager so that users of a particular report are not able to run the report for different departments.  This would be alternative to deploying different versions of the report.  We would like to pass information from their active directory profile ('office') to the report itself and have that determine a parameter's values.

For example.  We have several reports that contain a single parameter drop down for office...that parameter has all offices listed. Using desired method, we would have the office they belong to (determined via active directory) passed to the selection criteria parameter automatically -  or could also be used as thefilter data.  

Is this possible? If possible, are there other fields available besides office - are all fields available from their AD profile?  If not possible, are there other methods for accomplishing my goal? Any nudge in the right direction would be appreciated.  I've googled around, but not found the right solution.

Let me know if you need more details.
0
Comment
Question by:angelnjj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
aelliso3 earned 500 total points
ID: 33523952
Are you currently querying AD in your report, if so, then you can return the current user to a hidden parameter. That hidden parameter can use the value for other fields in the stored procedure.
This link will give you some of the fields that are available:
http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html 
0
 
LVL 1

Author Comment

by:angelnjj
ID: 33524672
I'm not currently querying AD in my report - didn't know/don't know how to do that...will review article today and work through it...if I have questions will post again, if not will reward!  Gimme until the morning.  Thanks...
0
 
LVL 1

Author Closing Comment

by:angelnjj
ID: 33532421
Followed link method, which didn't quite work, but was then better able to form a google search - and found exactly what I was looking for.  Thanks for pointing me in the right direction.
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

This article shows the method of using the Resultant Set of Policy Tool to locate Group Policy that applies a particular setting.
Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

734 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