How to replace null value with zeros in cross-tab query

[mrchonginhk]

I have this cross tab query

Name/Month/Score
==============
MrA/Jan/90
MrB/Feb/80

If my cross tab query is Name as row, Month as ColumnHeader, Score as Value, then output becomes:-

Name/Jan/Feb
==========
MrA/90/[ ]
MrB/[ ]/90

I want [ ] to be zero 0, instead of nothing.
How to do this ?
Thanks

 

[mrchonginhk]

Hi I found the solution by myself. I post here to share with someone who may need this in future. Thanks

http://support.microsoft.com/kb/132140