Crystal Reports 11

[afisher]

Hello! Any help I can get for this dilemma will be vastly appreciated!

I have a property and a photos table. The photos table contains multiple photo records for each property record, each of which have a ranking of 1 - 5. My report doesn't display any fields from the photos table - only property fields - nor does it use the photos table to define criteria. I bring in the pictures from the photos table with a formula in an OLE object based on matching property IDs. The tables are set with a left outer join, property table left. This causes the property records that have multiple photos to show up once for each photo. If I modify the selection criteria to choose records where photo.imagerank = 1, the property records without photos don't show up. I assume it's becuase I've defined a selection criterial based on the photos table, causing any properties without a photo record to be tossed. I need to show all properties meeting my property table criteria while cutting out record duplication caused by there being multiple photos for each property, while displaying the photo from the photos table which is ranked as 1.

Thanks and have a great day!

 

[Pat Hartman]

I don't know how to solve this problem with Crystal but with the Access report designer, the correct technique is to use subreports for many-side tables.