If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to populate columns in crosstab reports with calculated column

Started by ramjos, 15 Oct 2009 10:22:41 AM

Previous topic - Next topic

ramjos

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]