I have a data report that I have created using data designer with data environment in vb thats select three fields from the same database table. Spaceno, rent, Name. By default when showing the report the space no is sorted(ascending order). How can I program where a user can sort by the name at run time. The user will select that they want to sort by name using a drop down box. I know I can create a seperate report sorted by name and one sorted by spaceno but if the user can select at runtime that would be great.