Reference: Reporting from Salesforce

This section describes rules for building reports from Salesforce.

Input Filters

  • Every query must have at least one input parameter. That means at least one INPUT field must be selected.
  • Input filters can only use equality relations.
  • Only one value can be supplied.

Output Filters

  • Filters can optionally be added on output parameters.
  • These filters are applied after the data is retrieved.
  • Any relation can be used.

Print (sum) fields and sort (By and Across) fields

  • Only output parameters can be used.

Joins

  • See Chapter 4 for information about joining salesforce methods.
  • For reporting, you need to join to an INPUT parameter.

WebFOCUS

Feedback