Codejock Developer Community : [SOLVED] Navigator.MoveToRow does not work http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 00:49:24 +0000 Mon, 16 Aug 2010 03:16:50 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=17107 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[[SOLVED] Navigator.MoveToRow does not work : Nice one Aaron!!!Using your...]]> http://forum.codejock.com/forum_posts.asp?TID=17107&PID=59778&title=solved-navigator-movetorow-does-not-work#59778 Author: Xander75
Subject: 17107
Posted: 16 August 2010 at 3:16am

Nice one Aaron!!!

Using your suggestion I first set the grid to scroll to the last record in the grid before scrolling to the row in question. This allows the record to be at the top of the ReportControl, tested this with expanding the tree and all works perfectly.


        With rpcGrid
            ' Find the Last Row
            Set LastRow = .Rows.FindRowInTree(LastRecord)
            .Navigator.MoveToRow LastRow.Index, False, True
            
            ' Find the First Forecasted Product Row
            Set Row = .Rows.FindRowInTree(Record)
            .Navigator.MoveToRow Row.Index, False, True
            
            .Populate
            .SelectedRows.DeleteAll
            .ReDraw
        End With


I must admit... I tried this late on Friday before I got your reply, but it was late in the day and all I could think about was the weekend!!! lol

Thanks for the help.

]]> Mon, 16 Aug 2010 03:16:50 +0000 http://forum.codejock.com/forum_posts.asp?TID=17107&PID=59778&title=solved-navigator-movetorow-does-not-work#59778 <![CDATA[[SOLVED] Navigator.MoveToRow does not work : Hi, Try this instead: Dim...]]> http://forum.codejock.com/forum_posts.asp?TID=17107&PID=59764&title=solved-navigator-movetorow-does-not-work#59764 Author: Aaron
Subject: 17107
Posted: 13 August 2010 at 10:45am

Hi,
 
Try this instead:
 
Dim rowToFind As ReportRow
   
    Set rowToFind = Me.wndReportControl.Rows.FindRowInTree(Me.wndReportControl.Records(INDEX_OF_RECORD))
          rowToFind.EnsureVisible
    
OR
   
    Set rowToFind = Me.wndReportControl.Rows.FindRowInTree(Me.wndReportControl.Records(INDEX_OF_RECORD))
    Me.wndReportControl.Navigator.MoveToRow rowToFind.Index
 
 
]]> Fri, 13 Aug 2010 10:45:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=17107&PID=59764&title=solved-navigator-movetorow-does-not-work#59764 <![CDATA[[SOLVED] Navigator.MoveToRow does not work : Subject Continued:...]]> http://forum.codejock.com/forum_posts.asp?TID=17107&PID=59760&title=solved-navigator-movetorow-does-not-work#59760 Author: Xander75
Subject: 17107
Posted: 13 August 2010 at 7:39am

Subject Continued: "with the ReportControl using Grouping Column and Tree Column..."

Hi,

I have a requirement to scroll a ReportControl that has both a Grouping Column and a Tree Column to a specific row.

Using either "EnsureVisible" or "Navigator.MoveToRow" does work kind of! However the Grouping row seems to knock this out slightly and the moment I expand a few tree columns then try and use either of these to scroll to the row in question it does not scroll to the correct row!

To help you understand I have attached an image of my application below. In the image below you can clearly see the Grouping column and Tree columns are used and that the Highlighted Row is the row I have tried to scroll to. However this has scrolled to the wrong row due to the Grouping row heights I believe. If I then scroll up further and expand a few tree columns and then move to the row the result is worse!!!

I am using the Statusbar "Forecast Products" pane as a button to focus the users attention to the Forecasted Products in the ReportControl, however this functionality can't work using the "EnsureVisible" or "Navigator.MoveToRow" in combination with the Grouping Column and a Tree Column.



Is there any method other than these two to scroll programmatically to a row?

Thanks.
]]> Fri, 13 Aug 2010 07:39:28 +0000 http://forum.codejock.com/forum_posts.asp?TID=17107&PID=59760&title=solved-navigator-movetorow-does-not-work#59760