Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - ReportControl Fieldchooser export data in 11.2 v
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ReportControl Fieldchooser export data in 11.2 v
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
msotocl View Drop Down
Groupie
Groupie


Joined: 05 March 2008
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote msotocl Quote  Post ReplyReply Direct Link To This Post Topic: ReportControl Fieldchooser export data in 11.2 v
    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
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: 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....
Back to Top
msotocl View Drop Down
Groupie
Groupie


Joined: 05 March 2008
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote msotocl Quote  Post ReplyReply Direct Link To This Post 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
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: 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....
Back to Top
msotocl View Drop Down
Groupie
Groupie


Joined: 05 March 2008
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote msotocl Quote  Post ReplyReply Direct Link To This Post Posted: 17 June 2008 at 5:48pm

Hi.

Now wor ok.
 
Thank you very much
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.141 seconds.