How do I get rid of duplicates on a report without using results from a workflow / query layer?
I am using the basic mailing labels template, but need to remove duplicate addresses so we don't have dozens of labels for the same person. I understand that I could remove them from a query layer, but I want users to be able to run the report directly from selected features on the HTML5 viewer so the language to make distinct must be on the report itself.
Thanks.
-
Hey Bobbi,
You click on the control you want to restrict, then go to the properties for it in the right-hand panel and go the the Behavior section. Change "Process Duplicates" to Suppress, Merge or Suppress and Shrink depending on your exact use-case.
You can also do expressions for the visibility of a given control or subreport by choosing the item, then go to the expressions tab on the right panel (below properties, above field list) and create a visibility expression. Eg. only visible if {field] = true or rowcount()>1
0
Please sign in to leave a comment.
Comments
1 comment