1. My First Clarification
I need to group concatenation of two hidden columns. Say for example - My Columns are 1. FirstName 2. LastName.
But I want to group by Cancatenation of EmpId - Dep (Example : Group BY: 1 - HR)
2. Second Clarification
Always I want to show the grouping columns with " No records found" message for individual group.
Ex : 1 - HR
No records found
2 - IT
. Please find the attached screenshot for further reference.