Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - [SOLVED] FilterText and grouped columns
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

[SOLVED] FilterText and grouped columns

 Post Reply Post Reply
Author
Message Reverse Sort Order
s.bagnatica View Drop Down
Newbie
Newbie


Joined: 05 August 2011
Location: Italy
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote s.bagnatica Quote  Post ReplyReply Direct Link To This Post Topic: [SOLVED] FilterText and grouped columns
    Posted: 12 August 2011 at 2:36am
Thank you very much, I was missing the ReportControl1.FilterHiddenColumns = True !
Now it works correctly.
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: 12 August 2011 at 1:14am
Hi,
 
OK, I see what problem is...
 
Add ReportControl1.FilterHiddenColumns = True in Form_Load event and change txtRecordCount.Text = ReportControl1.Rows.Count into txtRecordCount.Text = ReportControl1.PopulatedRecordsCount (note: in V15.1.2 PopulatedRecordsCount has been removed but will be available again in next version)
 
 
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
s.bagnatica View Drop Down
Newbie
Newbie


Joined: 05 August 2011
Location: Italy
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote s.bagnatica Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2011 at 9:30am
The "169" caption is the value of that records, for the column "Numero", that I used for grouping.

However, here is a sample project:
uploads/6957/RCGroupFilterSample.zip

Try opening the form, and filtering for "Black": you should see records containing "Black" color.

Then group by "Color" column: you won't see anything, but the data is the same.
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: 07 August 2011 at 6:00am
Hi,
 
Where does the number 169 in the groupcaption come from? If you group items, the caption of those items will be used that contain the same value. So, normally there would be an item that contains (in your sample, 169) and filtertext would filter the reportitems that contain 169
 
Is it possible to upload small sample? Maybe there's another way Wink
 
 
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
s.bagnatica View Drop Down
Newbie
Newbie


Joined: 05 August 2011
Location: Italy
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote s.bagnatica Quote  Post ReplyReply Direct Link To This Post Posted: 05 August 2011 at 8:08am
We are using the grid.FilterText properties, in Codejock.ReportControl.v15.0.2.

We noticed that this filter does not use data of grouped columns. Here an example:



Now I filter with value "169", and no rows are displayed:



There is any way to filter also considering grouped columns? Should you implement this feature?

Thank you
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.125 seconds.