Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Applying filters to preview text
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Applying filters to preview text
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
Mike Lewis View Drop Down
Groupie
Groupie


Joined: 29 April 2009
Status: Offline
Points: 41 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mike Lewis Quote  Post ReplyReply Direct Link To This Post Topic: Applying filters to preview text
    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
Back to Top
Mike Lewis View Drop Down
Groupie
Groupie


Joined: 29 April 2009
Status: Offline
Points: 41 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mike Lewis Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2009 at 1:58pm
Originally posted by Mike Lewis Mike Lewis wrote:

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



 
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...
 
  1. Maybe you can take a look at post https://forum.codejock.com/forum_posts.asp?TID=15210 (test project with highlighted filtertext using BeforeDrawRow event!!! if your language can handle it?)
  2. Use own filter function where you loop all records and make only rows visible which apply to filtertext, in case of Parent records also show childs.
 
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....
Back to Top
Mike Lewis View Drop Down
Groupie
Groupie


Joined: 29 April 2009
Status: Offline
Points: 41 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mike Lewis Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.172 seconds.