question

I'm creating a SSRS report and I want to get the open cases for particular user in specific date range like below.

1. I have table called User from there I'm getting user info(User1,User2,User3).
2. I have open cases in the table management under description table.
3. I have c_date column in class table.

And I have 3 parameters user, startdate and enddate

And I need to use c_date between startdate and enddate.

If User enters startdate as 2019-01-01 and enddate as 2019-31-01, then I want to display the User1 who has open count.

For 0-5days and User1 who has open count for 6-11 days and same thing for user2 also.

Expected output:

<code>User0-5days  6-11days  
----   -------    -------   
User1    2             1                 
User2    1             4                  
User3    5             0

Explanation: User 1 has 2 open cases between 0-5 days means when I enter date range consider 2019-01-01 and 2019-31-01 so I have 2 open cases between first 0-5 days(2019-01-01 and 2019-05-01) and 1 open cases between next 6-11 days(2019-06-01 and 2019-11-01) etc.

Can I get result like this?