|
Re: Conditionally show data [message #634373 is a reply to message #634367] |
Thu, 21 October 2010 13:10 |
|
I have about five different ways to do this. I may be missing a couple.
Use a Data element:
if (dataSetRow["SEX"]=="male") {
"X " + dataSetRow["SEX"]
} else {
dataSetRow["SEX"]
}
Use a Dynamic Text element:
if (row["SEX"]=="male") {
"X " + row["SEX"]
} else {
row["SEX"]
}
Use the Map Rule:
In dropdown select "SEX"
Function select: "Equal To"
Value enter: "male" (NOTE: The quotes here are required!)
Display enter: X - male (NOTE: No quotes here!)
Add a Column to your Query:
select mytable.*,
case when sex = 'male' then 'x - male' else sex end showsex
from mytable
(and use showsex in the report design; note this may fail on nulls)
Add a Computed Column to your Data Set:
Add a new column of data type String, call it ShowSex
Use the following formula:
if (row["SEX"]=="male") {
"X " + row["SEX"]
} else {
row["SEX"]
}
|
|
|
|
Powered by
FUDForum. Page generated in 0.03919 seconds