Displaying multiple images

rbuser

I have two tables - Properties and Images (left join). There can be any
number of images for each property. Using the end user environment my
problem is that I will have three property records that are the same if
there are three images. I want to be able to display for each property some
details and the three images. How do I do this.

Ken

nardmoseley

- use the Query Designer to order the query by property id
- for the report layout, add a group and place the property information in
the group header
- place the image information in the detail band

The other option is to create two queries, one for Properties and one for
Images and then link them by dragging the property id from the detail to the
master. In the report layout, connect the report to the Property query and
add a subreport connected to the Image query.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Nard,

Thanks for that. I am using the latter method but I can only get it to work
correctly if I sort by the reference in 7.03. Works fine sorting by
something else in 10.03. Do you know if this works in 7.04?

Ken

nardmoseley

You can try RB 7.04, but I checked the release notes and it only mentions
improvements for linking on null values and lnking LargeInt fied type. (If
you are using RB 7.x, I do recommend updating to RB 7.04 as it contained an
important fix for image rendering).

RB 9 added linking support for GUID field types.

RB 10.02 included improvements to handle more complex linking cases - this
is more likely the version that applies to this issue. . When the master is
sorted, the detail linking SQL is sorted by the same fields, plus the
linking field. This can make the linking SQL much more complex.




--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com