Hi, SELECT sum(IIF(month=1,salest,0)) as Jan, ; sum(IIF(month=2,salest,0)) as Feb, ; sum(IIF(month=3,salest,0)) as Mar, ; sum(IIF(month=4,salest,0)) as Apr, ; sum(IIF(month=5,salest,0)) as May, ; sum(IIF(month=6,salest,0)) as Jun, ; sum(IIF(month=7,salest,0)) as Jul, ; sum(IIF(month=8,salest,0)) as Aug, ; sum(IIF(month=9,salest,0)) as Sep, ; sum(IIF(month=10,salest,0)) as Oct, ; sum(IIF(month=11,salest,0)) as Nov, ; sum(IIF(month=12,salest,0)) as Dec, ; salest ,; from table ; where year=1997 , ; group by province For totals use the report witer fields with sum calculation | >>I have a table that contains month, year, province, and sales total. The | enduser requests the layout of the summary report with months across the | column and the province on each row. Summation totals for entire year at | the bottom of each column and summation totals of each month at the end of | each row. It's very easy to do if it is done in Excel/Lotus. I am having | trouble building this kind of report in the VFP report generator.