Last post Oct 29, 2018 06:26 AM by Nan Yu
Oct 25, 2018 03:24 PM|JasR09|LINK
Just starting on a report for cases being sent between different teams but am stuck as I can get the desired outcome. For each case I would like to find the first date the case sent to Team 3 and also last time it was re-sent to Team .
Using Data below:
and the desired report should look like
First time sent to Team_3
Last time sent to Team_3
I tried using First, Last but can't get the desired output.
Thanks in advance
Oct 25, 2018 04:39 PM|PatriceSc|LINK
First and Last is about the "position" (ie it dépends on how data are sorted). Instead use Min and Max to get the lowest and highest value in a column regardless of the position of their rows. What is your DB ?
Oct 25, 2018 05:48 PM|JasR09|LINK
I tried Min and Max but can't get the correct values to show as the expression would need to match CurrentTeam = "Team_3". I tried variations of
=IIf(Min(Fields!CurrentTeam.Value Like "*Team_3*"), Min(Fields!DateRange.Value), "")
but correct value isn't shown
The data is coming from Dynamics 365 using a FetchXML query so no way to create a customer SQL query for me.
Oct 26, 2018 05:21 AM|Nan Yu|LINK
I tried Min and Max but can't get the correct values to show as the expression would need to match CurrentTeam = "Team_3"
You can refer to below threads which provides solution for how to show min/max date per group in SSRS :
Oct 26, 2018 10:41 PM|JasR09|LINK
I had a look at those but still couldn't get the desired results. The issue seems to be when trying to using expression (or variation of)
Oct 29, 2018 06:26 AM|Nan Yu|LINK
Have you tried code samples from above link , you should firstly group by Team /ID , and then get the min/max date .