Codejock Developer Community : Looping through ALL rows

Looping through ALL rows : As I understood the ReportControl,...

Mon, 29 Nov 2010 05:43:45 +0000

Author: Michael S.
Subject: 17610
Posted: 29 November 2010 at 5:43am

As I understood the ReportControl, the Rows collection always represents the visible rows in the control, with sorting, filtering, etc. applied.

If you want to process all your data in the control, being it visibile or not, you have to process the Records collection including the Childs collection for every record if Childs.Count > 0. Remember, that the records aren't necessarily in the same order as the Rows. (It's a little bit like MVC.)

Looping through ALL rows : Hi Aaron. I hope they add...

Mon, 29 Nov 2010 04:03:08 +0000

Author: markmark
Subject: 17610
Posted: 29 November 2010 at 4:03am

Hi Aaron.

I hope they add the childs in the next update, would make sense to me.

Interestinly wndReportControl.SelectedRows does include childs, but only if they are expanded

Mark

Looping through ALL rows : markmark wrote:Thanks you Aaron....

Sun, 28 Nov 2010 08:40:50 +0000

Author: Aaron
Subject: 17610
Posted: 28 November 2010 at 8:40am

markmark wrote:

Thanks you Aaron.

Its a shame it can't be done!

Where AllRecords includes childs.

For Each xtremeRecord In Me.wndReportControl.AllRecords

Next xtremeRecord

[...]

Hi Mark,

First of all I didn't know that child records weren't part of Record collection because I never used parent/childs in RC. I'm glad I read your post again because I wanted to answer: just iterate Record collection instead of Row collection btw I also benefit from such questions in forum, now I know this can't be done and I definitely don't use parent records and I will stick to my own design where adding ordinary records and assigning GroupCaptions to those records which I want to group (same as parent/childs )

So, my next question to support: Why aren't childs, part of Record collection? We have HeaderRecords, FooterRecords and Records collection and none of these collections contains the childs of parent records....

I will add this to my list and see what happens...

Thanks

Looping through ALL rows : Thanks you Aaron. Its a shame...

Sun, 28 Nov 2010 08:06:34 +0000

Author: markmark
Subject: 17610
Posted: 28 November 2010 at 8:06am

Thanks you Aaron.

Its a shame it can't be done!

Where AllRecords includes childs.

For Each xtremeRecord In Me.wndReportControl.AllRecords

Next xtremeRecord

Again thanks for your help, this forum would be very dead without you!

Mark

Looping through ALL rows : Hi, You would expect that for...

Sun, 28 Nov 2010 03:16:00 +0000

Author: Aaron
Subject: 17610
Posted: 28 November 2010 at 3:16am

Hi,

You would expect that for each loop would work on records but it doesn't... Well, you could create function and loop child records recursively, something like this:

Private Function IterateReportCollection()
    Dim xtremeRecord As XtremeReportControl.ReportRecord

    For Each xtremeRecord In Me.wndReportControl.Records
        'Checking goes here
        If xtremeRecord.Childs.Count > 0 Then 'found record with child(s), so first check the child(s)
            IterateChilds xtremeRecord
        End If
    Next xtremeRecord

End Function

Private Function IterateChilds(xtremeRecordParent As XtremeReportControl.ReportRecord)

    Dim xtremeRecord As XtremeReportControl.ReportRecord

    For Each xtremeRecord In xtremeRecordParent.Childs
        'Checking goes here
        If xtremeRecord.Childs.Count > 0 Then 'found record with child(s), so first check the child(s)
            IterateChilds xtremeRecord
        End If
    Next xtremeRecord

End Function

Good luck

Looping through ALL rows : Hi Is there a nice simple...

Sat, 27 Nov 2010 09:52:44 +0000

Author: markmark
Subject: 17610
Posted: 27 November 2010 at 9:52am

Is there a nice simple way that I can loop through all the rows on the grid.

Even if there are Child items as well. or even lots of childs of child (a child is a parent item)

I note that wndReportControl.Rows.Count changes if the parent is expanded, if its not the count doesn't include the childs.

So this is simple, but no good if a parent is closed up

For lngRow = 0 To wndReportControl.Rows.Count - 1

value = value & wndReportControl.Rows.Row(lngRow).Record.Item(2).Value

This method ignores child completely

For Each rRecord In wndReportControl.Records

so you end up doing tests like,

For Each rRecordChild In rRecord.Childs

Does any one know of a better way

Many Thanks

Mark