Hi
i have table called
country: fields like
country:
india -100(value)
america-200
westindies-300
pakisthan-400
zimbambe-null
austrila-null
newzeland-null
in this table i am malking a croostable like
crosstable(allcountry,amount,2)
india and americal will remain same .
rest of the countries names or going store in 'allcountry' and
all these country data is going to store in amount. ,,, fine till now
here
zimbambe
austrila
newzeland dont have value it is having null .
when i go for table box with above fields
india
america
allcountry
amount
i can see data in allcountry for only westindies,pakisthan( where i have value) ,(not only data even fields are not coming up in allcountry called zimbambe, austrila ,newzeland)
my req is i want see these fields also in all country(zimbambe, austrila ,newzeland) even if value is null
and it should not display 0 instead of null
i have to see only null ( i dont want see any thing instead of null)