Stop Report repeating for each record in subreport

[ZenDiagram]

Hello.

I was hoping someone could go into this sample database and help me with a few things.

Purpose of the database:
to hold data about owner's and their properties. (one to many)
That data's sole purpose is to be generated onto a yearly report that goes to each owner.
The report is effectively a "application" on which the owner's review the data of their properties, write any changes for the new year, and send it back to my office. I then update their records.

You will see that the report , "rpt_YearlyApplicationToOwners" is used as the yearly "application" sent to owners.

It has two subreports. One for property details named "sbrpt_OwnerPropertiesQuery" and one for forestry details named "sbrpt_OwnerProertiesForestryQuery"

First problem: for every record of parcel information in the "sbrpt_OwnerPropertiesQuery" , the main report repeats. i.e., if the owner has 4 property records in the subreport, the application will repeat 4 times.

arnelgp went into the database and fixed this before, but I was unsure how to replicate that. He did some sort of group by in the record source query.

Thank you,

Zen

 

[mike60smart]

Hi Zen

The problem is down to poor normalisation

The query is based on tblOwnerProperties.

Each Streetname is made up of a Number of Parcels with Each Parcel having Specific Acres

This means instead of 1 Table to deal with Properties you need at least 3.

 

[ZenDiagram]

Mike60smart,

I know my database isn't normalized completely but I want to keep it this way. Is there a way to fix this without restructuring my tables?

 

[mike60smart]

Hi

I would recommend that you bite the bullet and redesign.

You will always have to do work arounds to get correct data

 

[GinaWhipp]

Putting aside that this database is going to be a constant work around project in its present state. You could just do a Group By (the Totals button) with the Record Source of the Main Report.