I have designed a report and is running really slow .In my report , there is a filter which checks for a verbiage in the memo field.

I tried different ways , by converting it to the text format and then searching for the string or trimming the first few letters and then searching for the string, this was becuase i knew the string i was searching was in the beginning.Bt none of the above change helped in performance.

 

Does anyone have a better approach to include the memo field in the filter and have a better performance.

 

I have used the same filter in another report but it works fine but in this report since the search is bringing null records can this be a reason.I am not sure.Help needed.