Codejock Developer Community : Determining Which Rows are NOT visible

Determining Which Rows are NOT visible : Obviously, you have to iterate...

Tue, 03 Oct 2006 17:45:45 +0000

Author: sserge
Subject: 5207
Posted: 03 October 2006 at 5:45pm

Obviously, you have to iterate Records, not Rows. Like below:


For i = 0 To rpt.Records.count - 1
     If rpt.Records(i).Visible = False Then
           rpt.Records(i).Record.Visible = True
      End If
Next i

If you need to check some value on the corresponding Row, use FindRow method:


Dim r As ReportRow
... then inside a loop
Set r = rpt.Rows.FindRow(rpt.Records(i))
If not r is Nothing ' mean if corresponding row exists
'' check something
End If

--
WBR,
Serge

Determining Which Rows are NOT visible : How would I loop through the rows...

Tue, 03 Oct 2006 16:38:05 +0000

Author: jcollier
Subject: 5207
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.