How to use declarative indexes in report definitions
This article describes how to include indexed embedded properties in your report definition rules using the Declarative Index Join feature. To include indexed embedded properties in a report, associate a prefix with an index definition. Each property in the index definition is then accessible in the other tabs by using the syntax: prefix.indexed property.
For more information about creating declarative indexes, see How to create Declarative indexes for embedded properties.
You can also use declarative indexes in list view and summary view rules. See How to use declarative indexes in reports.
Properties discussed in this article must be optimized ("exposed") to be included in the report. Work with your database administrator to optimize the properties you need.
Suggested Approach
- Create or edit a new report definition.
- On the Data Access tab, enter a Prefix value in the Declarative Index Join section. Choose a value that is relevant to the properties you have indexed. Ensure that the Prefix value is not a SQL reserved word. In the Index Name field, choose the index definition from the SmartPrompt list.
- When you reference properties on the Design tab, enter the Prefix value followed by a "." first, then select the desired property.
- After you are finished editing the report structure, click the button to view the report.
