I am developing an SSRS 2008 R2 RDL and I have the requirement to limit data per incident and per client according to the two criteria:
1. Each incident falls into one of the following 5 buckets: A, B, C, D, E. There are multiple records for each incident. And the requirement is: according to alphabetical order it should display only one record/incident. This means that if for incident #33, this incident has one "B" record and one "C" record that my RDL should only display the "B" record since it has higher priority than "C". Similarly, a "C" record would have higher priority than a "D" and "E" record.
2. The second requirement is as follows. Each client can have one or more incidents. If one of the clients has two or more incidents within 15 minutes, the earliest incidents need to be excluded. For example, if the first incident occurs at 12:00 and another for that same client at 12:10, only the 12:10 incident should be included.
You can apply filter to the dataset created for report.Use expression to create the filter as per your need.refer the below image:
*Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*