>>Well - if you always have 12 columns, you could also write a loop to transfer the data to a temporary table, and then use a regular report. The problem you might encounter is a variable number of columns. This is easier with Excel automation, but you might also include the maximum number of columns foreseen, and use conditional printing.
>>
>>HTH, Hilmar.
>
>Looks like this is the way I'll have to go. The 12 columns are all there will be.
>
>Thanks again
>Mike
Yes, well - I don't know of an easy, built-in way, in VFP, to transpose columns and rows, so a loop - or several nested loops - seems to be the logical way to go.
I forgot to mention that Excel has one more advantage - for printing, the output can easily be split horizontally. This may be benefitial if you have many columns.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
