Joined: 05 Feb 2010
Online Status: Offline
Posts: 7
Topic: Supress Detail section if Group is Suppressed Posted: 05 Feb 2010 at 12:10pm
Hello,
I am trying to write a report that has conditional suppression based on whether a group header is suppressed. Here is the situation.
The report I am writing has multiple detail sections. If one of the fields (for dollars sold per fiscal period) in any of the detail sections are below $100 I want all the details to show, even if one of the fields in the detail sections is above $100.
Here is what I have tried so far. I have grouped by a customer name and done a conditional suppression in the group header to say if the field for dollars sold > $100 then suppress. This seems to work for suppressing only if all of the fields are over $100.
If there is a way to write a suppression formula in the detail saying if group header suppressed then suppress details I think this will work for what I need. Otherwise I am open to other suggestions for how to re-structure the report to get the same results.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum