Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 22 May 2018 at 9:38am
I usually use IN rather than = when dealing with multiple values but I think that is moot.
to further test you can make another formula that is testing that out
//test1
({Command.DepDescr})=["AAA","BBB"]
Place it on the detail section and you should see a TRUE or FALSE per row. You want to see TRUE for any row that is AAA or BBB.
I would also place the Command.DepDescr field next to it to verify that is the value for the row.
Joined: 17 May 2018
Online Status: Offline
Posts: 25
Posted: 22 May 2018 at 9:42am
Hello,
Not sure what went wrong but I delete both RT and formula and retype it. Then put it on my report and guess what it worked as expected.. So not sure white space was causing the issue? But I have seen such type of behavior in the past for oracle database..
Now it is working..
Again THANK YOU for your time.. You will see more questions from me on this forum as just picked up to work on big reporting project.
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
