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


