ZenDiagram
Registered User.
- Local time
- Yesterday, 23:38
- Joined
- Aug 28, 2018
- Messages
- 37
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
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