Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to display TAB separated data in Actuate Report

Status
Not open for further replies.

shivesh

Programmer
Apr 29, 2003
2
IN
Hi ALL,

I need to display TAB separated data in Actuate report so that when these data are download in Excel format it should appear as in separate Columns.

I did tried this but when its downloaded in Excel, the data comes as enclosed within "" (double quotes) which prevents it to display in columns.

Any Suggestion, if any one has tried this before. Please Share the code or any tips.

Shivesh
 
One way to do it is to insert code into the OnRow() method of the content frame and write out a Tab separted file.

Like this:



Sub OnRow( row As AcDataRow )
Super::OnRow( row )


Dim theFile As Integer
Dim str As String
Dim s2 As String
Dim TABCHAR As String

TABCHAR = Chr$(9)

theFile = Freefile( )

Open "TEST_TAB_SEP.txt" For Append As #theFile

s2 = row.GetValue("Flavor")
str = s2 & TABCHAR

s2 = row.GetValue("Color")
str = str & s2 & TABCHAR

s2 = row.GetValue("Ingreds")
str = str & s2

Print #theFile, str

Close #theFile

End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top