Crystal Report continuous if statement? -
i have 12 check boxes in database , want crystal report @ each one.
- if first 1 true want
return word
, - if it's false
return nothing
.
ideally, want show ones true listed side side.
example: if 1, 3, , 5 true show name of field dodge, chevy, nissan.
my statement have
//01 ( if {make.logical_1} = true 'dodge' else'' ); //02 if {make.logical_2} = true 'chevy' else'' ); //03 ( if {make.logical_3} = true 'nissan' else'' );
there no errors returns last if statement, not 1st , 3rd if 1st true well. can leave out else'' same wrong results
it should show dodge nissan
please help!!
i think need use this:
trim((if {make.logical_1} = true 'dodge ' else '') & (if {make.logical_2} = true 'chevy ' else '') & (if {make.logical_3} = true 'nissan ' else ''));
Comments
Post a Comment