SSRS report Excel export with custom sorting

Question

I have a column in my report that shows different icons. I have a sorting logic for that column. I want to add a custom soring function to sort by. My first question: is it possible to provide a custom function to sort a column by? We use similar technique in web screens. My second question: the dort will not go ver the Excel when I export report, correct?

Thanks

Answer 1

You can use any SSRS expression you want to control sorting. In the sort field you can click the Fx button to go into the expression editor and use any SSRS expression to control formatting up to and including your own custom functions that you've added to your report.

When you export to another format then the order in which the data appears in the report is what would get exported. The report is rendered (which sets ordering) and then exported. Having said that I'm not sure whether interactive sorting would export correctly because the report is exported, not the current UI display AFAIK but honestly I've never had to export a report with interactive sorting enabled.