Codejock Developer Community : Looping through RecordItems http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 27 May 2026 19:55:05 +0000 Fri, 08 Jul 2005 14:02:14 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=2540 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Looping through RecordItems : It looks like using Columns.Count...]]> http://forum.codejock.com/forum_posts.asp?TID=2540&PID=7595&title=looping-through-recorditems#7595 Author: nighthawk
Subject: 2540
Posted: 08 July 2005 at 2:02pm

It looks like using Columns.Count will work.  Thanks.]]> Fri, 08 Jul 2005 14:02:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=2540&PID=7595&title=looping-through-recorditems#7595 <![CDATA[Looping through RecordItems : You could try using Columns.Count...]]> http://forum.codejock.com/forum_posts.asp?TID=2540&PID=7555&title=looping-through-recorditems#7555 Author: ianp
Subject: 2540
Posted: 07 July 2005 at 4:33pm

You could try using Columns.Count and Column.ItemIndex

]]> Thu, 07 Jul 2005 16:33:40 +0000 http://forum.codejock.com/forum_posts.asp?TID=2540&PID=7555&title=looping-through-recorditems#7555 <![CDATA[Looping through RecordItems : I want to loop through each...]]> http://forum.codejock.com/forum_posts.asp?TID=2540&PID=7553&title=looping-through-recorditems#7553 Author: nighthawk
Subject: 2540
Posted: 07 July 2005 at 4:13pm

I want to loop through each Record and each RecordItem on a report control.  The easiest way would be something like:

    For Each Record In ReportControl.Records
        For Each RecordItem In Record.Items
             'do something with RecordItem
        Next
    Next

Looping through the collection of records stored usingReportControl.Records works fine.  I can't however loop throughthe collection of record items because Record.Items doesn't exist!!!

An alternate way of looping through the collection of record itemswould be to just use a while loop and use an index counter to accessRecord.Item(index).  The problem with this is there is no Countmember to tell me when to stop looping through the record items.

Any ideas on the best way to do this?


Edited by nighthawk]]> Thu, 07 Jul 2005 16:13:18 +0000 http://forum.codejock.com/forum_posts.asp?TID=2540&PID=7553&title=looping-through-recorditems#7553