You can do this using a cross tab. Look at _genxtab system variable.
or, since you have only twelve months to consider, you could write your report with the months along the top, and then place a report variable in the expression under each month so that the loan and interest will be totaled for each custcode.
>I have an table which contains a record like
>
>custcode,Mthcode,loan,interest,type
>
>I want to print in column way such as
>
> custcode : A0001
> mthcode Jan Feb March April May
> loan 999.99 999.99 999.99 999.99 999.99
> interest 999.99 999.99 999.99 999.99 999.99
> type 999.99 999.99 999.99 999.99 999.99
>
>Can I do it in the fox report...? if no, Is there any other way
>to do it ? Anyone can help me on this. I will appreciate if you can give the code. Sorry for my english. Thanks
--Todd Sherman
-Wake Up! Smell the Coffee!