When I create an ad hoc report in Report Builder, it only allows me to sort by the first field in the report.
If I go to 'Sort and Group' it shows all fields, but if I select a field other than the first one in the list, it disappears.
After I run the report, when clicking on the little arrows in the report header only works for the first field in the report.
If I click on any of the other arrows, nothing happens.
Thanks,
Andrea