Role-Based Dashboard Page in WSS3.0

I want to create a role based landing page where the team member would see his documents, issues, risks and tasks, but when the team lead visits the page he/she should see all items assigned to him and his team.

I will be creating a list which will have the mapping, the columns in the list will be resource, role and supervisor. Currently I am thinking of using the supervisor column as another role column so that more than one person assigned the role can still view the details.

User-Role List:
Resource |Role | Supervisor
Res1 |QA Lead| PM
Res2 |Tester | QA Lead
Res3 |Trng Lead | PM
Res4 |Trainer| Trng Lead

I don't want to create separate landing pages for each team lead, but one page which for different leads.

Page layout:
The page will have 4 webparts:
1. Documents
2. Issues
3. Risk
4. Project Tasks

Use case:

1. When PM visits the page, all items are displayed (QA and
2. When  QA lead visits the page, the items assigned to tester and QA lead should appear on the page
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ted BouskillSenior Software DeveloperCommented:
Possible but a challenge.  If you want to do it based on an organization hierarchy then it will likely have to be done with code writing custom web parts.  The Data View Web Part which can be created using the now free Sharepoint Designer 2007 but might not be up to the task of determining inheritance (finding the testers assigned to a lead) unless you create Audiences that match AD security groups.  However, that would be difficult to manage if you have a lot of teams.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.