Report Limit Editor

The Report Limit Editor allows you to set and modify report limits. Report limits are filtering criteria that limit the final result set that is returned to the client. The main difference between report limits and metric qualifications is that metric qualifications can change the actual calculations and report limits do not. If you are familiar with SQL, a good analogy in terms of SQL Generation is to think of a metric qualification as a WHERE clause and a report limit as a HAVING clause; the WHERE clause has a direct impact in the result set and the calculations of the query whereas the HAVING clause has the effect of only limiting the final result set.

Report Limit Editor contents

Information on the Report Limit Editor is divided into the following main sections:

• Layout

• Limit Definition

• Report Limit Qualification

• Level dialog box

Accessing the Report Limit Editor

You can access this editor in any of the following ways:

• From the Template Editor, place a metric in the Template definition section. From the Data menu, select Report Data Options. The Report Data Options dialog box opens. Under Categories, select Calculations, then Report Limit. Click Modify. The Report Limit Editor opens.

• From the Report Editor, place a metric in the Template definition section. From the Data menu, select Report Data Options. The Report Data Options dialog box opens. Under Categories, select Calculations, then Report Limit. Click Modify. The Report Limit Editor opens.

• From the Report Viewer (an executed report), if the report contains a metric, from the Data menu, select Report Data Options. The Report Data Options dialog box opens. Under Categories, select Calculations, then Report Limit. Click Modify. The Report Limit Editor opens.

Related Topics

• Creating or modifying a report limit

• Display or hide the Shortcut Bar