locked
SSRS starting with sort on sum field with interactive sorting on column group RRS feed

  • Question

  • Hi all,

    I have build a report with interactive sorting on a column group (this works)

    I also have interactive sorting on the sum column of that group (also works)

    My problem how do I start the report with a sort on that last sum column ?

    I can't do it on the row group, because this already facilitates the interactive sorting on the column group.

    Hope I explained it clear enough.

    thanks in advance

    RBie

    Thursday, October 4, 2018 11:25 AM

Answers

  • Sorry didnt understand the last part

    can you elaborate what you mean by "I can't do it on the row group, because this already facilitates the interactive sorting on the column group"?

    What happens when you give default sorting for the row group to be based on Sum expression?


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Marked as answer by Rbie Thursday, October 4, 2018 12:31 PM
    Thursday, October 4, 2018 11:48 AM

All replies

  • Sorry didnt understand the last part

    can you elaborate what you mean by "I can't do it on the row group, because this already facilitates the interactive sorting on the column group"?

    What happens when you give default sorting for the row group to be based on Sum expression?


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Marked as answer by Rbie Thursday, October 4, 2018 12:31 PM
    Thursday, October 4, 2018 11:48 AM
  • AARRRGGGGHHH

    I had already tried that, I thought it didn't work, turns out I should have just added it last not first .....


    • Edited by Rbie Thursday, October 4, 2018 12:36 PM
    Thursday, October 4, 2018 12:31 PM