By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,527 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,527 IT Pros & Developers. It's quick & easy.

Crystal Reports: Conditional Suppression

P: n/a
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
Nov 7 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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

Nov 7 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.