I am creating a calculated data item to populate columns of the cross tab report.
CASE
WHEN ([NUMBER]) = '1' OR () IN ('I', 'F') THEN 'ASIAN'
WHEN ([NUMBER]) = '2' AND ([CODE]) IN ('R') THEN 'WHITE'
WHEN ([NUMBER]) = '3' AND ([CODE]) IN ('C') THEN 'HISPANIC'
ELSE (' OTHERS')
END
let says there is no data in data soruce for "ASIAN", THEN it won't populate column name for asian in result set. But user want to see "ASIAN" as a column in result set . Is it posible to populate this column( ASIAN) in my result set even though there is no data in data base for ASIAN.
[/code][/code]