I have a report control with a load of charges in it.

I have setup a filter for the list so the user can limit the selection by category.

Some of the categories names have a space in them. eg Freight In, Freight Out.

 

When the text "Freight In" is applied to to the .filtertext property it shows both Freight in and Freight Out items because they both contain the word Freight. ie the words are treated as individual words not as a phrase.

 

Is there a way to get the .filtertext to work against the .Value property as opposed to the .Caption property? That way I could put whatever I liked in the field without it messing up the display.

 

Is there a way to get .filtertext to use the phrase instead of the words? I tried setting up 'Freight In' but it did not work.

 

Any other suggestions would be welcome.

 

Thank you.

I ended up making a hidden column and putting ammended values into it such as Freight-In which allowed me to do what I wanted to.

 

I guess what I neeed was a FilterSeparatorStrict per column rather than for the whole control.

 

I didn't test this yet because the Beta expired at that time and don't know if this is implemented in newest version see post https://forum.codejock.com/forum_posts.asp?TID=15718 - https://forum.codejock.com/forum_posts.asp?TID=15718  

 

Good luck

 

btw Would be nice to have more filter functionality with .FilterText, I will add this to my list and wait what CJ thinks about this.