Page History

Data Source

Provides the name of the db connection used to create the report.

View

Provides the name of the view use to create the report.

Active Row Limit

Provides the user with the option to restrict the number of rows returned in the active report. This is inherited from the Source Connection, but can be restricted further at the report level.
Note: this setting does not control the table preview on the data step, only the final output of the report.

Show Duplicate Records - this allows the user to remove the 'DISTINCT' clause from the SQL. This means that results that appear multiple times will display in the final report, rather than being removed, so there may be rows that are identical.

Auto Refresh

This allows the user to turn the Auto Refresh option On or Off. Auto Refresh controls the way the sample data in the Table Preview is generated.

• On

• : each time a change is made to the report, such as a field being added to the Columns or Rows list, the database is queried.
• Off

• : dummy data is used to display a preview of the table without querying the database. This should be used for reports that require a large number of fields to be added, or edits made, to help with performance.
  Note: this setting does not control the final output of the report, only table preview on the data step.

Preview Row Limit

This allows the user to define the number of rows displayed in the table preview.
Note: this setting does not control the final output of the report, only table preview on the data step.