Optimizing a report

[Rogy]

I have a report that shows picture of an article. I managed
to do report like this: (in the group header is the picture
and in the detail band is information (text fields):

-----------------
| |
| Picture |
| |
| |
-----------------
Text 1
Text 2
Text 3
Text 4
…
But I want to look like (the text must be immediately
on the right of the picture):

----------------- Text 1
| | Text 2
| Picture | Text 3
| | Text 4
| | …
-----------------

Is this even possible to do in the VFP8 ??

Thanks

 

[Mike Lewis]

Rogy,

It works for me. Just position the text fields to the right of the picture. No special settings.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[mkrausnick]

Do text1, text2, text3, text4 represent separate fields in the same detail record, or separate detail records?

If there is only one record per picture,then Mike L's solution would work. If there are multiple records per picture, then that solution probably wouldn't work.

If there are multiple detail records per picture, one possibility would be to pre-process the data to combine all the detail records into one big detail record. Then you'd have one detail record per header and you could do what Mike suggested and eliminate the header/footer groups altogether.

Mike Krausnick
Dublin, California

 

[Rogy]

Yes, there are multiple detail records per picture.
I've tried to put picture in the detail band, and in the "Print when" properties of the picture i've set "not" to print repeated values. The picture is show only once but on the right side I have gaps between two text records.

How should I pre-process the data, because one picture can have 3 detail records, another 10 or 45,...?

 

[Mike Lewis]

Rogy,

Maybe you can combine the text text from the multiple records into a memo field, and format it as "stretch with overflow".

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Rogy]

Mike,

I'll try this... i just hoped that there's a sollution with report designer.

Thanks,
Rogy

 

[dbMark]

If you have problems where the band is mysteriously too long, as though the report were reserving enough room for the stretched text and photo sequentially rather than the actual side-by-side placement, then see my post here: thread1252-984387

 

[jimstarr]

Hi Rogy,

I think you can get this to work by creating your detail band tall enough to hold only 1 line of detail. Place the top of the picture in the detail band and let it extend down below the detail band into the lower bands.

Jim

 

[Rogy]

Jim,

Interesting tip, but I can't manage to get it work.
If I use fixed picture, it is displayed only once per page!?!
But if I use my picture from table (the path to the picture is in the table field), nothing is displayed.
I've streched picture from detail band, over the group footer band.

Rogy

 

[jimstarr]

I see what you mean - don't yet see a solution. -Jim