| computed column problem [message #200809] |
Tue, 14 November 2006 13:39  |
Eclipse User |
|
|
|
Originally posted by: Carole_l_hargrave.yahoo.ca
I'm trying to build a data set with a computed column, and it just isn't
working....
My Query contains the following columns:
lob_cd
lob_en
lob_fr
I have a report parameter called language_cd - based on a ddlb with the
following values en, fr - en is the default.
My computed column contains the following expression:
if( valueOf(params["language_cd"]) =='en')
row["lob_en"];
else
row["lob_fr"];
I'm always getting the contents of "lob_fr", whether language_cd is
defaulted to fr or en.
Any help would be appreciated
THanks
Carole
|
|
|
| Re: computed column problem [message #200817 is a reply to message #200809] |
Tue, 14 November 2006 13:45  |
| Eclipse User |
|
|
|
Originally posted by: Carole_l_hargrave.yahoo.ca
figured it out.....
if( BirtComp.equalTo(params["language_cd"], 'en'))
row["lob_en"];
else
row["lob_fr"];
Carole Hargrave wrote:
> I'm trying to build a data set with a computed column, and it just isn't
> working....
> My Query contains the following columns:
> lob_cd
> lob_en
> lob_fr
> I have a report parameter called language_cd - based on a ddlb with the
> following values en, fr - en is the default.
> My computed column contains the following expression:
> if( valueOf(params["language_cd"]) =='en')
> row["lob_en"];
> else
> row["lob_fr"];
> I'm always getting the contents of "lob_fr", whether language_cd is
> defaulted to fr or en.
> Any help would be appreciated
> THanks
> Carole
figured it out.....
if( BirtComp.equalTo(params["language_cd"], 'en'))
row["lob_en"];
else
row["lob_fr"];
|
|
|
Powered by
FUDForum. Page generated in 0.04249 seconds
Home