Print this page

Record Type Filter Order in Report Builder

Knowledge Article Number 000187013
Description When the Record Type is added as a Filter Criteria in the report, the values in the lookup will display in an unusual order. User needs them to be sorted in alphabetic order.
Resolution While Creating a New record using Record Types, Salesforce will sort the Record type Values Alphabetically.
But when Record Type is used as Filter Criteria in creation of Report, it will have  values in the Lookup window in the order the Record Types were Created.

Note: This is the Standard behavior of Salesforce.


·          If the record type values were needed in alphabetical order at the time of adding them on the filter to a report, then we need to delete the existing record types and create them again in the order that they need them in report filter(i.e., Alphabetically). 

promote demote