Codejock Developer Community : SOLVED: Change ReportRecordItem through code

Codejock Developer Community : SOLVED: Change ReportRecordItem through code http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 15 Apr 2026 00:03:40 +0000 Wed, 02 Jul 2008 16:23:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=11267 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[SOLVED: Change ReportRecordItem through code : Yes that is it THANK YOU ]]> http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37739&title=solved-change-reportrecorditem-through-code#37739 Author: rplp4
Subject: 11267
Posted: 02 July 2008 at 4:23pm

Yes that is it

THANK YOU

]]> Wed, 02 Jul 2008 16:23:26 +0000 http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37739&title=solved-change-reportrecorditem-through-code#37739 <![CDATA[SOLVED: Change ReportRecordItem through code : Hi, You want to loop through...]]> http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37692&title=solved-change-reportrecorditem-through-code#37692 Author: Aaron
Subject: 11267
Posted: 02 July 2008 at 1:10am

Hi,

You want to loop through the records? Why don't you say that in the first place

MSFlexGrid:

Dim i, e As Integer

For i = 1 To MSFlexGrid1.Rows - 1
    For e = 0 To MSFlexGrid1.Cols - 1
        SaveData = SaveData & MSFlexGrid1.TextMatrix(i, e) & ","
    Next e
    If MSFlexGrid1.TextMatrix(i, 4) = "1" Then
        MSFlexGrid1.TextMatrix(i, 4) = "2"
    End If
Next i

ReportControl:

    Dim recordRow As XtremeReportControl.ReportRecord
    Dim recordCol As XtremeReportControl.ReportRecordItem
    Dim SaveData As String

    For Each recordRow In wndReportControl.Records
        For Each recordCol In recordRow
            If recordRow(4).Caption = "1" Then
                recordRow(4).Caption = "2"

            End If
            SaveData = SaveData & recordRow(recordCol.Index).Caption & ","
        Next recordCol
    Next recordRow

    wndReportControl.Populate 'if changes have been made to records, update ReportControl. You must in order to see the changes

]]> Wed, 02 Jul 2008 01:10:23 +0000 http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37692&title=solved-change-reportrecorditem-through-code#37692 <![CDATA[SOLVED: Change ReportRecordItem through code : I am not sure I understand or...]]> http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37673&title=solved-change-reportrecorditem-through-code#37673 Author: rplp4
Subject: 11267
Posted: 01 July 2008 at 4:44pm

I am not sure I understand or I have not explained what I would like to do. I do not what to edit the cell with a mouse click or when it has focus. I what to make the change when a command button is clicked. The user is not entering anything in to the control.

How can I loop through the cells as in the MSFlexGrid example above?

]]> Tue, 01 Jul 2008 16:44:05 +0000 http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37673&title=solved-change-reportrecorditem-through-code#37673 <![CDATA[SOLVED: Change ReportRecordItem through code : Hi, wndReportControl.FocusSubItems...]]> http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37672&title=solved-change-reportrecorditem-through-code#37672 Author: Aaron
Subject: 11267
Posted: 01 July 2008 at 3:31pm

Hi,

wndReportControl.FocusSubItems = True > you can see which cell is focused

wndReportControl.AllowEdit = True > allow editing ReportRecordItems
wndReportControl.EditOnClick = True > single click = editmode
wndReportControl.EditOnClick = False > double click = editmode

and use the events when value changes

]]> Tue, 01 Jul 2008 15:31:01 +0000 http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37672&title=solved-change-reportrecorditem-through-code#37672 <![CDATA[SOLVED: Change ReportRecordItem through code : Thank you, but how do I use the...]]> http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37670&title=solved-change-reportrecorditem-through-code#37670 Author: rplp4
Subject: 11267
Posted: 01 July 2008 at 2:12pm

Thank you, but how do I use the events to change the cell value? It looks like the events will let me know when the user is changing a value.]]> Tue, 01 Jul 2008 14:12:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37670&title=solved-change-reportrecorditem-through-code#37670 <![CDATA[SOLVED: Change ReportRecordItem through code : Hi, Set wndReportControl.AllowEdit...]]> http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37659&title=solved-change-reportrecorditem-through-code#37659 Author: Aaron
Subject: 11267
Posted: 01 July 2008 at 10:50am

Hi,

Set wndReportControl.AllowEdit = True

and use these events to change the data

Private Sub wndReportControl_InplaceEditChanging(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem, NewValue As String, Cancel As Boolean)

End Sub

Private Sub wndReportControl_ValueChanged(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem)

End Sub

Private Sub wndReportControl_ValueChanging(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem, NewValue As Variant, Cancel As Boolean)

End Sub

]]> Tue, 01 Jul 2008 10:50:12 +0000 http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37659&title=solved-change-reportrecorditem-through-code#37659 <![CDATA[SOLVED: Change ReportRecordItem through code : I have been using MSFlexGrid and...]]> http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37656&title=solved-change-reportrecorditem-through-code#37656 Author: rplp4
Subject: 11267
Posted: 01 July 2008 at 9:44am

I have been using MSFlexGrid and would like to use the report control. I have populated the report control. I can not know how to edit a cell through code. Will you please show how I can do the same as below code with the report control.

Dim i, e As Integer

]]> Tue, 01 Jul 2008 09:44:54 +0000 http://forum.codejock.com/forum_posts.asp?TID=11267&PID=37656&title=solved-change-reportrecorditem-through-code#37656