Applying filters to preview text
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=15258
Printed Date: 15 November 2024 at 6:44am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Applying filters to preview text
Posted By: Mike Lewis
Subject: Applying filters to preview text
Date Posted: 28 September 2009 at 11:10am
|
I am using ver 13.1, with Visual FoxPro. I have just added a filter function to my report, using FilterText and FilterHiddenColumns. It's a very nice feature, and easy to implement. I just have one question. Is it possible to specify whether the filter will apply to preview text? As far as I can see, if the preview text contains a given word, and if FilterText also contains that word, the record will be found if PreviewMode is true, not if it is false. What I'd ideally like to do is to always find the record, even if the preview text is currently invisible. (In other words, like FilterHiddenColumns, but applying to preview text rather than columns.) It's not a show-stopper, but it would be nice if I could do this. Thanks in advance. Mike ------------- Mike Lewis Software Developer Edinburgh, Scotland |
Replies:
Posted By: Mike Lewis
Date Posted: 29 September 2009 at 6:49am
|
Could I add a supplementary question. This is a little more critical than my question about preview text. If a row has child rows, and if the parent row meets the filter and the child rows don't, then the child rows will be completely invisible. Not just collapsed, but invisible. The +/- icon doesn't appear, and there's no way to expand the row while the filter is in force. In a way, this makes perfect sense. But it's not what I want. Is there any way that I can keep the child rows visible (whether expanded or collapsed) even though they don't meet the filter? I'd ideally like to let the user filter on a word that will only ever be present in parent rows, but still have the ability to drill down. Mike ------------- Mike Lewis Software Developer Edinburgh, Scotland |
Posted By: Aaron
Date Posted: 29 September 2009 at 1:58pm
Hi Mike,
It would be nice to have property wndReportControl.RecordsTreeFilterMode = xtpReportFilterTreeByParentOnly... maybe some day when Mark is in a good mood
 But for now you have to deal with it yourself...
Good luck
 ------------- 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.... |
Mike Lewis wrote:Posted By: Mike Lewis
Date Posted: 29 September 2009 at 2:23pm
|
Hi Aaron, Thanks for your reply. I guess it wouldn't be too onerous to do my own filter. There's no problem with BeforeDrawRow in my development environment. I've used it in another context to apply markup to column headers, and it worked fine. I also like the idea of highlighting the actual filter words within the filtered rows. In fact, I was planning to write my own filter routine before I discovered FilterText. Maybe I'll go back to that idea. But I think I'll wait and see how the users react to not being able to drill down on filtered rows before I make the decision. Mike ------------- Mike Lewis Software Developer Edinburgh, Scotland |