Relatively new to SSRS but cannot understand why my filter expression is not working. In Dataset Properties, I have set up a Filter as follows: Expression is
=Trim(Fields!USER_IP_ADDRESS.Value), expression type isText, operator is =,Value is =Parameters!IPAddress.Value.
bigpadregriz
0 Points
1 Post
SSRS filter expression not working on field containing IP Address
Nov 20, 2012 02:49 PM|LINK
Hi,
Relatively new to SSRS but cannot understand why my filter expression is not working. In Dataset Properties, I have set up a Filter as follows: Expression is =Trim(Fields!USER_IP_ADDRESS.Value), expression type is Text, operator is =, Value is =Parameters!IPAddress.Value.
Basquiat
Contributor
2386 Points
649 Posts
Re: SSRS filter expression not working on field containing IP Address
Nov 20, 2012 03:19 PM|LINK
Not sure why it is not working.
But since you are applying the Filter to the Dataset....why not rather put it in the Query's WHERE clause?