filtertext in treeview |
Post Reply |
Author | |
Y216
Newbie Joined: 19 October 2007 Location: Canada Status: Offline Points: 2 |
Post Options
Thanks(0)
Posted: 19 October 2007 at 10:42am |
I need to use filtertext on all the records (including childs), expanded or not, of a reportcontrol. Filtertex seem to be working only on first level parents. Any ideas?
Thanks
|
|
sserge
Moderator Group Joined: 01 December 2004 Status: Offline Points: 1297 |
Post Options
Thanks(0)
|
Which version do you use?
I believe this has been fixed in last versions... -- WBR, Serge |
|
Y216
Newbie Joined: 19 October 2007 Location: Canada Status: Offline Points: 2 |
Post Options
Thanks(0)
|
V.11.2.0
I'll get around it by running the search on a flat view of the same data.
Thanks.
|
|
Fossil
Groupie Joined: 29 April 2006 Status: Offline Points: 46 |
Post Options
Thanks(0)
|
Confirming that is does NOT work in v11.2 and it certainly would be a huge benefit to us to have that function.
|
|
fjosesen
Groupie Joined: 30 June 2008 Status: Offline Points: 49 |
Post Options
Thanks(0)
|
Hi sserge,
I confirm that it doesn't work on v12.0. Are you planning to fix it in 12.0.1?
Regards,
fjsen
|
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
Hi,
When changing filtertext you have to call wndReportControl.Populate afterwards.
|
|
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.... |
|
fjosesen
Groupie Joined: 30 June 2008 Status: Offline Points: 49 |
Post Options
Thanks(0)
|
Hi,
Yes. I'm calling Populate afterwards. I suppose you have a piece of code where it works, haven't you? If so, can you post it?
Regards.
|
|
Fossil
Groupie Joined: 29 April 2006 Status: Offline Points: 46 |
Post Options
Thanks(0)
|
I call populate as well after setting the filter text.
My best guess is that the control just does not filter through child records just like it does not filter grouped rows (groupcaption). The solution would be to write a custom procedure that loops through all the records and columns within that record and sets the visible property true or false for the record. Unless of course Codejock adds the functionality into the control which would be ideal. I have not gotten around to writing the procedure but if I do I will post it. |
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
Hi,
I can't believe you (and other members in this post) are right about this, please upload a sample which doesn't work (according to you). I don't have much time right now, but I surely get back on 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.... |
|
Fossil
Groupie Joined: 29 April 2006 Status: Offline Points: 46 |
Post Options
Thanks(0)
|
See the attached image. You will notice a child record with the name containing "Elaine" (upper graphic). When starting to type in the filter text (lower graphic) you will notice it does not pick up a match.
|
|
Product: Xtreme SuitePro (ActiveX) version 12.0.2
Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 |
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
Hi,
Images don't say anything... If I would say Santa Claus really exists would you believe me? Upload a sample of your project, at least that part of the image you uploaded.
I have filtering in my RC and I never seen what you have. Grouprows will be excluded from filtering thats correct, I believe that's useless when filtering on items which be will expanded anyway.
|
|
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.... |
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
Hi,
I did a test myself and found that (that's why I asked you guys to upload a sample) when the string of reportitem isn't divided into seperate strings like in @Fossil's image: Holecek,<space>Elain filtering doesn't work as should. If the text is one string the filtering would be correct and even with GroupCaptions filtering will be applied (as I thought this wasn't the case)
I think CJ needs to explain this behaviour, I will add this to my issues as well if you guys dont mind
|
|
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.... |
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
Hi,
It's not that hard to filter records and even on a column:
Private Function FilterRecordsInColumn(currentSelCol As Integer,strText as String)
Dim record As ReportRecord For Each record In wndReportControl.Records record.Visible = True If Not UCase(record(currentSelCol).Value) Like "*" & UCase(strText) & "*" Then record.Visible = False End If Next record wndReportControl.Populate End Function
|
|
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.... |
|
SuperMario
Admin Group Joined: 14 February 2004 Status: Offline Points: 18057 |
Post Options
Thanks(0)
|
It should work like Outlook 2003 if Outlook supports this feature. I don't use Outlook, so I can't test this at the moment. Maybe someone who has this installed can test Aaron's data? |
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
I was wrong with the above. I added the records as far I could see in the image and filter works correct.
To the members who say it doesn't UPLOAD a sample otherwise this post ends here (at least for me). You are the ones with a so called problem, not me.
|
|
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.... |
|
fjosesen
Groupie Joined: 30 June 2008 Status: Offline Points: 49 |
Post Options
Thanks(0)
|
Hi,
I've seen than when you're in hierarchical mode, if a parent record doesn't fit the filter text, no children are shown. I will try to perform a custom record hide/show. I will report you the results.
Regards.
|
|
Fossil
Groupie Joined: 29 April 2006 Status: Offline Points: 46 |
Post Options
Thanks(0)
|
Ok. Here is a sample that proves it does not work. If you type the letter K into the textbox you will notice the report control will become empty, where it should keep 1 row.uploads/20080708_095728_Project1.zip
|
|
Product: Xtreme SuitePro (ActiveX) version 12.0.2
Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 |
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
Hi,
Ok, you convinced me
Now I know what you mean by childs, I thought you ment childs when dragged to groupbox. Ok now I know for sure that this isn't working as should. I will add this to my collection of issues if you don't mind.
Thanks
|
|
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.... |
|
AndreiM
Moderator Group Joined: 18 August 2007 Status: Offline Points: 132 |
Post Options
Thanks(0)
|
Will be fixed in 12.0.2.
The new property RecordsTreeFilterMode will be added to allow you control filter behaviour for children records.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions 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 |