Mark,

Ok, how about using Word or Excel to build the report and pull the data you need into it?

Renoir

>Thanks Renoir
>
>George Taskers's program looks as if I could use it for capturing the various grid objects as bitmaps and then display those bitmaps in the appropriate position using the report designer.
>
>Of course I would have to use the the class independant of his application and there is only an example of capturing a whole form this way as opposed to just capturing individual objects.
>
>The help seems to indicate that the object must be visible and on top for it to work so it presents the same problems as Steven R Ruhl's program if I want this operation to happen in the background.
>
>Sigh.... I wish VFP was a bit more like Crystal Reports and allowed different reporting zones on a page. Surely this is not too difficult to achieve.
>
>
>
>
>>Mark,
>>
>>George Tasker has an Obj2Bmp utility in the download section that may help. Have not tried it for what your doing, but it may be worth looking at for code at least.
>>
>>Renoir
>>
>>
>>>In order to overcome some of the limitations of the Report designer I did some lateral thinking and decided to use the Form Designer with Steven R Ruhl's form printing program.
>>>
>>>Let me explain my problem.
>>>
>>>I often have to produce reports that must display a variety of small tables all on the one page. Some next to each other, some underneath each other. As we all know VFP does not allow sub reporting zones.
>>>
>>>These tables usually have a fixed number of records so in the past I have created them in a couple of different ways as follows.
>>>
>>>1. Concatanate all the records/fields into a memo field with a chr(13) at the end of each record and place the memo field anywhere I want in the report designer. Nice and easy but need to use fixed width fonts and cant draw lines in between the records and fields
>>>
>>>2. Scatter everything into one large array and place each element in the array where I want it in report designer (can draw lines around things this way, but boy is it tedious)
>>>
>>>3. A variety of strange manipulations with select statements and print when in report designer (UGH!)
>>>
>>>4. Using @SAY :(
>>>
>>>After ruling out external progs such as Crystal Reports ,Excel and Fineprint I decided there must be a way to do this in straight VFP
>>>
>>>Since Steven R Ruhl's form printing/capture class make printing a form easy I decided to create a blank form and drop a few grids on it set all the properties so that the form and grids look like a printout (white backgrounds) and then print out the form.
>>>
>>>This almost worked <g>
>>>Trouble is the class only wants to print the part of the form that is visible in the desktop viewing port. Any part of the form that ends up off the desktop does not get printed.
>>>
>>>I can do the report in 2 halves each of 800 x 600 using capture instead of print and then print the 2 halfs as images in a normal report but since I wanted to turn this technique into a form based class that others can use just by dropping some grids and labels onto, everything starts to look too fiddly.
>>>
>>>Also I had hoped to do all this in the background but it seems the form has to be visible for printing or capture anything to happen (yes I know).
>>>
>>>This could be a very useful feature if someone can get past these limitations since it would be possible to produce some very fancy (though limited) reports using this method. Maybe even something fancier would be possible with reporting style grid classes resizing to fit their number of records (I dont want to go there myself)
>>>
>>>All help gratefully received.
>>>Or maybe just write it for me since I am getting a bit fed up with the idea <g>