Count of created cases when statecode is active and count of resolved cases when statecode is resolved.for the last 4weeks.ecah week starting date and ending date column need to dispaly.this scenario is for a perticular team.if the team name is abc then I need to display all the users under that team who have created the cases and closed the cases
Hi to do this with SQL query ssrs reports?