|
|
|
|
SQL Reporting Services - Answers to your questions
| |
|
Author |
Thread:
Reporting out of tolerance |
|
therook
|
Reporting out of tolerance
Posted:
Friday, March 20, 2009 1:50 PM (GST)
|
|
I am wanting to report a figure is it is out of tolerance, but do not know what expression to use. See info below
If Fields!Actual_Dim_N is < Fields!Tolerance_From_N
or
If Fields!Actual_Dim_N is > Fields!Actual_Dim_N
result either
Fields!Actual_Dim_N is minus Fields!Tolerance_From_N
or
Fields!Actual_Dim_N is minus Fields!Actual_Dim_N
for example
Fields!Actual_Dim_N = 20
Fields!Tolerance_From_N = 21
RESULT = 1
Can anyone help?
|
|
|
|
|
|
|
|
|