Sorting a table in a BW web report

[Former Member]

Hi,

I want to be able to sort a table in a web report by a key figure. The only way I can find of doing this is doing it in the properties screen from the context menu.

Does anyone know a line of code that would automate this for me when the web report is executed.

Thanks

Ian

[Former Member]

Or you can create a condition on the key figure to display the TOP N and the value as some value which will never be met.

Thanks.

[Former Member]

Hi,

sorting on structure elements is not supported in the Query Designer, but you can create a View based on the query with the correct sorting settings. Then use the view in your Web template.

Heike