Hide Duplicates

[annettem]

I have a report that lists land transaction information such as:
document number, type of document, party type (grantor or grantee),
name of person, transfer fees, legal description, parcel number and
address.

The user wants to run this report showing all fields with a toggle in
the parcel number and address.

In other words, in selecting the report they would like to have either
the parcel number or the address display. The address is the same for
all people within a document, however the parcel number will change
within the document.

I currently have all this information on the detail line in the report.
The format procedure of the detail section will make the parcel number
or address field not visible depending on the users record selection
criteria.

Data would be like this:

81000 Johnson, Mary Grantee 002-1000-10-000
81000 Johson, Charles Grantee 002-1000-10-000
81000 Anderson, Sue Grantor 002-1000-10-000

or like this

81001 Glenn Builders Grantor 004-1000-10-000
81001 Glenn Builders Grantor 004-1000-20-000
81001 Glenn Builders Grantor 004-1000-30-000
81001 Glenn Builders Grantor 004-1000-40-000
81001 Smith, Susan Grantee 004-1000-10-000
81001 Smith, Susan Grantee 004-1000-20-000
81001 Smith, Susan Grantee 004-1000-30-000
81001 Smith, Susan Grantee 004-1000-40-000

Assuming the user has selected to show the address instead of the
parcel number, in the second occruance, I only want Glenn Builders as a
Grantor to display as well as Smith, Susan as the Grantee . Therefore,
only two lines will be listed for document 81001 when the user selects
by address (and the address would display rather than the parcel
number). All 8 lines would show if the user selected the parcel number
to display. Confusing

 

[Marshall Barton]

I have a report that lists land transaction information such as:
document number, type of document, party type (grantor or grantee),
name of person, transfer fees, legal description, parcel number and
address.

The user wants to run this report showing all fields with a toggle in
the parcel number and address.

In other words, in selecting the report they would like to have either
the parcel number or the address display. The address is the same for
all people within a document, however the parcel number will change
within the document.

I currently have all this information on the detail line in the report.
The format procedure of the detail section will make the parcel number
or address field not visible depending on the users record selection
criteria.

Data would be like this:

81000 Johnson, Mary Grantee 002-1000-10-000
81000 Johson, Charles Grantee 002-1000-10-000
81000 Anderson, Sue Grantor 002-1000-10-000

or like this

81001 Glenn Builders Grantor 004-1000-10-000
81001 Glenn Builders Grantor 004-1000-20-000
81001 Glenn Builders Grantor 004-1000-30-000
81001 Glenn Builders Grantor 004-1000-40-000
81001 Smith, Susan Grantee 004-1000-10-000
81001 Smith, Susan Grantee 004-1000-20-000
81001 Smith, Susan Grantee 004-1000-30-000
81001 Smith, Susan Grantee 004-1000-40-000

Assuming the user has selected to show the address instead of the
parcel number, in the second occruance, I only want Glenn Builders as a
Grantor to display as well as Smith, Susan as the Grantee . Therefore,
only two lines will be listed for document 81001 when the user selects
by address (and the address would display rather than the parcel
number). All 8 lines would show if the user selected the parcel number
to display. Confusing

I think the easiest way to do this kind of thing is to use
Sorting and Grouping (View menu) to group on the expression:
=namefield & "/" & addressfield
Copy the document, name, address text boxes from the detail
to the group header. The detail section would then have the
document, name, parcel number, etc (no address).

Now, your toggle can make the group header Visible and the
detail invisible or vice-versa.