Monday, January 21, 2013 8:58 PMI have grouped my data to be broken down by 50 rows per page using function called Ceiling(RowNumber(Nothing)/50. But ever since i have added this group my sorting got broke. If i try to sort any column, the sorting is happening on every 50 rows instead of the whole dataset. Can some one please help on this.
Tuesday, January 22, 2013 2:44 AMModerator
In Reporting Services, the RowNumber function can't be referenced in a sort expression. If you want to sort the whole detail rows in report, you can try to specify the sort in dataset query and sort the report data when retrieve them from the database.
For example, you can add a row number column in the dataset query which is sorted by the column you want. Please refer to the following query:
SELECT Year, Month, Amonut, ROW_NUMBER() OVER (ORDER BY Amonut) AS RowNumber
If you have any feedback on our support, please click here .
TechNet Community Support