How to display descendants documents uniquely in a categorized view?

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: How to display descendants documents uniquely in a categorized view?

Feedback Type: Question

Product Area: Domino Designer on Eclipse (DDE)

Technical Area: Application Development

Platform: Windows

Release: 8.5.2

Reproducible: Always

How not display repeating entries form descendants documents in the view?

I have a sorted categorized view with the following view selection formula:

SELECT @Contains(Form;"Report1" ) & Priority ="Not Applicable"

Here is the code for categorized view:

@If(FieldA = ""; "Not Assigned"; FieldA) + " [ Total: " + @DocDescendants("%") + " ]"
to display all documents and thier descendants. The descendants documents have a field I called FieldB that I want to display in the view. Many descendants documents have identical value for this field. Using @Unique doesn't remove repeating entries. Also using @unique in the view selection formula has no effect.

My goal is to display documents in the view so under each parent child documents display uniquely.

If I categorize the second column(Field B) which is a field in the descendants document it will not display the repeating documents, but If I select all documents for export to an Spreadsheet all documents will be included in the report. I am using Notes/Domino 8.5

any suggestions would be appreciated.
Thanks in advance.

Feedback number WEBB9MNJMD created by ~Michelle Zenponesterli on 08/04/2014

Status: Open
Comments: