How to Toggle SELECT and SELECT DISTINCT in Report Builders' SQL

You can toggle SELECT and SELECT DISTINCT in a reports SQL by clicking the 'Show Duplicate Records' option in the Report Builder:

Off (Default) = SELECT DISTINCT

On = SELECT

Is article helpful?