none
SSRS Matrix Sort Order RRS feed

  • Question

  • Hi,

    Could you please help me to display the data as per the SQL Query Result in a SSRS Matrix Report.

    I have tried deleting the sort order from the group properties of the row group of Matrix.

    Also,you may refer the below scenario

    SQL Executed Result is the following:

    Matrix Result output:

    You can compare the third column of sql query and 1st column of report.

    Please help!

    Regards,

    Afshaan Shaikh

    Thursday, April 25, 2019 6:36 AM

All replies

  • please help
    Thursday, April 25, 2019 9:18 AM
  • Hi Mohammad Afshaan Shaikh

    According to your description , sorry for not clear about your requirement .

    Do you want to do the sort for the t-sql according to the order in the matrix .

    Which means in your tsql there sort is A,C,B, while in the matrix , the sort is A,B,C  you just want to do the sort in tsql like the sort in the matrix ?

    Seems you have covered the full value of the column “classvalue“ , so we could not get to know what the detailed order in your tsql resultset.

    If possible you could offer the detailed description about your requirement and offer the column “classvlaue” in the dataset query resultset to us for more further research.

    Hoping for your reply.

    Bes Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Friday, April 26, 2019 2:19 AM
  • Hi Mr. Eric Liu,

    Thanks for your valuable time and understanding!

    Here's the dataset snapshot and the output snapshot of SSRS Report.

    We want that the SSRS Matrix should display sort order as displayed in the Data set query execution window

    Please refer the below output shown in SSRS Matrix 

    Could you please look into this as we are having some urgency regarding this point.

    With Regards,

    Afshaan Shaikh

    Friday, April 26, 2019 8:53 AM
  • Hi Mr. Eric Liu,

    Thanks for your valuable time and understanding!

    Here's the dataset snapshot and the output snapshot of SSRS Report.

    We want that the SSRS Matrix should display sort order as displayed in the Data set query execution window

    Please refer the below output shown in SSRS Matrix 

    Could you please look into this as we are having some urgency regarding this point.

    With Regards,

    Afshaan Shaikh


    Monday, April 29, 2019 11:36 AM
  • Hi Mohammad Afshaan Shaikh

    Sorry for the late respond.

    Have you ever tried the sort function in the matrix group properties like below :

    Hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Tuesday, April 30, 2019 2:52 AM
  • Hi,

    Thanks for your reply.

    The sort function will  sort as per the column name specified  but we dont want to sort as per the column we want the data as per the dataset executed query which is not in a ascending or descending order.

    Please help!

    Thanks & Regards,

    Afshaan Shaikh

    Tuesday, April 30, 2019 6:55 AM
  • Hi  Mohammad Afshaan Shaikh

    According to your description , seems get confused about your requirement .

    You miss a lot information in your screenshot and description.

    If possible you could offer the detailed data sample and the matrix structure to us for more further research .

     (the data sample and the rdl file is better)

    Hoping for your reply.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Tuesday, April 30, 2019 8:29 AM
  • Hi,

    How can i share the rdl file with you?

    Tuesday, April 30, 2019 8:50 AM