Suppress empty group footer in subreport

[jaguar00]

Happy Friday everyone!

(Using CR 8.5)I have a report with a subreport. In the subreport I have a group which groups together addresses, phone numbers, etc. for each related group. Currently, it will only print the groups if there is data there which is good. But if all groups are empty, not only does it not print the header information, but it still prints the commas and the word County which I put between all the fields and it looks like this:

,,, County

If the entire group is null, I would like for the report to state "NOT KNOWN". I've tried several different ways to accomplish this but can't find a solution.

Any help is greatly appreciated.

 

[tektipdjango]

For the group header try to create a 'super group' with a formula like =1 and put your header in it and suppress it onfirstrecord. So it will print if there are no record.
for the other problem can you put the phone numbers... in a formula and in this formula write something like
if result=',,, County' then 'NO results'
Or maybe you can hide the formula if it has this value.
I can't test it as I have CR9

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​

 

[lbass]

Assuming that ",,, County" is the content of a text box or formula left when other fields in the text box or formula are null, you could right click on the formula/text box->format field->suppress->x+2 and enter:

isnull({table.address}) and
isnull({table.city}) and
isnull({table.phone}) //etc.

Create a second formula:

if isnull({table.address}) and
isnull({table.city}) and
isnull({table.phone}) then //etc.
"Not Known"

Place this in the same header.

-LB