In the Report Editor, the Data Explorer provides an efficient way to find a property or calculation to include as a column in a report. You can also use the Data Explorer to define filter conditions.
The Data Explorer displays available properties and calculations in the following three tabs:
- Best Bets – Displays the properties that you are most likely to use in your report.
- All Matches – Displays all of the properties that are available for you to use in the report.
- Calculations – Displays SQL functions that you can use as columns and filters in the report.
When you search for a property, the search results do not include embedded properties. If you select a property that does not belong to the class that the report applies to, or the parents of that class, the Report Editor creates a join between the classes.
Application developers can specify the set of properties that are available for users of the Report Editor. In addition, application developers can use property security rules to restrict access to properties by specifying required privileges for a property. Although, the Data Explorer does not distinguish which properties are secured, users cannot add these properties to a report unless they have the required privileges.
- Adding columns to reports
Extend the report scope by including a property or a calculation in the report. For example, you can include a calculation that displays the difference in hours, days, or months between two dates of your choice.
- Editing a report
You can modify a report to change the way the report displays information, or filter the data for different audiences by using the Report Editor.