filter not taking the format of the column properly

Hi people,
I am currently working on reports and would like to filter a column using the legacy designer report view.

The issue I am facing is: the report has a text formatting column with data like this 000004774 so every time I try to search for the whole text value 000004774 and hit apply the filter field automatically takes it as number value and removes the zeros thus, no matches.

However, filtering using a!queryProcessAnalytics() works properly.

attaching screen shot, please advise.

OriginalPostID-270204