Dear All,
this post comes from: crxi-and-vb6---excel-optionsu200f
I created a report using CR 11.5 SP4.
I'm exporting it to excel format (see the options): http://img258.imageshack.us/i/17651605.png
This is the output: http://img84.imageshack.us/i/06122010070252.jpg
How can I obtain the same result using VB6 code?
This code I wrote I think is not correct
crxExportOptions.FormatType = ExcelExportFormat
crxExportOptions.ExcelUseFormatInDataOnly = True
crxExportOptions.ExcelAreaType = crReportHeader
crxExportOptions.ExcelMaintainColumnAlignment = True
crxExportOptions.ExcelExportPageAreaPair = crExportPageAreaPairOncePerReport
crxExportOptions.ExcelChopPageHeader = True
because the excel file output has a wrong format as shown: http://img690.imageshack.us/i/57763542.png
Which is/are other option/s to specify in order to have a correct excel output?
I also did this:
1) I removed previous installation of Merge Modules 6.4
2) I installed CRXI with SP6 installed
Doing point 1 and 2 and code you suggested in a previous post I have no solution because my output excel file still has empty columns:
http://img703.imageshack.us/img703/7116/imm.png
I have the same problem using Merge Modules 6.4 updated to SP6!
Believe me: I'm getting crazy
This is the view from design:
http://img442.imageshack.us/img442/5083/88263870.png
This is from preview:
http://img253.imageshack.us/img253/2024/24420726.png
I checked on preview section and my report has no fields to be delete as you can see!
I think I'm missing some options to set via VB6 code...
Thank...a lot if you solve my problem :-P
Help me
Regards