Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 23 Jan 2017 at 12:01pm
The first question is the code field a string or a number. If it is a number then yes it should work (with slight modification
if {table.field} >= 98101 and {table.field} <= 98801 then "Show" else "Hide"
if it is a string if {table.field} >= "98101" and {table.field} <= "98801" then "Show" else "Hide"
numeric strings can sometimes be a little tricky with ranges and sorting.
Joined: 20 Jan 2017
Online Status: Offline
Posts: 7
Posted: 24 Jan 2017 at 4:20am
Thank you for the help.
It is a string and I think it is working correct. The problem I am having is that on the report instead of the number (code) showing it displays show or hide depending on whether or not it is in the range.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 24 Jan 2017 at 7:28am
If you want the number on the report then you put that field in the report. The formula you posted will return either the words Show or Hide. Or do you want the formula to return the number? If so, do this.
if {table.field} >= "98101" and {table.field} <= "98801" then {table.field} else ""
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
