Solved

How do I create a category hierarchy view for tasks

Posted on 2010-11-12
4
1,305 Views
Last Modified: 2012-05-10
Hello Experts,

I have scoured EE and the web for a solution, but am hoping that someone will have an innovative solution to my problem.

Problem:  For tasks with more than one category, I am unable to group each category in a task view.  For example, task1 is assigned Cat1, Cat2, Cat3
I woud like to see the following view:

Cat1
    Cat 2
        Cat 3
             Task1

This link was promising, but I would not be able ot use the categories functionality.

http://www.eggheadcafe.com/software/aspnet/33216722/new-feature-task-hierarchy.aspx

Thanks for the help.  I know someone has an interesting solution!
0
Comment
Question by:dustywork
[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
  • 3
4 Comments
 
LVL 4

Accepted Solution

by:
David Linker earned 500 total points
ID: 34126878
Could you provide somw sample data so we can better understand your requirements.
However, I don't think you can achieve what you want by only using the Categories field to represent all the different levels.  In Task views, each grouping (representing a "level" of the view) must be for a different fied.  What you need to do is either use or create other fields to represent the different levels of your hierarchy.

So say your tasks were first all first Categorised by the Department they are for, then the next Category is the Division within the Dept and the third Category is the Requester of the Task.  The problem is, taks don't by default have these fields.  Rather than create these fields (which is possible), you use other fields that already exist ON THE STANDARD TASK entry form to represent these fields.

I always use the Mileage, Billing Information and Company fields as these can all be entered on the "details" tab within the standard task form.  Decide which of these three fields represent each level of your Category hierarchy.  For example, Company could be Department, Billing Information Division and Mileage as Requester.  Then fill in the appropriate data into each of these three fields for each task.  Finally, create a view that is grouped by each of these three fields in the correct order.

It's not the most elegant solution, but it achieves what you want without any changes to the standard form.
0
 

Author Comment

by:dustywork
ID: 34127312
djlinker,

Thanks for the response.  I had considered such a solution, but am unclear how to establish a drop down for these fields so as to ensure consistency in the naming of these sub-categories.  Any ideas?

Thanks.
0
 

Author Comment

by:dustywork
ID: 34131431
Disregard
0
 

Author Closing Comment

by:dustywork
ID: 34131434
Not exactly the solution I was looking for, but to be fair it is a workable solution.  Thanks.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exchange 2007 Outlook 2010 1 24
Outlook & Word 2016 - Emoji in AutoCorrect screwed up 31 111
Pull Phone Number out of Cell 3 12
MS Excel duplicate input detect. 8 24
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

730 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