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
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 .
tmtlg
How do you display the data in a certain order like below.
tmtlg
None
0 Points
3 Posts
display grouped data in certain order
Dec 23, 2015 05:52 PM|tmtlg|LINK
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
Nan Yu
All-Star
15725 Points
2618 Posts
Microsoft
Re: display grouped data in certain order
Dec 24, 2015 05:41 AM|Nan Yu|LINK
Hi tmtlg，
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 .
Please refer to below link for details :
https://msdn.microsoft.com/en-us/library/dd239384.aspx
Best Regards,
Nan Yu
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.
sandeepmitta...
Contributor
5774 Points
1170 Posts
Re: display grouped data in certain order
Dec 28, 2015 12:45 PM|sandeepmittal11|LINK
Use Left join with Category Master table in the query