function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
TejasviTejasvi 

How to add Long Text Area field on reports filter?

Hi,

I have a requirement to run report where "Customer Comments" field(Long Text Area) not equals to null records need to show on reports.
Any thoughts how to add long text area field on report filter.

Note: I have try on report filter to add "Customer Comments" field but is not showing on list.

Thanks in Advance.
ApuroopApuroop
Hey Tejasvi,

Unfortunately this feature is still in progress: https://success.salesforce.com/ideaView?id=08730000000BrhEAAS

I have an idea though, 
  • Create a checkbox (CustomerCommentsIsNull) on your object. Make sure it's visible to the users who'd be running the report.
  • Create a trigger.(see below)
  • This is going to work for the new records and the old ones ONLY if you update them.

Trigger: Modify it according to your fields' names and object name.
trigger isCustCommsNull on Opportunity (before insert, before update) {
    for(Opportunity opp : Trigger.New){
        //FieldForReport__c would be your CustomerComments__c
        if(String.isBlank(opp.FieldForReport__c)){
            //opp.CustomerCommentsIsNull would be the Checkbox field.
            opp.CustomerCommentsIsNull__c = true;
        } else{
            opp.CustomerCommentsIsNull__c = false;
        }
    }
}

If you think you can update all the records by giving some dummy data to an unused field then you can populate a value in that Checkbox. Now you can use this checkbox in your report to filter all the records. Hope it helps :)