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.
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
All-Star
18815 Points
3831 Posts
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
Contributor
5794 Points
1185 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