stuck creating a crosstab report

[Mandeep]

Hi,

i want to create a crosstab report for a financial statement,
datasource is relational, since financial statement needs to be right format (ie,, Accounts should be arranged properly) i am using case statement to pick each account. example (case when ([Account]=10) then ('Sales') end) case when ([Account]=20 ) then ('Direct material')
end etc.

i have a problem here, after arranging extracted items in right order and when i run the report i can see some null values in cognos crosstab. i have attached screen shot for reference.

any help ?

thanks in advance  :)

[blom0344]

The null values are probably those related to an account not 'translated' in your case statement. Did you check what the list of accountnumbers are that the query fetches?