Auto Export in BO VB code help needed.

[DarronWindrunner]

Hello,

I am 'trying' to use Business Objects to automaticly export a report to a text file. I am using VB to do this programaticly. My problem lies in the fact that I cannot find the method or property to set which delimiter BO uses. It uses a little square character by default.

I have searched the SDK help file to no avail =(

Here is my code so far.

Private Sub Document_Open()

Me.DataProviders(1).SQL = "<Big load of SQL here>"
Me.Reports(1).ExportAsText ("C:\test.csv")

End Sub

I hoping something like Me.Reports(1).Delimiter = "," but I cannot find it!

Help!

 

[synapsevampire]

You might want to post the software and version you're using.

This is a Crystal Enterprise forum, which is BO Enterprise in the latest incantation.

If you want help with BO, try the BO forum.

I'd look for something other than exportastext, such as a exportasdelimited or some such (SWAG).

-k

 

[DarronWindrunner]

Thanks for your reply =)

I have discovered that the aformentioned little square was a Tab =)

So I am trying to change the way it Exports text by default as Tab delimited to Comma delimited.

I am using Business Objects 5.1.8

Thanks again