Report with pictures

  • Thread starter Thread starter Rolf
  • Start date Start date
R

Rolf

I am trying to create a report with a picture (attachment field) in
the section header and a list of items in the detaild section.
The challage I have is that I want to show the picture to the left of
the items, not above.
Is there a way to have the picture that is in the section header to
"bleed" into the detail section, or does anyone have other
suggestions?

This is what I am tying to accomplish:

I have grouped on the item.

I can do this:

-------------
! !
! Picture !
! of item !
-------------
Item Size 1
Item Size 2
Item Size 3
Item Size 4
Item Size 5
Item Size 6
Item Size 7
Item Size 8

This is what I want:

------------- Item Size 1
! ! Item Size 2
! Picture ! Item Size 3
! of item ! Item Size 4
------------- Item Size 5
Item Size 6
Item Size 7
Item Size 8




Thank you before hand.

Rolf
 
Hi Rolf,

To answer your particular question: no, there is no way to have a picture in
the section header "bleed" into the details section.

As for suggestions on how to do it, here's one:
Place you picture in the detail section, and add a subreport containing the
Item Size details to the right of it. It won't give you wrap-around as you
show, but it will give you something like:

------------- Item Size 1
! ! Item Size 2
! Picture ! Item Size 3
! of item ! Item Size 4
------------- Item Size 5
Item Size 6
Item Size 7
Item Size 8

HTH,

Rob
 
If there will always be enough detail records to match or exceed the height
of the group header section, you can simply "bleed" using this one line of
code in the On Format event of the section:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
Me.MoveLayout = False
End Sub
 
Wow! What a neat trick. Easier for the OP than my suggestion - I hope
he's seen this.

Thanks, Duane. That's now filed away in my tricks and tips database.

Rob
 
Back
Top