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 :)
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?