Database Menu - Select Distinct Records¶

For reports that use an ODBC datasource, the SQL 'Distinct' clause can be applied.

When selected, a details row will only be printed when the values within the row above are different.

A checkbox in front of the menu option shows whether a distinct operation is active.

Before¶

After¶

Notes¶

• The Distinct operation is applied to the full returned row. If suppressing a value based on the previous value is desired, study the Previous() function.
• Selecting this option does the same as "Select Distinct Records" in the Report options.