Cross tab Doubts

HPP

HI williams,

I have a scenario in my cross tab like, i will get an output from an stored procedure for a particular column say 'a',
'a' may have a value like
1. either null
2. or NA which means not applicable
3. some value in it.
In my cross tab if i get null i should show it as 0
if i get some value i should show it as 1
and if i get NA then i should show it as 2.
This is working fine for 1st and 3 rd case.
the problem is with 2nd case when 'a''s value is NA.
Since in the summary field am giving it as measure of sum. BIRT is takng the value of NA also as sum(1) = some value init. so for both 2nd and 3rd am geting 1 only.. but for 3rd i should get 2. Is there any solution for this.Pls help.

thanks in advance

HPP

hi williams,
I somehow found the soultion by making some logic in sp.
And in the birt with the help ur other reply in the same related topic .
thanks. Atleast now am able to solve some problems in BIRT