Suppressing headers that contain no values

[WorkerBeeJ]

I've got a report structured like the following:

Group Header #1: Checklist Header
Group Header #2: Checklist Item
Details: Checklist Item Details and Subreport of Comments

The report takes parameters of: "DisplayCompletedItems" and "DisplayPendingItems". The third type of item is "Outstanding", which is always displayed.

If the user chooses to not to display Completed or Pending items, and there are no Outstanding items in a group, how can I suppress Group Header #1?

What does it mean "put the formula in the section". Won't the value of the formula then display on the report? I don't want the user to see that.

Thanks!
Jennifer

 

[lbass]

Try going to the section expert->group header->suppress->x+2 and entering:

isnull({table.outstandingitem})

-LB

 

[WorkerBeeJ]

Thanks for the quick reply! I am desparate!

It's not just one item I'm checking for null. The following list is one example of one i'm having a hard time with:

Group Foo:
Item is Pending
Item is Pending
Item is Completed
Item is Completed
Item is Pending

Given that there are no items that are "Outstanding" in the group and the user has chosen not to display "Pending" or "Completed" items, the header should not display.

I think I need some sort of a counter within the details section.

 

[lbass]

Please explain what your group field is and also whether "Pending","Completed", and "Outstanding" are instances of the same field (like {table.status}), or whether they are separate fields.

-LB