Can you hide group total if group field is blankis null

[bignose2]

Can you hide group total if group field is blank is null

Hi,
I have a report that is mainly listed & sorted by date however I want to group and total by Ex Ref as below.
This is fine but many/most are NOT grouped. i.e. no ExRef so I do not want a total, preferably no group footer at all.

Is there a way to hide this total and ideally not gap when there is NO ExRef

Thanks I/A.

nb When I post this the spaces go so you can't see then columns so i'll try to find a way to make clear.
Basically only two of the total/groups below have a value for "ex ref" but they all get a total & group footer

Date by Day ExRef Account Nominal Total
05 May 2015...............1200 4002 2.68
................................1200 3012 2000.00
................................1200 7901 9.60
................................1200 7901 3.00
................................................2015.28
06 May 2015.......2449..1200 3012 26.77
................................1200 7200 96.00
................................................122.77
08 May 2015...............1200 7001 49.51
................................1200 3022 11.00
................................1200 7002 145.31
................................1200 7004 185.00
................................................390.82
08 May 2015.......2451..1200 7702 706.15
................................1200 7800 800.00
................................1200 7300 200.00
................................................1706.15

 

[bignose2]

Hi,

Answered my own question, to a point.

For the moment I simply use conditional formatting, I must have had a typo before or something but on the group TOTAL as did not seem to respond to checking the value of ExRef.

Now on the group total I simply use isNull([ExRef]) and colour the font to the same as background so there for hidden.

Actually looks OK like this but as I say might be able to VBA hide the whole control or footer (Not sure if you can do that).

 

[arnelgp]

how did you group your report, is it by ExRef or on Expression? If on expression what is the expression?

anyway since i dont know your group expression, just drag a textbox to your group footer. set its property Format->Visible=No, Data->Control source=ExRef.
name your new textbox, TextBoxHidden. click on the group footer band. on its OnFormat and OnPrint events write:

Cancel = (Me.TextBoxHidden & "" = "")