Reply to comment

Hi sir ,thanks for the reply first answer which you gave has worked...my second doubt was if we have a task1 in row andtask1...n in column and if its having no value then i should get null/0 but that column is not visible at all what to do...for betteer understanding of my doubt i am trying to show it as table
task1 task2 task3 task4 task5 task6 total
task1 5(somevalue) 6 7 0 0 10 x value
task2 0 0 0 0 0 0 x value
task3 0 0 0 0 0 0 x value
task4 1 2 4 0 0 6 x value
task5 1 2 3 0 0 7 x value
task6 1 1 1 0 0 8 x value
total x x x x x x x value

if this is a cross tab,as u can see that columns task4 and task5 and rows task2 and task3 are having null values so in ireports its completely deleting or not showing that but i want it to display as i shown in the example not considering whether row/column is null...please help waiting for reply...thanks in advance...