Show text in group footer for no data for a particular group

[murfeezlaw]

Hi all, i hope i can explain this right. i'm creating a report that is being ran by a date range(multiple years). i have a group footer showing the totals by year. if for example for the year 2008 there are no losses i'd like to show "No Losses" in the group footer. how can i do this? Any ideas? Any help would be very much appreciated.

[ssanfu]

Maybe a calculated control in the group footer?
Will this work??

=IIF(Sum(Losses)>0,Sum(Losses),"No Losses")

[murfeezlaw]

Maybe a calculated control in the group footer?
Will this work??

=IIF(Sum(Losses)>0,Sum(Losses),"No Losses")

Thank you Steve, I will try that. I think that will only affect the group footer as a whole. I'm grouping by year...for example there could be a policy w 4 terms but only have losses on two of the terms. so in the group footer...i would like to show the summary of the losses for the first term, if there are no losses for the second term show "No Losses", for the third term to show the summary of the losses and for the fourth term to show "No Losses" if there are no losses.