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.
"AMDRIT" <am****@hotmail.com> wrote in message
news:uB**************@tk2msftngp13.phx.gbl...
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