In one of my report I have an entity picker and the entities are displayed. But it is as in order how it is in database. How to sort it in ascending. I tried adding order by close in where of lookup settings like 1 = 1 order by {E}
Please find the screenshots
.name