RB Exporting

Yahoo Archive
1
One extra tip. Eliminate all Title and Page headers in the RB report before
exporting. This eliminates the need to remove the blank spaces between
pages. Can come in helpful when the report has many pages.

Rick Lane
Intelligent Systems Integration, Inc.
661B Weber Drive
Wadsworth, OH 44281
330-335-5291
Fax: 330-335-7275

"Helping business make intelligent use of technology"


-----Original Message-----
From: Plaman Dick [mailto:dick.plaman@...]
Sent: Wednesday, October 11, 2000 8:12 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB Exporting


Wendy,
write your program as you always would. Separate the fields
with a
character you won't find in your data. (if you use a comma, you will
have
trouble with numeric fields. A bracket ([) is a good choice to use as a
delimiter). Delete all band lines except the record line. File export
the file to a specified location (c:\temp\export)
When file open in excel, the export will give the file a .txt
extension,
so change the file type to 'txt'. You will have the choice of fixed or
dilimited
import in excel, specify dilimited and indicate the character you used
for the
extraction. You will have to eliminate 5 blank lines between pages in
the import
in excel. Then you can manipulate the data any way you like.
If you have any trouble understanding this procedure, e-mail me
and I
will clarify.
Hope this helps
2
Does anyone know if it is possible to export an RB report from Vantage to Excel?

Thanks!

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...



[Non-text portions of this message have been removed]
3
It can be done using the ODBC driver.
Without ODBC Driver you can still export but Excel will not format the
information into separate columns as it is Reprt Builder
Hope this helps
Sophie


-----Original Message-----
From: Wendy Pursche [SMTP:wpursche@...]
Sent: Wednesday, October 11, 2000 4:44 AM
To: Vantage egroups list
Subject: [Vantage] RB Exporting

Does anyone know if it is possible to export an RB report from
Vantage to Excel?Â

Thanks!

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...



[Non-text portions of this message have been removed]



eGroups Sponsor
http://click.egroups.com/1/9634/13/_/411782/_/971264578/

http://adimg.egroups.com/img/9634/13/_/411782/_/971264578/target(invest)
468x60.gif

We no longer allow attachments to files. To access/share Report
Files, please go to the following link:Â
http://www.egroups.com/files/vantage/
(Note:Â If this link does not work for you the first time you
try it, go to www.egroups.com, login and be sure to save your password,
choose My Groups, choose Vantage, then choose Files. If you save the
password, the link above will work the next time you try it.)
4
Wendy,
Yes. There is an export function under report on the menu. You need to give
it the path and file name where you want to save it. Make sure you have a
delimiter so Excel can parse correctly.
Chuck


-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Wednesday, October 11, 2000 6:44 AM
To: Vantage egroups list
Subject: [Vantage] RB Exporting


Does anyone know if it is possible to export an RB report from Vantage to
Excel?

Thanks!

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...



[Non-text portions of this message have been removed]



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
5
You can put delimiters between the fields and use the export option
under Report. I've done this numerous times. I usually delete the title
and headers and just send raw data through the export.
If you need other help let me know.
Kristine Pollard
Director Information Systems
American Turned Products
kpollard@... - or -
vlist@...

-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Wednesday, October 11, 2000 7:44 AM
To: Vantage egroups list
Subject: [Vantage] RB Exporting


Does anyone know if it is possible to export an RB report from Vantage
to Excel?

Thanks!

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...



[Non-text portions of this message have been removed]



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password,
the link above will work the next time you try it.)
6
Wendy, here is word-by-word instructions to a non-report builder user (I
just sent just a few weeks ago) to go in and run an export that I have set
up. Put a | between each field you have on your report builder.


Go To Report Builder---> Report/Open, then select your report.

Datebase/Filter, to change your Filter Dates (or use the kitchen funnel) OK
to save the change

Report/Export. This will default. Options should read c:\reportname.xls
and the bottom button should be checked. Click on the Export button.
(overwrite should be ok, as each time you should save it in Excel to a new
location/name)

Open Excel report at the above location

Check the first button (Delimited) then Next

Uncheck the Tab button. Check the Other button and enter | (right
above the \ key) Next, then Finish

Highlight entire Excel spreadsheet and double click to get all columns to
fit to size

Then Save-as whatever and where ever you plan to name and keep these. Copy
the page to a new page so you can begin again if necessary with the original
data.


-----Original Message-----
From: Charles Metcalf [SMTP:chuck_metcalf@...]
Sent: Wednesday, October 11, 2000 7:06 AM
To: vantage@egroups.com
Subject: RE: [Vantage] RB Exporting

Wendy,
Yes. There is an export function under report on the menu. You need
to give
it the path and file name where you want to save it. Make sure you
have a
delimiter so Excel can parse correctly.
Chuck


