Report Builder export question

Yahoo Archive
1
Tricia,
Use Crystal Reports if you have it. Export to a Excel file.
2
OK...I've created a report for all the ship-to addresses in the system.
Sales Dept would like it in an Excel spreadsheet. I'm having problems
exporting it to Excel. When I choose the Export command from the Report
drop-down, it doesn't keep the "columns" over in Excel. If I choose
Fixed-Length, it "blends" columns. I can't utilize Delimited because the
only "option" I can think of is "space" and that also messes up my columns.
Any suggestions???????

TIA!!

Tricia Simon, Controller
Riten Industries, Inc.
800-338-0027, ext. 2205
3
Tricia, You will most likely have to add a delimiter field
between each column. Try a comma, semi-colon, >, etc.
I frequently have two reports one for viewing
another for exporting with EXPORT added to the report name.


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Tuesday, March 25, 2003 8:37 AM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder export question

OK...I've created a report for all the ship-to addresses in the system.
Sales Dept would like it in an Excel spreadsheet. I'm having problems
exporting it to Excel. When I choose the Export command from the Report
drop-down, it doesn't keep the "columns" over in Excel. If I choose
Fixed-Length, it "blends" columns. I can't utilize Delimited because the
only "option" I can think of is "space" and that also messes up my columns.
Any suggestions???????

TIA!!

Tricia Simon, Controller
Riten Industries, Inc.
800-338-0027, ext. 2205



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
I place a unique character at the beginning of each field such as an "@" or
a "#" and then I use that as the delimiter when importing the text file into
excel. Works fine.

Bob Goss
BC Instruments

-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Tuesday, March 25, 2003 9:37 AM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder export question

OK...I've created a report for all the ship-to addresses in the system.
Sales Dept would like it in an Excel spreadsheet. I'm having problems
exporting it to Excel. When I choose the Export command from the Report
drop-down, it doesn't keep the "columns" over in Excel. If I choose
Fixed-Length, it "blends" columns. I can't utilize Delimited because the
only "option" I can think of is "space" and that also messes up my columns.
Any suggestions???????

TIA!!

Tricia Simon, Controller
Riten Industries, Inc.
800-338-0027, ext. 2205



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
I rarely use report builder when I need to export data because of these
issues. You can use the export utility, crystal reports, or ODBC with Excel
or access to get the data into excel in a nice, clean format. However, if
you want to use report builder, here's what I've done in the past. Make a
copy of the report and between each field, enter a ~. Merge left all the
fields. Delete everything from your report (all header's, page footers,
etc.). Then after you export it, when you pull it into excel, ~ will be the
delimiter. Comes in relatively clean like this.



[Non-text portions of this message have been removed]
6
Tricia,
One method others have used is to embedd a special character in the
report between each column. For instance, use the | (shift of the \ key).
Then you can use that character when importing to Excel as the column
delimiter.

Troy Funte
Liberty Electronics


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Tuesday, March 25, 2003 9:37 AM
To: Vantage One-List (E-mail)
Subject: [Vantage] Report Builder export question


OK...I've created a report for all the ship-to addresses in the system.
Sales Dept would like it in an Excel spreadsheet. I'm having problems
exporting it to Excel. When I choose the Export command from the Report
drop-down, it doesn't keep the "columns" over in Excel. If I choose
Fixed-Length, it "blends" columns. I can't utilize Delimited because the
only "option" I can think of is "space" and that also messes up my columns.
Any suggestions???????

TIA!!

Tricia Simon, Controller
Riten Industries, Inc.
800-338-0027, ext. 2205



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/