FilterText

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi,

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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
gduncan Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 11 November 2009 Status: Offline Points: 24	Post Options Post Reply Quote gduncan Report Post Thanks(0) Quote Reply Topic: FilterText Posted: 12 April 2010 at 8:49pm
	Hi, 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.

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 13 April 2010 at 1:23am
	See FilterSeparatorStrict = True\False

gduncan Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 11 November 2009 Status: Offline Points: 24	Post Options Post Reply Quote gduncan Report Post Thanks(0) Quote Reply Posted: 10 May 2010 at 7:36pm
	Yeah, I had seen this but implementing it meant that the filter broke for all other columns. 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.

Aaron Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 29 January 2008 Status: Offline Points: 2192	Post Options Post Reply Quote Aaron Report Post Thanks(0) Quote Reply Posted: 13 May 2010 at 5:09am
	Hi, 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 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.
	Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option....