I have a tablix like so
Two parameters - begin date and end date
Customer Emp Hires Emp Terminations
XYZ 12 2
What's the best way to do the grouping, specifically the column grouping? I'm currently grouping by customer in the row group and then in the hire field, I'm doing a sum(iif(hire_date between begin and end date,1,0)). Same for termination field but using the employee's termination date. (Essentialy a sum(case when then 1 else 0 end) in SQL
Now, since they may run it for an entire month, an employee might fall in both columns (hired and termed in the same month). Is what I'm doing the best way or is there a more correct/more effient way? If what I'm doing is the best way in SSRS, it seems I should do the pivoting in SQL (if possible) instead for better performance overall?
