extra line in group footer area

[J Miller]

I have a report grouping on a field. When the field contains one specific
value I would like to print an extra blank line, for all other values it
doesn't need to print the extra blank line. I have played around with the
'can grow' & 'can shrink' properties, and tried to make it happen in the
'Groupfooter_format' section by adjusting the height, but can't get it. Any
help would be appreciated.

Many Thanks.

Jeff

a
a
a
total for a
b
b
total for b
<-extra blank line when the value is 'b'
c
c
c
total for c
d
d
total for d

 

[Marshall Barton]

I have a report grouping on a field. When the field contains one specific
value I would like to print an extra blank line, for all other values it
doesn't need to print the extra blank line. I have played around with the
'can grow' & 'can shrink' properties, and tried to make it happen in the
'Groupfooter_format' section by adjusting the height, but can't get it. Any
help would be appreciated.

a
a
a
total for a
b
b
total for b
<-extra blank line when the value is 'b'
c
c
c
total for c
d
d
total for d

Add another text box to the group footer, set its and the
footer section's CanGrow to Yes.

Then set the text box's expression to:
=IIf(groupfield = "B", Chr(13) & Chr(10), Null)