How to get middel value from three raw result of query to buld report

Question

I am looking to get the second raw value from my query result which has 3 raw

my result is

Apoint 25
Bpoint 31
Cpoint 50

I want to read 31 and assign that to variable in my SSRS report to and check if first raw and third raw value is within 10 or not. In my final report, I want to calculate a difference of 31-25 if this is less than 10 then I like to put text next to 25 in range if it is greater than 10 then put out of range so the final should look like as below

Apoint 25 In Range
Bpoint 31 In Range
Cpoint 50 Out of Range

and if any value is out of range then I like to send out an email to users using SSRS report subscription. this report can run on schedule.

Can some please help I am new to SSRS

Answer 1

Hi @DM ,
If I understand correctly, you need to create a variable. In this case, assign the variable to "31" and compare the variable with the first and third values. The absolute value <=10 is "In Range", >10 is "Out of Range".

1. Create a variable named "PointValue"
   
2. Use IIF expression to filter the values that meet the conditions, and display "In Range" or "Out of Range". =IIF(ABS(Variables!PointValue.Value-Fields!Value.Value)<=10,"In Range","Out of Range")

3. Preview:

Regarding the subscription part, you could check the following link to learn Standard and data-driven subscriptions: Subscriptions and Delivery (Reporting Services).

Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Good morning @DM ,
Has your issue been resolved? If you have any questions, please feel free to let me know.

Regards,
Joy