Print this page

What is the Maximum Number of Characters that can be Queried in a Report?

Knowledge Article Number 000170897
Description Only the first 254 characters in a rich text area or a long text area field are able to be queried within in a report on Salesforce.
This means that it will only display up to 254 characters and it can only filter on the first 254 characters as well.
Resolution Standard Long Text Area fields have a limit of 999 characters when called on the report whereas Custom Long Text Area has a limit of 254 characters.
However, when Reports are exported as Excel or CSV files,  then the field will display all the characters indicated in the field past the 254 / 999 character mark. 

promote demote