locked
display grouped data in certain order RRS feed

  • Question

  • User-641207234 posted

    I have a report that displays grouped data. The categories are only displayed if there's data. How do you display the data in a certain order like below.

    category admin
    Bill
    Sally
    category upper mgt
    Fred
    Wilson
    category users
    Henry
    Trent
    category general
    Greg
    Karen
    Molly

    Wednesday, December 23, 2015 5:52 PM

Answers

  • User1724605321 posted

    Hi tmtlg,

    The categories are only displayed if there's data

     When no data exists for a report dataset at run time, you can write your own message to display in place of the data region ,the you could keep the order .

    How do you display the data in a certain order like below.

    Please refer to below link for details :

    https://msdn.microsoft.com/en-us/library/dd239384.aspx

    Best Regards,

    Nan Yu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 24, 2015 5:41 AM

All replies

  • User1724605321 posted

    Hi tmtlg,

    The categories are only displayed if there's data

     When no data exists for a report dataset at run time, you can write your own message to display in place of the data region ,the you could keep the order .

    How do you display the data in a certain order like below.

    Please refer to below link for details :

    https://msdn.microsoft.com/en-us/library/dd239384.aspx

    Best Regards,

    Nan Yu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 24, 2015 5:41 AM
  • User-62323503 posted

    Use Left join with Category Master table in the query  

    CategoryMaster M left join YourTable T on M.CatId = T.CatId

    Monday, December 28, 2015 12:45 PM