-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Wednesday, October 11, 2000 6:44 AM
To: Vantage egroups list
Subject: [Vantage] RB Exporting


Does anyone know if it is possible to export an RB report from
Vantage to
Excel?

Thanks!

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...



[Non-text portions of this message have been removed]



We no longer allow attachments to files. To access/share Report
Files,
please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try
it, go to
www.egroups.com, login and be sure to save your password, choose My
Groups,
choose Vantage, then choose Files. If you save the password, the
link above
will work the next time you try it.)


-------------------------- eGroups Sponsor

We no longer allow attachments to files. To access/share Report
Files, please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try
it, go to www.egroups.com, login and be sure to save your password, choose
My Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
7
Wendy,
write your program as you always would. Separate the fields
with a
character you won't find in your data. (if you use a comma, you will
have
trouble with numeric fields. A bracket ([) is a good choice to use as a
delimiter). Delete all band lines except the record line. File export
the file to a specified location (c:\temp\export)
When file open in excel, the export will give the file a .txt
extension,
so change the file type to 'txt'. You will have the choice of fixed or
dilimited
import in excel, specify dilimited and indicate the character you used
for the
extraction. You will have to eliminate 5 blank lines between pages in
the import
in excel. Then you can manipulate the data any way you like.
If you have any trouble understanding this procedure, e-mail me
and I
will clarify.
Hope this helps
8
Change the page layout margins to zero for top and bottom will help
eliminate more of the blank lines. We use the "*" as a delimiter but Dick is
right on with how it is done. It really works well after you get rid of the
page header and footers and eliminate the margins in page setup.


> -----Original Message-----
> From: Plaman Dick [mailto:dick.plaman@...]
> Sent: Wednesday, October 11, 2000 7:12 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] RB Exporting
>
>
> Wendy,
> write your program as you always would. Separate the fields
> with a
> character you won't find in your data. (if you use a comma, you will
> have
> trouble with numeric fields. A bracket ([) is a good choice to use as a
> delimiter). Delete all band lines except the record line. File export
> the file to a specified location (c:\temp\export)
> When file open in excel, the export will give the file a .txt
> extension,
> so change the file type to 'txt'. You will have the choice of fixed or
> dilimited
> import in excel, specify dilimited and indicate the character you used
> for the
> extraction. You will have to eliminate 5 blank lines between pages in
> the import
> in excel. Then you can manipulate the data any way you like.
> If you have any trouble understanding this procedure, e-mail me
> and I
> will clarify.
> Hope this helps
>
9
At 08:11 AM 10/11/2000 , you wrote:
>Separate the fields with a character you won't find in your data. (if you
>use a comma, you will have trouble with numeric fields. A bracket ([) is
>a good choice to

I've never been able to make this work as easily as some of you make it
sound! Report Builder refuses to hold evenly sized columns, and likes to
truncate long lines, as if it were printing proportionately spaced letters
on paper. Using delimiter character helps, but I'd like to use the same
report for both printing & exporting, rather than maintain two
versions. Any suggestions?

> You will have to eliminate 5 blank lines between pages in
>the import in excel.

Ah Ha! I did figure that one out. Set the page margins to zero, along
with deleting the page header bands should cure that for you. Still seems
asinine to me that an "export" throws in page breaks, tho ?!

-Wayne
10
When exporting, and putting in delimeters, make sure
you format each field to merge left, so each field is
directly next to the previous field.( ex THIS*is*exported*data)
Also, when we export, we have two reports - One that is formatted
to show the data we want, and then we take that report, add the
delimeters, take out title, summary, and other lines not needed

Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Wayne Cox" <wmc@...>
To: <vantage@egroups.com>
Sent: Wednesday, October 11, 2000 2:30 PM
Subject: RE: [Vantage] RB Exporting


> At 08:11 AM 10/11/2000 , you wrote:
> >Separate the fields with a character you won't find in your data. (if
you
> >use a comma, you will have trouble with numeric fields. A bracket ([) is
> >a good choice to
>
> I've never been able to make this work as easily as some of you make it
> sound! Report Builder refuses to hold evenly sized columns, and likes
to
> truncate long lines, as if it were printing proportionately spaced letters
> on paper. Using delimiter character helps, but I'd like to use the same
> report for both printing & exporting, rather than maintain two
> versions. Any suggestions?
>
> > You will have to eliminate 5 blank lines between pages in
> >the import in excel.
>
> Ah Ha! I did figure that one out. Set the page margins to zero, along
> with deleting the page header bands should cure that for you. Still seems
> asinine to me that an "export" throws in page breaks, tho ?!
>
> -Wayne
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
>