To print a wide report, here is another way. Use a memo field and a fixed font.

i.e.
I needed to allow users print some data based on months, however I wouldn't know how many months until user chose the date range.

Tis is what I did.
Created a report cursor with two memo fields. The first was the header
i.e. Jan Feb Mar....
The second held the data
i.e. 1.23 2.45 4.32...

Now adding spaces etc and formating the output in a fixed font, i.e. Courier, the title lined up and the data lined up.

A bit of a pian, but it worked. No need for automation etc. (I learned this when I was automating msGraph years ago.)

HTH,
Mike






>>Pretty much agree with your points. I had no doubt about being able to use Excel automation for this report -- the decision to not use Excel automation was based on the fact that there was no guarantee that Excel would be installed on all workstations at which the report might be run and asking (or as seen from the enduser's perspective -- forcing) the user to purchase Excel wasn't an option.
>
>Right.
>
>With Visual FoxPro reports, if you need a variable amount of columns, you basically have to have the largest amount of columns you would possibly need, and use conditional printing for most columns.
>
>If the report is too wide to fit in the width of the paper, it is possible to have separate reports for the left and the right parts, for example.