Crystal Reports: Conditional Suppression

  • Thread starter Thread starter AMDRIT
  • Start date Start date
A

AMDRIT

The stuff below seems to work, when I am applying the logic for suppression.
However, it doesn't work when suppressing row data. Any Ideas?

Basically, if there is only one row of data, I need to suppress a caption
and it corresponding data field.


Create a formula field
@RowCount Formula Field

shared numbervar RowCount;
RowCount := RowCount +1

Add a condition to the object to suppress
Suppress Condition
{@RowCount}<2;



TIA
 
I figured it out.

apply the same logic for the captions, for the field data

onlastrecord and recordnumber = 1;

because I would like the columns to "shift" to the left, I have two copies
of the caption and field on the report.

to suppress the "shifted" copy of the data field, I use XOR

onlastrecord xor recordnumber=1;

both recordnumber and onlastrecord are built in functions.

Hope that helps anyone.
 
Back
Top