Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSRS 2008 sorting

Answered SSRS 2008 sorting

  • Monday, January 21, 2013 8:58 PM
     
     
    Sign In to Vote
    0
    I 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.
     

All Replies

  • Tuesday, January 22, 2013 2:44 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Suneel,

    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
    FROM   table

    Regards,
    Fanny Liu

    If you have any feedback on our support, please click here .

    Fanny Liu
    TechNet Community Support