Report Control - VisibleRows in Report

Print Page | Close Window

VisibleRows in Report

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=10759
Printed Date: 17 May 2024 at 4:16pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: VisibleRows in Report

Posted By: wismerhill
Subject: VisibleRows in Report
Date 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

Replies:

Posted By: Aaron
Date 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....

Posted By: wismerhill
Date Posted: 23 May 2008 at 9:57am

youhou, thanks a lot.