Conditional Group Header Suppression 1

[Cort]

Sorry about this fellas but the keyword search seems to be fubared as I'm very certain this has been asked before.

In CR 8.5:

I have a details section which is conditionally suppressed based on the [contract date] = LastFullMonth and then it is grouped by Rep so I can see which contracts he made in the last full month.

Now I have several YTD summaries in the group footer section so I look at all contracts but suppress all but those in the LastFullMonth.

If a rep did not have any new contracts in the LFM I was to suppress the group header for asthetic reasons. So I essentially need a formula that looks something like this:

If [Details section] = {no visible records} then true else false

How would one do that?

 

[Naith]

Try making your header suppression condition:

IsNull(Count({ContractDate})) or
Count({ContractDate}) = 0

That should work.

Naith

 

[Naith]

Sorry. Mind's wandering again...

That should be

IsNull(Count({ContractDate},{Rep})) or
Count({ContractDate},{Rep}) = 0

Naith

 

[Cort]

Thanks Naith for the reply.

I had just slain the beast when you posted. One of my group footer summaries is a count of the new contracts that month so I made the header suppress:

If {new contracts MTD} = 0 then true else false

You formula works as well.

Thanks again.