How to suppress rows based on footing

[Jaydubyasee]

Hi,

Being a newbie I'm hoping this is a simple question to answer as I cannot find it being addressed elsewhere in the forum so..

In a report how can I suppress the rows in a section if the total of a column is negative ? I can suppress the footer section but not the rows.

 

[Zoltan_Gyimesi]

Hi Jamie,

I can imagine only one solution.

- Make invisible your main section and all of its sub-sections
- Duplicate all of he logic on a Conditinal section, which inherits the Selection an Sequencing from the original section (maybe with appended selections for the current level break)
- call this conditional section from the original footer section, when it is required

That's all for me, sorry.

Regards,

Zoltán

 

[Jaydubyasee]

Thanks Zoltán,

Luckily, because of the time constraints, I have managed to convince the business to accept a different solution.