![]() |
Determining Which Rows are NOT visible |
Post Reply ![]() |
Author | ||
jcollier ![]() Senior Member ![]() Joined: 15 February 2006 Status: Offline Points: 250 |
![]() ![]() ![]() ![]() ![]() Posted: 03 October 2006 at 4:38pm |
|
How would I loop through the rows to set rows that are not visible to visible?
When I do the following I get Invalid Procedure Call after it gets to the count of visible rows. For i = 0 To rpt.Records.count - 1 If rpt.Rows(i).GroupRow = False Then rpt.Rows(i).Record.Visible = True End If Next i In this case, rpt.records.count = 77. The number of visible rows when I run this is 14. So, when i gets to 14, it gives the error. |
||
![]() |
||
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
|
Obviously, you have to iterate Records, not Rows. Like below:
If you need to check some value on the corresponding Row, use FindRow method:
-- WBR, Serge |
||
![]() |
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 |