Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

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

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
angelnjj
Asked:
angelnjj
  • 2
1 Solution
 
aelliso3Commented:
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
 
angelnjjAuthor Commented:
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
 
angelnjjAuthor Commented:
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

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now