Sorting Data

Hi All (any help will be appreciated)

Sorting Data in Business Objects modify view is just like sorting in excel, However in the view where you would just click on the report name you want to open, there does'nt seem to be a sorting option.

My problem is i have set up a report with prompts for dates and agent names. However when i clcik on agent name promt to select a single name the list of names in the report is not in order but in modify view it is. i tried to refresh to see if that would work but it didnt.

Does anyone know how to correct this? it may be something really simple that i am not seeing!

Thanks very much

Kelly