Display item reference and use item reference properties

The Display Item Reference property specifies which query item is displayed to the user in the prompt. The Use Item Reference property specifies which query item is passed from the prompt to the filter. Each value in the list of display items is associated with a value of the query item specified in the Use Item Reference property.

For example, you want the prompt to display Country Name while using Country Code to retrieve data. Set the Display Item Reference property to Country Name and the Use Item Reference property to Country Code. The prompt for Country Name makes it easy for the report user to select required values. However, using the Country Code in the filter is more efficient for data retrieval.

These properties are used by

  • Query Studio to create a filter expression and set the use and display items in a prompt and prompt query
  • The Build Prompt Page tool in Reporting to set the use and display items in a prompt and prompt query
  • Generated prompts in Reporting to set the use and display items in the prompt and prompt query

Note: The values of the Use Item Reference and Filter Item Reference properties must be compatible. Otherwise, the report user may receive unexpected results. For more information, see Filter item reference property.

Default: If no values are set, the properties default to the name of the query item.

These properties are used only for data driven prompt controls whose Prompt Type property is set to either Select Value or Select with Search.