Want a report that shows all tasks without predecessor relationships

Thanks! It was quite a puzzle to solve! The reference for finding tasks where ''Link'' exists was specifically for Linden. It sounds like they enter link into the name of tasks that in the future, will have a cross project predecessor. The way I understood her question was that some of those tasks where link was in the name, did not have the predecessor set, which is why she needs this report filter.

Heather, Thank you SO much for all of your help. I appreciate it ‚ò∫ -Linden

Great work Heather....another thing I didn't know was possible! Thanks for sharing....

Hi Heather: I have a similar case but I don't know how to make: I have more than 80 projects, and I had set milestone path which include 5 milestones. Let's assume milestone name is "milestone A","milestone B"..."milestone E". Now I want to run a report to list the projects which didn't config any task to "milestone C". Could you please help me to see how to use report->filter to make it? In Reply to Heather Clements:

Sure! name=Link name_Mod=cicontains These two lines work together to find any task name that contains Link predecessors:isCP=true predecessors:isCP_Mod=eq This is referencing any task where the predecessor is cross project ( isCP ) For the corrected one: EXISTS:b:$$EXISTSMOD=NOTEXISTS EXISTS:b:$$OBJCODE=PRED EXISTS:b:successorID=FIELD:ID What we're doing here is a bit more complex, and to be honest, I'm not sure I can explain it in plain english but I'll try. Since predecessor cannot be called upon without a predecessor being entered, we cannot use Predecessor >> isBlank as I originally hoped. Instead, we are looking for all tasks that there is not a successor to predecessor connection. To break it down, it's easiest to look at it in reverse: EXISTS:b:successorID=FIELD:ID Compares the field successorID on the task table to the ID field on the predecessor table. EXISTS:b:$$OBJCODE=PRED Specifies that we're looking at the predecessor table EXISTS:b:$$EXISTSMOD=NOTEXISTS This is calling at the task level to specify that the previous lines ( predecessor to successor relationship ) do not exist.

Hi Ming, I don't think it is possible to filter a collection for items which don't match a certain name. You could do a CONTAINS to show 'false' if the milestone name is not 'Milestone C'. Otherwise, I think it would be best if you filter the results for those which DO contain Milestone C. It will then be apparent (because they're blank) those projects which don't contain Milestone C. The text-mode for this on a Project view/report column is: displayname=Contains Milestone C listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Milestone C",{milestone}.{name})=true,{milestone}.{name},"") valueformat=HTML Hope this helps. Cheers, David

Hi David: Thanks for your advise, your way is exactly same as what I did for now as a workaround. Because I saw Heather points a new syntax "$$EXISTSMOD=NOTEXISTS", so I am wondering how I can use that to implement this purpose. Rds, Ming

Hi Heather, The text below works well thank you for providing: EXISTS:b:$$EXISTSMOD=NOTEXISTS EXISTS:b:$$OBJCODE=PRED EXISTS:b:successorID=FIELD:ID It includes all type of predecessors and not only the cross-project predecessors. Is there a way to show tasks when only the cross-project predecessors are missing? I would like to see All tasks that don't have a cross-project predecessor as predecessor including the ones that contain a predecessor within the same project. Thanks, Yannick Yannick Seifert WebMD Professional