Save report as dbf in OEM format in a macro 1

[lampekap]

Hi,

I´m trying to safe an impromptu report as a dBase (dbf) file in a macro.
This works fine, except for the following:
When I save a report manually as a dBase file I have the option to convert the ANSI format to the OEM format.

I´ve tried the help files and searched the forum, but I can´t find a way to do this in a macro.

Any help is very welcome.

Regards,

Martijn.

 

[griffindm]

Martijn,

I don't see anything about an option to do this via macro, either in the help files or at the Cognos support site. I would try the export with some additional option calls at the end, just to see if there is an undocumented ability to do this. Try adding an extra ",0" or ",1" (no quotes) at the end of the command as see if they do anything.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[lampekap]

Thanks Dave!

It works!

When I use:
ObjImpRep.ExportdBase ExportDir & Filename & ".dbf" , 1
instead of
ObjImpRep.ExportdBase ExportDir & Filename & ".dbf"

It saves my report in a dbf (dBase format) AND converts the ANSI format in the OEM format.

Regards,

Martijn.

 

[DoubleD]

Imagine, an undocumented Cognos "feature". I'm shocked. Good guess griffindm.

Pain is stress leaving the body.

DoubleD

 

[griffindm]

Thanks DoubleD. I've seen this before with other API calls and thought it might do the trick on this issue.

Dave G.


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com