Hi - I am probably missing something very simple and would appreciate any help.

I have a report that shows a series of data for each group (the group header, details and group footer). In the group footer there is a series of values and if these are all 0 then I need that particular group , including the group header, the details and group footer to be supressed. In section expert I have set up a conditional formual that works using the suppress button but it takes out every data set for the whole report if it is true, not just the data set where the condition is met. How do I make it so that it suppresses just the group on that occassion and leaves the other data sets unless they too meet the condition?

Hi DBlank

The values in the group footer are values passed to the report from sub reports so are not part of a group summary function.

If I set the condition to if shared value = 0 then it dletes the group footer from every data set not just the set it aopplies to and I can not think of any way of deg=fining the data set it should apply to.

Any ideas would be a great help

Yes - thats right. Does this help?