The way to sort items in a BR report would be by using it as a repeater and selecting the sort option in the repeater, but I am afraid this would not provide you with the expected result since the data that you receive if you add the measure item as a repeater could be different since it would repeat by that measure item as well, So according to my knowledge the only way you could achieve this is by using the sort available in Excel but for the report to be sorted you would have to execute it and sort it manually in the Executed mode (i.e Report Mode). As there is no functionality that I am aware of which could facilitate sorting a measure item in the design mode.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.