>>One option is to use Excel automation, to insert values into Excel. This will give you an "unlimited" (well, up to 256, at any rate) number of columns.
>>
>>Hilmar.
>
>Hi Hilmar,
>
>Thanks for the tip. I hadn't thought about Excel. They also want that format as well. If I can't figure out how to do the report in column format. I'll re-arrange the cursor to be 12 columns & 8 rows. I'd just thought I could avoid that step.
>
>Thanks
>Mike
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.
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)