Report with pictures

[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

 

[Rob Parker]

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

 

[Rolf]

Hello Rob

Thank you for the suggestion, I will look into subreports.

Rolf

 

[Duane Hookom]

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

 

[Rob Parker]

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

 

[Duane Hookom]

To see some really cool stuff that do with this, check out the calendar
reports download at http://www.access.hookom.net/Samples.htm.

 

[Rob Parker]

Very nice!

Rob

To see some really cool stuff that do with this, check out the calendar
reports download at http://www.access.hookom.net/Samples.htm.