Skip to Content
0
Former Member
Dec 14, 2010 at 08:03 AM

CRXI and VB6 - Excel optionsu200F

33 Views

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