i have to make a report like dis





CODE  NAME  JAN  FEB  MARCH  APR  MAY  JUN  JUL  AUG  SEP OCT NOV DIS
 1         KAY      X     X       X         200  300   X      X      X     X      X     X    100



THIS EXAMPLE  OF My REPORT FOR PAYMENT FOR ONE USER IN EVERYMONTH... "x" means the user not paid during that month... i using cross tab already but still it wont happen as i use "if-then-else" to determine the spesific month

if {table.month}= '1' then {table.amnt} else "x" i keep use dis syntax for all 12 month but.. da output will display two boxes first box if the statement is true(which display the amount) second box it display "x".. help me....

hey sastry it wont give da output as what i wanted... it display da same output for dat 12 month.... maybe it doesnt detect on which month  dat da user make a payment... did u have any idea how the logic code where when u ser pay at certain month it display da payment on dat month only... else "0"

hey i already gave u da email.... sorry if i's for u to understand.... really appreciate ur help