I'm creating a SSRS report and I want to get the open cases for particular user in specific date range like below.
- I have table called User from there I'm getting user info(User1,User2,User3).
- I have open cases in the table management under description table.
- 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.
<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?