Need to create a report that will pull all programs with atleast one project NOT associated with a certain template.

Example

Program A - can have multiple projects associated -- each projects can have associated templates .

But I need to report only on those programs where atleast one associated project doesn't have the that template added.

Thanks for your help.