Home > Features > Data
These options are used to return a subset of the records (the data set) returned by the source. These features share one thing in common: they all alter the data returned by the source.
A data source may return the same record multiple times depending on the query definition.
Use this feature to set how duplicates will be handeled:
Show all records
Show records that have duplicates
Show only unique records
See Duplicates for detailed information on each setting.
Advanced Filter applies Excel's Advanced Filter feature to the data set each time the report is generated. It does NOT filter the data set in place. Records that do not meet the filter criteria will not be in the report. It functions identically to Excel's Advanced Filter feature with the copy to another location option (the report is the other location).
Search and Replace automates Excel's Find and Replace.
See Search and Replace for detailed information on this feature.