Only show if check list is complete

[Fadius]

I have a report grouped by Person, then by checklist type. I only want to see data on providers and checklists which have unchecked items. (have the unchecked items display)

So if John Doe has no unchecked items on any of his assigned checklists, John Doe should not show up.

If John Doe has only one checklist with unchecked items, John Doe will show up with only that checklist along with the items.

I can get all the people to show, with all there checklists under them and I can get it so only the items that are unchecked display, but how do I accomplish what I trying to do?

It may be that is the Friday before the Holiday weekend, but for some reason I cannot picture how to do this.

 

[lbass]

What value do they have if they are "unchecked"? Are they null or blank? If so, I think you just need a record selection formula like this:

(
isnull({table.checkedornot}) or
{table.checkedornot} = ""
)

-LB

 

[Fadius]

It is a check box, true or false. If all items are true, then I dont want the person to show or the checklist or both if every checklist has all items on a checlists marked as true.

 

[lbass]

Then:

{table.checkbox} = false

-LB