I'm attempting to setup a web part in SharePoint Designer 2007 that will list team members that are currently on call. I've created the data connection to our oncall database and a dataview web part that has two columns. One column lists
the users ID, and the other lists their oncall priority. This part works great!
USERID | PRIORITY
ID1234 | 1
ID5678 | 2
Now, what i would like to see instead is the user's name instead of their ID.
USERNAME | PRIORITY
John, D | 1
Jane, B | 2
I thought originally i could pull this information from AD using the user profile service from here:
I've created the data connection to the user profile service, but at this point, i'm unsure how to merge the two data connection columns and get the right user data to display.
Any tips? Has anyone done this before?
View Complete Post