In the crosstab report I am using one of the expression as
if([Type]= 'M') then('Mag zines.') else('book')
so it shows the count of each for a store.. But if that store does not have magzines for a time period(like Quarter) then it should display '0' but it is not pulling that column at all.
It is just pulling book and displaying its numbers.