hi Tamil,
The table has got more fields, but I have selected few fields which are required. And the data is saved into these table through portals. I am trying to create a crosstab ( matrix) report using Crystal Report 10 . So it lists, the leaf WBS with their data for each cost category for all the periods ( so if for a perticular wbs , and period there is no amount then it lists 0 (zero) . And then the roll up for the parents . So basically the report should look like this ( with the hirarchy of wbs like root, then parent then child and leaf).

PERIOD_YEAR ----------------------------->
WBS NUMBER , COST_CATEGORY
|| || amount---------->
|| || |
|| || |
\/ \/ \/