Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - VisibleRows in Report
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

VisibleRows in Report

 Post Reply Post Reply
Author
Message
wismerhill View Drop Down
Newbie
Newbie


Joined: 16 May 2008
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote wismerhill Quote  Post ReplyReply Direct Link To This Post Topic: VisibleRows in Report
    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
Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192
Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post 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
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....
Back to Top
wismerhill View Drop Down
Newbie
Newbie


Joined: 16 May 2008
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote wismerhill Quote  Post ReplyReply Direct Link To This Post Posted: 23 May 2008 at 9:57am
youhou, thanks a lot.
      
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.219 seconds.