Conditional Suppressing a column based on CECURRENTUSERNAME 1

[mynameant]

Is it possible to suppress a column value based on the user who logged in? I am using CR XI rel 2 and trying to use the following IF Statement in conditional suppress formula:

if CECURRENTUSERNAME="xxx" then true else false;

but Crystal doesn't like it. it rejects the usage of CECURRENTUSERNAME as a part of IF Statement.
Any ideas?

Thanks

 

[Turkbear]

Hi,
by 'Logged In' do you mean the report is running from CR Server or Enterprise, not on a PC?

The CECURRENTUSERNAME is only available when using Enterprise ( CE is Crystal Enterprise).

If it is in Enterprise, to supress a field the x*2 formula is just

CECURRENTUSERNAME="xxx"

not an If..Then..Else statement



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mynameant]

That is perfect. I was thinking I have to say IF x="y" then true else false. But that's not needed. It's working as expected now. Thanks

 

[Turkbear]

Hi,
Been there..done that.

The other thing that confuses many users ( me included) is that the formula needs to evaluate to TRUE for a suppression for take place, so YES means NO



To Paraphrase:"The Help you get is proportional to the Help you give.."