We are building a report out of SQL for a phone list for our agency. Our SQL server (2008) is linked to our AD server and I am pulling over user information into a view which I then pull into VS to report on. The information in AD for each user contains all of the information for the user such as work address, phone numbers and department. Most users work in only 1 department, but a few work in multiple such as Department 1 & Department 2 OR Dept 1, Dept 2 & Dept 3.
On our report I have each department separated out and each employee listed under the department. The users with multiple departments though do not show up because their department does not match the header, ie; Department 1 doesn't equal Dept 1, Dept 2 & Dept 3.
Management would like me to list the users who work in multiple departments under each department header on the report. Does anyone have some thoughts on how I might accomplish this with the way things are setup? I can post the queries if needed.