on 05-27-2016 8:14 PM
HI I have a column that if it starts with 9, 2, or 11 then we want to process.
How to make this in record selection?
Hi Paul,
Is this a string field?
-Abhlash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you're reporting against a SQL Query, you're better off converting field to string and extract part of it using substring or other db specific string functions in the where clause.
If you're reporting directly against tables/views, you may add a SQL Expression that extracts part of the number and use that in the selection formula.
But if you wish to do this in the report's selection formula, it would look like this:
Totext({number field}, '#') LIKE ['9*', '2*', '11*']
-Abhilash
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.