Report Control - ReportControl Fieldchooser export data in 11.2 v

ReportControl Fieldchooser export data in 11.2 v

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=10907
Printed Date: 20 July 2025 at 2:56am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: ReportControl Fieldchooser export data in 11.2 v

Posted By: msotocl
Subject: ReportControl Fieldchooser export data in 11.2 v
Date Posted: 04 June 2008 at 1:10pm

Hi.

I have version 11.2. and I have a problem. When trying to export to excel reportcontrol with columns in a fieldchooser, these are exported in himself order of original creation, not in the order in which they were after to have changed columns in fieldchooser.

How rto fix this

Thank you very much

Replies:

Posted By: Aaron
Date Posted: 05 June 2008 at 2:33am

Hi,

I really don't know what you are trying to do. Do you export the records?

-------------
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: msotocl
Date Posted: 09 June 2008 at 4:49pm

Hi,

yes, i try to export a data in report control to a excel file, but when change the order columns in the report, the export order to excel its incorrect

Posted By: Aaron
Date Posted: 10 June 2008 at 3:19am

Hi,

I think you mean copy to clipboard and paste in Excel, right? If not show me how you really export the records

Private Function CopySelectedRecordsToClipBoard()
    Dim selectedRow As XtremeReportControl.ReportRow
    Dim col As XtremeReportControl.ReportColumn
    Dim strClipBoard As String

    For Each selectedRow In wndReportControlFiles.SelectedRows 'or Rows
        For Each col In wndReportControlFiles.Columns
            strClipBoard = strClipBoard & selectedRow.record(col.ItemIndex).Caption & vbTab 'or Index
        Next col
        strClipBoard = strClipBoard & vbCrLf
    Next selectedRow

    Clipboard.Clear
    Clipboard.SetText strClipBoard

End Function

ItemIndex = the ID of the column when added to RC columns

Index = the index of the column in the RC (in the order as you see them)

-------------
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: msotocl
Date Posted: 17 June 2008 at 5:48pm

Hi.

Now wor ok.

Thank you very much