Suppress to display is value is greater then 0

[former_member1107312]

Hello,

Please forgive me if someone else has ask this question.  I tried to search for an answer and did not find a solution.

I have a report that made up from 5 subreport to get my main report.  I have values (sum of a weight from an object that I need from a sql database)  which all works as I like.  My question is I would like Report Footer b (I have suppressed) to be unhidden if my @TotalWeight is a value greater then 0.  If my @TotalWeight is less then 0 then I want Report Footer c to be unhidden.  Now I just learning Crystals Report (I am using version 14.1.1.1036).  There might an easier way to get my results that I need and I am open to all suggestions the you might have.  Thank you.

[Former Member · Accepted solution]

Hi Gerald,

To suppress the Report Footer b when @TotalWeight > 0

1. Go to Section Expert..
2. Select Report Footer section
3. Select Formula Editor for Suppress(No drill Down) and add the condition as @TotalWeight < 0

To suppress the Report Footer c when @TotalWeight < 0

change the Suppression condition to @TotalWeight > 0

Thanks,

Nrupal

[former_member1107312 · Accepted solution]

That worked perfectly.  Thank you for the quick reply.