Codejock Developer Community : VisibleRows in Report http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 16:33:53 +0000 Fri, 23 May 2008 09:57:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=10759 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[VisibleRows in Report : youhou, thanks a lot. ]]> http://forum.codejock.com/forum_posts.asp?TID=10759&PID=35713&title=visiblerows-in-report#35713 Author: wismerhill
Subject: 10759
Posted: 23 May 2008 at 9:57am

youhou, thanks a lot.
      
]]> Fri, 23 May 2008 09:57:10 +0000 http://forum.codejock.com/forum_posts.asp?TID=10759&PID=35713&title=visiblerows-in-report#35713 <![CDATA[VisibleRows in Report : Hi, Yes it is possible. You...]]> http://forum.codejock.com/forum_posts.asp?TID=10759&PID=35710&title=visiblerows-in-report#35710 Author: Aaron
Subject: 10759
Posted: 23 May 2008 at 9:17am

Hi,
 
Yes it is possible. You could do it like this:
 
Private Function GetOnlyVisibleRows()
    Dim firstRow As Long
    Dim lastRow As Long
    Dim i As Long
   
    wndReportControlFiles.Navigator.MoveFirstVisibleRow
    firstRow = wndReportControlFiles.FocusedRow.Index
    wndReportControlFiles.Navigator.MoveLastVisibleRow
    lastRow = wndReportControlFiles.FocusedRow.Index
   
    For i = firstRow To lastRow
        MsgBox wndReportControlFiles.Rows(i).record(0).Caption '' reference of the record, loop through recorditems if necessary
    Next i
End Function
]]> Fri, 23 May 2008 09:17:39 +0000 http://forum.codejock.com/forum_posts.asp?TID=10759&PID=35710&title=visiblerows-in-report#35710 <![CDATA[VisibleRows in Report : Hello,I wonder if it&#039;s possible...]]> http://forum.codejock.com/forum_posts.asp?TID=10759&PID=35705&title=visiblerows-in-report#35705 Author: wismerhill
Subject: 10759
Posted: 23 May 2008 at 8:18am

Hello,

I wonder if it's possible to know it a row is visible or not by user

For exemple, in a report containing 1000 rows, the height of the report is able to see only 100 rows in a time.

Can i get only thoses 100 rows in order to export only the visible rows in Excel.

Regards
]]> Fri, 23 May 2008 08:18:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=10759&PID=35705&title=visiblerows-in-report#35705