VisibleRows in Report |
Post Reply |
Author | |
wismerhill
Newbie Joined: 16 May 2008 Status: Offline Points: 10 |
Post Options
Thanks(0)
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 |
|
Aaron
Senior Member Joined: 29 January 2008 Status: Offline Points: 2192 |
Post Options
Thanks(0)
|
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 |
|
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
|
wismerhill
Newbie Joined: 16 May 2008 Status: Offline Points: 10 |
Post Options
Thanks(0)
|
youhou, thanks a lot.
|
|
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 |