Crosstab with zero or null values

[izreena]

 Hi everyone,

 

I realized my crosstab does not print out the columns with zero values in it.

I wanted something to display like this, but the Red column wont show up at all. So how do I make crosstab display all columns regardless of their values?

Code:

    Num  Transaction         Blue      Red       Total    1   | Bank Wire     |     0   |    0    |     0    2   | Credit Card   |     2   |    0    |     2    3   | Cheque        |     1   |    0    |     1    ------------------------------------------------    Total     Bank Wire & Credit  |     2   |    0    |     3    ------------------------------------------------    Total All           |     3   |    0    |     3     --------------------------xx-----------------------    --------------------------xx-----------------------

[marcoslimagon]

I've posted something similar.. check if this helps you

http://blog.marcoslimagon.com.br/2013/03/jasper-crosstab-nullable-field/