RB to Export to CSV file

system · December 13, 2001, 11:49am

There's a 'RUN NOW' button in my program, with preview and modify
filter options, but not yet export. I could add it if it would be
useful. Currently, you have to schedule a report for export.

If interested, source code for the first report scheduler is
available in FILES section.

Here's some of the code from the scheduler. Notice RB-Print-
Destination = "A" sets export and RB-Output-File sets file name.

Lonnie

RB-Report-name = udschd.reportname.
report-library = trim(prlpath) + "\" +
udSchd.RBLibraryFileName.
RB-Print-destination = "". RB-filter = "".
RB-Number-Copies = udschd.numcopies.
RB-Output-File = "".
RB-Include-Records = "".
IF udschd.exportdata = YES then DO:
TheRptName = RB-Report-Name.
REPEAT WHILE INDEX(TheRptName," ") > 0:
SUBSTRING(TheRptName,INDEX(TheRptName," "),1)
= "".
END.
RB-Output-File = "c:\" + TRIM(TheRptName) + ".txt".
RB-Print-Destination = "A".
END.

RB-Display-Status = YES. RB-Display-Errors = YES.

/* rb-print-destination = "d". */
RUN aderb/_printrb.p (report-library,
RB-REPORT-NAME,
RB-DB-CONNECTION,
RB-INCLUDE-RECORDS, RB-FILTER,
RB-MEMO-FILE, RB-PRINT-DESTINATION, RB-PRINTER-
NAME, RB-PRINTER-PORT,
RB-OUTPUT-FILE, RB-NUMBER-COPIES, RB-BEGIN-PAGE, RB-
END-PAGE,
RB-TEST-PATTERN, RB-WINDOW-TITLE, RB-DISPLAY-
ERRORS, RB-DISPLAY-STATUS,
RB-NO-WAIT, RB-OTHER-PARAMETERS).

--- In vantage@y..., Thad Jacobs <tjacobs@k...> wrote:
> I think this would be a command line shortcut to a progress
program. The
> progress program would automate report builder to print to a file.
>
> Haven't written code to do this yet, because I use 4GL for all my
> exports....
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Thursday, December 13, 2001 8:18 AM
> To: 'vantage@y...'
> Subject: RE: [Vantage] Re: RB to Export to CSV file
>
>
> It is run once, after month-end, on demand. So scheduling is not
an issue
> but if there is a command line interface to RB for firing off a
report and a
> switch to trigger export mode that would be really great. Or I
suppose I
> could try the scheduler to run only one time immediately if that
interface
> is easier. I suppose I should dig into the RB User Guide and learn
how to
> run reports other than from within Vantage of the RB editor. Any
> suggestions would be greatly appreciated.
> Thanks,
> -Todd
>
> -----Original Message-----
> From: lonniedrew [mailto:lonniedrew@c...]
> Sent: Thursday, December 13, 2001 9:31 AM
> To: vantage@y...
> Subject: [Vantage] Re: RB to Export to CSV file
>
>
> Yes, the scheduler I wrote will export if needed. It's in the MISC
> section. I'll be glad to answer questions regarding the program.
>
> Lonnie
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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/

system · December 10, 2001, 2:15pm

I have a report I have converted to print comma seperated fields for use by
Access. Mostly it is working OK except that when viewed in Excel it insists
on printing an almost blank row after every 66th row. On this blank row all
the regular data is way out at the right. As far as I can tell this is
related to the paper size (11") since a 15" page prints the blank rwo after
104 rows.

I am printing to Generic/Text Only and have set the "printer's" paper to be
Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if I set
the paper size to be "User Defiend" the report (and PC) hangs and I have to
end-task free my PC. If, in RB, I set the paper size to 11X17 (or whatever)
I get the blank lines mentiond preivously.

The column headings are in a "Title" band (not Page Header) so the headings
should be generated just once, and indeed are. But something is happening
every time it "thinks" it has reached the end of a page.

I am trying to avoid having the users of this report need to manually "fix"
the csv file before using it in Access. I know there are a few people
exporting from RB to CSV and was wondering what settings they use for
page/paper and/or if anyone knows what might be causing either the blank
lines or the hang when using 'User Defined"?

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.

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

system · December 10, 2001, 3:28pm

Todd,

Had the same problem myself. In report builder... Properties - Page
layout - set top and bottom margins to zero. That should do it.

-Gary

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, December 10, 2001 2:15 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB to Export to CSV file

I have a report I have converted to print comma seperated fields for use by
Access. Mostly it is working OK except that when viewed in Excel it insists
on printing an almost blank row after every 66th row. On this blank row all
the regular data is way out at the right. As far as I can tell this is
related to the paper size (11") since a 15" page prints the blank rwo after
104 rows.

I am printing to Generic/Text Only and have set the "printer's" paper to be
Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if I set
the paper size to be "User Defiend" the report (and PC) hangs and I have to
end-task free my PC. If, in RB, I set the paper size to 11X17 (or whatever)
I get the blank lines mentiond preivously.

The column headings are in a "Title" band (not Page Header) so the headings
should be generated just once, and indeed are. But something is happening
every time it "thinks" it has reached the end of a page.

I am trying to avoid having the users of this report need to manually "fix"
the csv file before using it in Access. I know there are a few people
exporting from RB to CSV and was wondering what settings they use for
page/paper and/or if anyone knows what might be causing either the blank
lines or the hang when using 'User Defined"?

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.

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

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/

system · December 11, 2001, 10:49am

Todd
I use the Report/Export for my CSV's. Everything merged left EXCEPT
the first quotation mark in the row. Remove page footers and headers.
Set all page margins to zero. If I have very long lines, I set the
font size to 4 and use a narrow font to fit in the 25 in maximum RB
has.

On 10 Dec 2001 at 13:15, Todd Caughey wrote:

> I have a report I have converted to print comma seperated fields for
> use by
> Access. Mostly it is working OK except that when viewed in Excel it
> insists
> on printing an almost blank row after every 66th row. On this blank
> row all
> the regular data is way out at the right. As far as I can tell this
> is
> related to the paper size (11") since a 15" page prints the blank rwo
> after
> 104 rows.
>
> I am printing to Generic/Text Only and have set the "printer's" paper
> to be
> Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if
> I set
> the paper size to be "User Defiend" the report (and PC) hangs and I
> have to
> end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> whatever)
> I get the blank lines mentiond preivously.
>
> The column headings are in a "Title" band (not Page Header) so the
> headings
> should be generated just once, and indeed are. But something is
> happening
> every time it "thinks" it has reached the end of a page.
>
> I am trying to avoid having the users of this report need to manually
> "fix"
> the csv file before using it in Access. I know there are a few people
> exporting from RB to CSV and was wondering what settings they use for
> page/paper and/or if anyone knows what might be causing either the
> blank
> lines or the hang when using 'User Defined"?
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

system · December 11, 2001, 1:48pm

Thanks for the suggestions (everyone else too). I had already had no
header/footers and margins have always been zero. I have already tried
Merge Left. Not sure what you are refering to about a quotation mark in the
row. Nothing I am printing has a quote mark. Maybe I need to include these
in the two strings I am printing (cust name and sales rep name) to help
Excel or Access know they are strings, although they seem to work OK as is.
I have not figured out how to set font to other than Roman 10cpi when
printing to Generic/Text Only printer. It does not allow any other choice.
I have tried other printer types but this inserts printer commands into the
file being written to which Excel (and probably Access) chokes on.

I have another RB report writing to file which works great. It sets the
paper size to 'User Defined". But in this new export when set this way it
print-previews fine but when writing to file it halts every time at record
260 on page 1 and freezes. I have left it over lunch with no result (print
preview takes 2 minutes altogether). I can fit everything in on a paper
size of 11x17 but this results in the funny breaks mentioned earlier, every
66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches X 6 = 66).
And even then it prints the data for the next line immediately to the right
of the last line printed before the blank line. The only time everything
print previews on one very long page is with User Defined paper set. Print
preview does not offer the option to print current page if printing to a
file.

If I set the Genreic/Text Only printer paper size to Custom and 11'W X 20'H
the breaks change to every 120 rows (20 X 6). I have experimented with the
height settings and anything over 24" causes RB to hang. Various settings
result in various records being selected before it hangs.

I have also tried setting the Generic/Text only printer to print to LPT1
(which RB print settings override to print to file) but with same results as
above.

I am beginning to think I have a faulty Generic/Text Only printer driver
(dated 1995, runnig on Win98se). At this point is sounds like everyone else
can make this work and I am doing all the same settings so I am going to
assume it is something else specific to my PC. If someone has a flash of
insight on this let me know otherwise I'll keep trying things and let
everyone know what eventually works, if anything. Thanks.

-Todd C.

-----Original Message-----
From: Russ Dover [mailto:rdover@...]
Sent: Tuesday, December 11, 2001 9:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd
I use the Report/Export for my CSV's. Everything merged left EXCEPT
the first quotation mark in the row. Remove page footers and headers.
Set all page margins to zero. If I have very long lines, I set the
font size to 4 and use a narrow font to fit in the 25 in maximum RB
has.

On 10 Dec 2001 at 13:15, Todd Caughey wrote:

> I have a report I have converted to print comma seperated fields for
> use by
> Access. Mostly it is working OK except that when viewed in Excel it
> insists
> on printing an almost blank row after every 66th row. On this blank
> row all
> the regular data is way out at the right. As far as I can tell this
> is
> related to the paper size (11") since a 15" page prints the blank rwo
> after
> 104 rows.
>
> I am printing to Generic/Text Only and have set the "printer's" paper
> to be
> Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if
> I set
> the paper size to be "User Defiend" the report (and PC) hangs and I
> have to
> end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> whatever)
> I get the blank lines mentiond preivously.
>
> The column headings are in a "Title" band (not Page Header) so the
> headings
> should be generated just once, and indeed are. But something is
> happening
> every time it "thinks" it has reached the end of a page.
>
> I am trying to avoid having the users of this report need to manually
> "fix"
> the csv file before using it in Access. I know there are a few people
> exporting from RB to CSV and was wondering what settings they use for
> page/paper and/or if anyone knows what might be causing either the
> blank
> lines or the hang when using 'User Defined"?
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
83:HM/A=879172/R=0/*http://www.fastweb.com/ib/yahoo-75f>

<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
l/S=1705007183:HM/A=879172/rand=161752017>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · December 12, 2001, 4:15pm

Todd,
Are you using the RB Export feature or "printing" to a text file via the
Generic/Text print driver? Sounds to me you are printing. Try the Export
feature instead -->Report/Export) menu. You specify the path/filename.
Also select to perform Carriage Return "Once per band". All the other
suggestions you have tried in combination with Export should yield a file
that Excel likes. One other issue could be embedded commas in the data you
export - they will be seen by Excel as field seperators unless you Quote the
string fields - then you could have issues with the quoting character
existing in the data!
HTH
Jim Stetter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, December 11, 2001 1:48 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB to Export to CSV file

Thanks for the suggestions (everyone else too). I had already had no
header/footers and margins have always been zero. I have already tried
Merge Left. Not sure what you are refering to about a quotation mark in
the
row. Nothing I am printing has a quote mark. Maybe I need to include
these
in the two strings I am printing (cust name and sales rep name) to help
Excel or Access know they are strings, although they seem to work OK as
is.
I have not figured out how to set font to other than Roman 10cpi when
printing to Generic/Text Only printer. It does not allow any other
choice.
I have tried other printer types but this inserts printer commands into
the
file being written to which Excel (and probably Access) chokes on.

I have another RB report writing to file which works great. It sets the
paper size to 'User Defined". But in this new export when set this way it
print-previews fine but when writing to file it halts every time at record
260 on page 1 and freezes. I have left it over lunch with no result
(print
preview takes 2 minutes altogether). I can fit everything in on a paper
size of 11x17 but this results in the funny breaks mentioned earlier,
every
66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches X 6 = 66).
And even then it prints the data for the next line immediately to the
right
of the last line printed before the blank line. The only time everything
print previews on one very long page is with User Defined paper set.
Print
preview does not offer the option to print current page if printing to a
file.

If I set the Genreic/Text Only printer paper size to Custom and 11'W X
20'H
the breaks change to every 120 rows (20 X 6). I have experimented with
the
height settings and anything over 24" causes RB to hang. Various settings
result in various records being selected before it hangs.

I have also tried setting the Generic/Text only printer to print to LPT1
(which RB print settings override to print to file) but with same results
as
above.

I am beginning to think I have a faulty Generic/Text Only printer driver
(dated 1995, runnig on Win98se). At this point is sounds like everyone
else
can make this work and I am doing all the same settings so I am going to
assume it is something else specific to my PC. If someone has a flash of
insight on this let me know otherwise I'll keep trying things and let
everyone know what eventually works, if anything. Thanks.

-Todd C.

-----Original Message-----
From: Russ Dover [mailto:rdover@...]
Sent: Tuesday, December 11, 2001 9:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd
I use the Report/Export for my CSV's. Everything merged left EXCEPT
the first quotation mark in the row. Remove page footers and headers.
Set all page margins to zero. If I have very long lines, I set the
font size to 4 and use a narrow font to fit in the 25 in maximum RB
has.

On 10 Dec 2001 at 13:15, Todd Caughey wrote:

> I have a report I have converted to print comma seperated fields for
> use by
> Access. Mostly it is working OK except that when viewed in Excel it
> insists
> on printing an almost blank row after every 66th row. On this blank
> row all
> the regular data is way out at the right. As far as I can tell this
> is
> related to the paper size (11") since a 15" page prints the blank rwo
> after
> 104 rows.
>
> I am printing to Generic/Text Only and have set the "printer's" paper
> to be
> Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if
> I set
> the paper size to be "User Defiend" the report (and PC) hangs and I
> have to
> end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> whatever)
> I get the blank lines mentiond preivously.
>
> The column headings are in a "Title" band (not Page Header) so the
> headings
> should be generated just once, and indeed are. But something is
> happening
> every time it "thinks" it has reached the end of a page.
>
> I am trying to avoid having the users of this report need to manually
> "fix"
> the csv file before using it in Access. I know there are a few people
> exporting from RB to CSV and was wondering what settings they use for
> page/paper and/or if anyone knows what might be causing either the
> blank
> lines or the hang when using 'User Defined"?
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

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

system · December 12, 2001, 5:08pm

Todd
In the olden days a comma seperated values file had commas between
the values and quotes around text. I have found when importing in
Excel quotes around everything goes smoothly. My line start with a
quote and end with a quote. Between each field is a quote comma
quote. For some reason RB likes the first quote printed at position.
I have everthing else merged left. I also export to reduce printer
driver problems.

RRD

On 11 Dec 2001 at 12:48, Todd Caughey wrote:

> Thanks for the suggestions (everyone else too). I had already had no
> header/footers and margins have always been zero. I have already
> tried
> Merge Left. Not sure what you are refering to about a quotation mark
> in the
> row. Nothing I am printing has a quote mark. Maybe I need to
> include these
> in the two strings I am printing (cust name and sales rep name) to
> help
> Excel or Access know they are strings, although they seem to work OK
> as is.
> I have not figured out how to set font to other than Roman 10cpi when
> printing to Generic/Text Only printer. It does not allow any other
> choice.
> I have tried other printer types but this inserts printer commands
> into the
> file being written to which Excel (and probably Access) chokes on.
>
> I have another RB report writing to file which works great. It sets
> the
> paper size to 'User Defined". But in this new export when set this
> way it
> print-previews fine but when writing to file it halts every time at
> record
> 260 on page 1 and freezes. I have left it over lunch with no result
> (print
> preview takes 2 minutes altogether). I can fit everything in on a
> paper
> size of 11x17 but this results in the funny breaks mentioned earlier,
> every
> 66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches X 6 =
> 66).
> And even then it prints the data for the next line immediately to the
> right
> of the last line printed before the blank line. The only time
> everything
> print previews on one very long page is with User Defined paper set.
> Print
> preview does not offer the option to print current page if printing
> to a
> file.
>
> If I set the Genreic/Text Only printer paper size to Custom and 11'W
> X 20'H
> the breaks change to every 120 rows (20 X 6). I have experimented
> with the
> height settings and anything over 24" causes RB to hang. Various
> settings
> result in various records being selected before it hangs.
>
> I have also tried setting the Generic/Text only printer to print to
> LPT1
> (which RB print settings override to print to file) but with same
> results as
> above.
>
> I am beginning to think I have a faulty Generic/Text Only printer
> driver
> (dated 1995, runnig on Win98se). At this point is sounds like
> everyone else
> can make this work and I am doing all the same settings so I am going
> to
> assume it is something else specific to my PC. If someone has a
> flash of
> insight on this let me know otherwise I'll keep trying things and let
> everyone know what eventually works, if anything. Thanks.
>
> -Todd C.
>
> -----Original Message-----
> From: Russ Dover [mailto:rdover@...]
> Sent: Tuesday, December 11, 2001 9:49 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] RB to Export to CSV file
>
>
> Todd
> I use the Report/Export for my CSV's. Everything merged left EXCEPT
> the first quotation mark in the row. Remove page footers and headers.
> Set all page margins to zero. If I have very long lines, I set the
> font size to 4 and use a narrow font to fit in the 25 in maximum RB
> has.
>
>
> On 10 Dec 2001 at 13:15, Todd Caughey wrote:
>
> > I have a report I have converted to print comma seperated fields
> for
> > use by
> > Access. Mostly it is working OK except that when viewed in Excel it
> > insists
> > on printing an almost blank row after every 66th row. On this blank
> > row all
> > the regular data is way out at the right. As far as I can tell this
> > is
> > related to the paper size (11") since a 15" page prints the blank
> rwo
> > after
> > 104 rows.
> >
> > I am printing to Generic/Text Only and have set the "printer's"
> paper
> > to be
> > Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB
> if
> > I set
> > the paper size to be "User Defiend" the report (and PC) hangs and I
> > have to
> > end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> > whatever)
> > I get the blank lines mentiond preivously.
> >
> > The column headings are in a "Title" band (not Page Header) so the
> > headings
> > should be generated just once, and indeed are. But something is
> > happening
> > every time it "thinks" it has reached the end of a page.
> >
> > I am trying to avoid having the users of this report need to
> manually
> > "fix"
> > the csv file before using it in Access. I know there are a few
> people
> > exporting from RB to CSV and was wondering what settings they use
> for
> > page/paper and/or if anyone knows what might be causing either the
> > blank
> > lines or the hang when using 'User Defined"?
> >
> > Thanks,
> > -Todd Caughey
> > Harvey Vogel Mfg. Co.
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> Russ Dover
> IS Manager
> Weaver Industries, Inc.
> 717 336 7507 phone
> 717 336 4182 fax
> rdover@...
> www.weaverind.com
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17
> 050071
> 83:HM/A=879172/R=0/*http://www.fastweb.com/ib/yahoo-75f>
>
> <http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egr
> oupmai
> l/S=1705007183:HM/A=879172/rand=161752017>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

system · December 13, 2001, 9:41am

Thank you that did the trick. I think I had been ignoring Export because
way back in my early days with RB it did not do what I had wanted and then I
confused it with printing the report specs. It merged in my head as 'export
the specs". So yes, I had been trying to print to file. It now works
great. So how do I save this or put it on a Vantage menu so the users can
run it and have a file on their PC (in C:\vntgwork)? I can't find anywhere
to tell RB or the menus this should run as an export. Worst case, since
this is a trusted person in accounting that would run it, I could give him
RB access but I would rather not.

Also, I had already stripped out commas from any of the source data
(customer name for instance) using string replacement so that has not been a
problem.

Again, thank you very much.

-Todd

-----Original Message-----
From: Jim Stetter [mailto:jimstetter@...]
Sent: Wednesday, December 12, 2001 3:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB to Export to CSV file

Todd,
Are you using the RB Export feature or "printing" to a text file via the
Generic/Text print driver? Sounds to me you are printing. Try the Export
feature instead -->Report/Export) menu. You specify the path/filename.
Also select to perform Carriage Return "Once per band". All the other
suggestions you have tried in combination with Export should yield a file
that Excel likes. One other issue could be embedded commas in the data you
export - they will be seen by Excel as field seperators unless you Quote the
string fields - then you could have issues with the quoting character
existing in the data!
HTH
Jim Stetter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, December 11, 2001 1:48 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB to Export to CSV file

Thanks for the suggestions (everyone else too). I had already had no
header/footers and margins have always been zero. I have already tried
Merge Left. Not sure what you are refering to about a quotation mark in
the
row. Nothing I am printing has a quote mark. Maybe I need to include
these
in the two strings I am printing (cust name and sales rep name) to help
Excel or Access know they are strings, although they seem to work OK as
is.
I have not figured out how to set font to other than Roman 10cpi when
printing to Generic/Text Only printer. It does not allow any other
choice.
I have tried other printer types but this inserts printer commands into
the
file being written to which Excel (and probably Access) chokes on.

I have another RB report writing to file which works great. It sets the
paper size to 'User Defined". But in this new export when set this way it
print-previews fine but when writing to file it halts every time at record
260 on page 1 and freezes. I have left it over lunch with no result
(print
preview takes 2 minutes altogether). I can fit everything in on a paper
size of 11x17 but this results in the funny breaks mentioned earlier,
every
66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches X 6 = 66).
And even then it prints the data for the next line immediately to the
right
of the last line printed before the blank line. The only time everything
print previews on one very long page is with User Defined paper set.
Print
preview does not offer the option to print current page if printing to a
file.

If I set the Genreic/Text Only printer paper size to Custom and 11'W X
20'H
the breaks change to every 120 rows (20 X 6). I have experimented with
the
height settings and anything over 24" causes RB to hang. Various settings
result in various records being selected before it hangs.

I have also tried setting the Generic/Text only printer to print to LPT1
(which RB print settings override to print to file) but with same results
as
above.

I am beginning to think I have a faulty Generic/Text Only printer driver
(dated 1995, runnig on Win98se). At this point is sounds like everyone
else
can make this work and I am doing all the same settings so I am going to
assume it is something else specific to my PC. If someone has a flash of
insight on this let me know otherwise I'll keep trying things and let
everyone know what eventually works, if anything. Thanks.

-Todd C.

-----Original Message-----
From: Russ Dover [mailto:rdover@...]
Sent: Tuesday, December 11, 2001 9:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd
I use the Report/Export for my CSV's. Everything merged left EXCEPT
the first quotation mark in the row. Remove page footers and headers.
Set all page margins to zero. If I have very long lines, I set the
font size to 4 and use a narrow font to fit in the 25 in maximum RB
has.

On 10 Dec 2001 at 13:15, Todd Caughey wrote:

> I have a report I have converted to print comma seperated fields for
> use by
> Access. Mostly it is working OK except that when viewed in Excel it
> insists
> on printing an almost blank row after every 66th row. On this blank
> row all
> the regular data is way out at the right. As far as I can tell this
> is
> related to the paper size (11") since a 15" page prints the blank rwo
> after
> 104 rows.
>
> I am printing to Generic/Text Only and have set the "printer's" paper
> to be
> Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if
> I set
> the paper size to be "User Defiend" the report (and PC) hangs and I
> have to
> end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> whatever)
> I get the blank lines mentiond preivously.
>
> The column headings are in a "Title" band (not Page Header) so the
> headings
> should be generated just once, and indeed are. But something is
> happening
> every time it "thinks" it has reached the end of a page.
>
> I am trying to avoid having the users of this report need to manually
> "fix"
> the csv file before using it in Access. I know there are a few people
> exporting from RB to CSV and was wondering what settings they use for
> page/paper and/or if anyone knows what might be causing either the
> blank
> lines or the hang when using 'User Defined"?
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
83:HM/A=879173/R=0/*http://www.fastweb.com/ib/yahoo-76f>

<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
l/S=1705007183:HM/A=879173/rand=223037835>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · December 13, 2001, 9:50am

Todd,
Have you considered doing the export as a progress program which can be run from an icon or run on a schedule? If the report is fairly simple (ie. no major groupings or calulations) this can be done fairly easily. If the report is more than a couple joins and exporting details, then you're on the right track. Just thought I'd check.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Thursday, December 13, 2001 9:41 AM
Subject: RE: [Vantage] RB to Export to CSV file

Thank you that did the trick. I think I had been ignoring Export because
way back in my early days with RB it did not do what I had wanted and then I
confused it with printing the report specs. It merged in my head as 'export
the specs". So yes, I had been trying to print to file. It now works
great. So how do I save this or put it on a Vantage menu so the users can
run it and have a file on their PC (in C:\vntgwork)? I can't find anywhere
to tell RB or the menus this should run as an export. Worst case, since
this is a trusted person in accounting that would run it, I could give him
RB access but I would rather not.

Also, I had already stripped out commas from any of the source data
(customer name for instance) using string replacement so that has not been a
problem.

Again, thank you very much.

-Todd

-----Original Message-----
From: Jim Stetter [mailto:jimstetter@...]
Sent: Wednesday, December 12, 2001 3:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB to Export to CSV file

Todd,
Are you using the RB Export feature or "printing" to a text file via the
Generic/Text print driver? Sounds to me you are printing. Try the Export
feature instead -->Report/Export) menu. You specify the path/filename.
Also select to perform Carriage Return "Once per band". All the other
suggestions you have tried in combination with Export should yield a file
that Excel likes. One other issue could be embedded commas in the data you
export - they will be seen by Excel as field seperators unless you Quote the
string fields - then you could have issues with the quoting character
existing in the data!
HTH
Jim Stetter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, December 11, 2001 1:48 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB to Export to CSV file

Thanks for the suggestions (everyone else too). I had already had no
header/footers and margins have always been zero. I have already tried
Merge Left. Not sure what you are refering to about a quotation mark in
the
row. Nothing I am printing has a quote mark. Maybe I need to include
these
in the two strings I am printing (cust name and sales rep name) to help
Excel or Access know they are strings, although they seem to work OK as
is.
I have not figured out how to set font to other than Roman 10cpi when
printing to Generic/Text Only printer. It does not allow any other
choice.
I have tried other printer types but this inserts printer commands into
the
file being written to which Excel (and probably Access) chokes on.

I have another RB report writing to file which works great. It sets the
paper size to 'User Defined". But in this new export when set this way it
print-previews fine but when writing to file it halts every time at record
260 on page 1 and freezes. I have left it over lunch with no result
(print
preview takes 2 minutes altogether). I can fit everything in on a paper
size of 11x17 but this results in the funny breaks mentioned earlier,
every
66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches X 6 = 66).
And even then it prints the data for the next line immediately to the
right
of the last line printed before the blank line. The only time everything
print previews on one very long page is with User Defined paper set.
Print
preview does not offer the option to print current page if printing to a
file.

If I set the Genreic/Text Only printer paper size to Custom and 11'W X
20'H
the breaks change to every 120 rows (20 X 6). I have experimented with
the
height settings and anything over 24" causes RB to hang. Various settings
result in various records being selected before it hangs.

I have also tried setting the Generic/Text only printer to print to LPT1
(which RB print settings override to print to file) but with same results
as
above.

I am beginning to think I have a faulty Generic/Text Only printer driver
(dated 1995, runnig on Win98se). At this point is sounds like everyone
else
can make this work and I am doing all the same settings so I am going to
assume it is something else specific to my PC. If someone has a flash of
insight on this let me know otherwise I'll keep trying things and let
everyone know what eventually works, if anything. Thanks.

-Todd C.

-----Original Message-----
From: Russ Dover [mailto:rdover@...]
Sent: Tuesday, December 11, 2001 9:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd
I use the Report/Export for my CSV's. Everything merged left EXCEPT
the first quotation mark in the row. Remove page footers and headers.
Set all page margins to zero. If I have very long lines, I set the
font size to 4 and use a narrow font to fit in the 25 in maximum RB
has.

On 10 Dec 2001 at 13:15, Todd Caughey wrote:

> I have a report I have converted to print comma seperated fields for
> use by
> Access. Mostly it is working OK except that when viewed in Excel it
> insists
> on printing an almost blank row after every 66th row. On this blank
> row all
> the regular data is way out at the right. As far as I can tell this
> is
> related to the paper size (11") since a 15" page prints the blank rwo
> after
> 104 rows.
>
> I am printing to Generic/Text Only and have set the "printer's" paper
> to be
> Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if
> I set
> the paper size to be "User Defiend" the report (and PC) hangs and I
> have to
> end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> whatever)
> I get the blank lines mentiond preivously.
>
> The column headings are in a "Title" band (not Page Header) so the
> headings
> should be generated just once, and indeed are. But something is
> happening
> every time it "thinks" it has reached the end of a page.
>
> I am trying to avoid having the users of this report need to manually
> "fix"
> the csv file before using it in Access. I know there are a few people
> exporting from RB to CSV and was wondering what settings they use for
> page/paper and/or if anyone knows what might be causing either the
> blank
> lines or the hang when using 'User Defined"?
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
83:HM/A=879173/R=0/*http://www.fastweb.com/ib/yahoo-76f>

<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
l/S=1705007183:HM/A=879173/rand=223037835>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

Yahoo! Groups Sponsor

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 the Yahoo! Terms of Service.

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

system · December 13, 2001, 10:13am

I join invoice detail to head and also to sales rep 5 times (with aliases)
to report invoice line up to five times (conditional bands) in order to get
all the split commissions for the line. This is exported to Access where I
have a report to re-sort and group so I can finally get a report to give
each rep showing only their share of sales from invoices to each customer
and their commission $. So yes, it is reporting at a line level grouping
and also fairly complicated with conditional printing of lines depending on
if there are (and how many) splits. Thanks for checking.

BTW - If Epicor subtotaled the standard commissions report at the end of
each customer none of this would be necessary. Just one little simple
sub-total. Arrrgh!
-Todd

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, December 13, 2001 8:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd,
Have you considered doing the export as a progress program which can be
run from an icon or run on a schedule? If the report is fairly simple (ie.
no major groupings or calulations) this can be done fairly easily. If the
report is more than a couple joins and exporting details, then you're on the
right track. Just thought I'd check.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Thursday, December 13, 2001 9:41 AM
Subject: RE: [Vantage] RB to Export to CSV file

Thank you that did the trick. I think I had been ignoring Export because
way back in my early days with RB it did not do what I had wanted and then
I
confused it with printing the report specs. It merged in my head as
'export
the specs". So yes, I had been trying to print to file. It now works
great. So how do I save this or put it on a Vantage menu so the users can
run it and have a file on their PC (in C:\vntgwork)? I can't find
anywhere
to tell RB or the menus this should run as an export. Worst case, since
this is a trusted person in accounting that would run it, I could give him
RB access but I would rather not.

Also, I had already stripped out commas from any of the source data
(customer name for instance) using string replacement so that has not been
a
problem.

Again, thank you very much.

-Todd

-----Original Message-----
From: Jim Stetter [mailto:jimstetter@...]
Sent: Wednesday, December 12, 2001 3:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB to Export to CSV file

Todd,
Are you using the RB Export feature or "printing" to a text file via the
Generic/Text print driver? Sounds to me you are printing. Try the Export
feature instead -->Report/Export) menu. You specify the path/filename.
Also select to perform Carriage Return "Once per band". All the other
suggestions you have tried in combination with Export should yield a file
that Excel likes. One other issue could be embedded commas in the data
you
export - they will be seen by Excel as field seperators unless you Quote
the
string fields - then you could have issues with the quoting character
existing in the data!
HTH
Jim Stetter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, December 11, 2001 1:48 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB to Export to CSV file

Thanks for the suggestions (everyone else too). I had already had no
header/footers and margins have always been zero. I have already tried
Merge Left. Not sure what you are refering to about a quotation mark in
the
row. Nothing I am printing has a quote mark. Maybe I need to include
these
in the two strings I am printing (cust name and sales rep name) to help
Excel or Access know they are strings, although they seem to work OK as
is.
I have not figured out how to set font to other than Roman 10cpi when
printing to Generic/Text Only printer. It does not allow any other
choice.
I have tried other printer types but this inserts printer commands into
the
file being written to which Excel (and probably Access) chokes on.

I have another RB report writing to file which works great. It sets the
paper size to 'User Defined". But in this new export when set this way
it
print-previews fine but when writing to file it halts every time at
record
260 on page 1 and freezes. I have left it over lunch with no result
(print
preview takes 2 minutes altogether). I can fit everything in on a paper
size of 11x17 but this results in the funny breaks mentioned earlier,
every
66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches X 6 = 66).
And even then it prints the data for the next line immediately to the
right
of the last line printed before the blank line. The only time
everything
print previews on one very long page is with User Defined paper set.
Print
preview does not offer the option to print current page if printing to a
file.

If I set the Genreic/Text Only printer paper size to Custom and 11'W X
20'H
the breaks change to every 120 rows (20 X 6). I have experimented with
the
height settings and anything over 24" causes RB to hang. Various
settings
result in various records being selected before it hangs.

I have also tried setting the Generic/Text only printer to print to LPT1
(which RB print settings override to print to file) but with same
results
as
above.

I am beginning to think I have a faulty Generic/Text Only printer driver
(dated 1995, runnig on Win98se). At this point is sounds like everyone
else
can make this work and I am doing all the same settings so I am going to
assume it is something else specific to my PC. If someone has a flash
of
insight on this let me know otherwise I'll keep trying things and let
everyone know what eventually works, if anything. Thanks.

-Todd C.

-----Original Message-----
From: Russ Dover [mailto:rdover@...]
Sent: Tuesday, December 11, 2001 9:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd
I use the Report/Export for my CSV's. Everything merged left EXCEPT
the first quotation mark in the row. Remove page footers and headers.
Set all page margins to zero. If I have very long lines, I set the
font size to 4 and use a narrow font to fit in the 25 in maximum RB
has.

On 10 Dec 2001 at 13:15, Todd Caughey wrote:

> I have a report I have converted to print comma seperated fields for
> use by
> Access. Mostly it is working OK except that when viewed in Excel it
> insists
> on printing an almost blank row after every 66th row. On this blank
> row all
> the regular data is way out at the right. As far as I can tell this
> is
> related to the paper size (11") since a 15" page prints the blank rwo
> after
> 104 rows.
>
> I am printing to Generic/Text Only and have set the "printer's" paper
> to be
> Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if
> I set
> the paper size to be "User Defiend" the report (and PC) hangs and I
> have to
> end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> whatever)
> I get the blank lines mentiond preivously.
>
> The column headings are in a "Title" band (not Page Header) so the
> headings
> should be generated just once, and indeed are. But something is
> happening
> every time it "thinks" it has reached the end of a page.
>
> I am trying to avoid having the users of this report need to manually
> "fix"
> the csv file before using it in Access. I know there are a few people
> exporting from RB to CSV and was wondering what settings they use for
> page/paper and/or if anyone knows what might be causing either the
> blank
> lines or the hang when using 'User Defined"?
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
>
83:HM/A=879173/R=0/* http://www.fastweb.com/ib/yahoo-76f
<http://www.fastweb.com/ib/yahoo-76f> >

<
http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
>
l/S=1705007183:HM/A=879173/rand=223037835>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
.

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

Yahoo! Groups Sponsor

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=215839.1778785.3296727.1261774/D=egroupweb/S=17050071
83:HM/A=868539/R=0/*http://zappos.zappos.com/bin/zapposset?ref=yahoogroups2>

<http://us.adserver.yahoo.com/l?M=215839.1778785.3296727.1261774/D=egroupmai
l/S=1705007183:HM/A=868539/rand=967108350>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · December 13, 2001, 10:21am

Uh, I get the picture. I'm sure a Progress 4GL programmer could make it all work, but that wouldn't be me.

A P.S. on the scheduling part of this. I believe Mike Podlin's Scheduler for Report Builder reports will also automatically export a RB report at certain times of the day. Lonnie Drew also has a program on the efiles to schedule reports. Don't know if it will work for an export, but you may want to look into it.
If you scheduled the export daily, then the file would just be there daily (or hourly) for Access to work with, etc.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Thursday, December 13, 2001 10:12 AM
Subject: RE: [Vantage] RB to Export to CSV file

I join invoice detail to head and also to sales rep 5 times (with aliases)
to report invoice line up to five times (conditional bands) in order to get
all the split commissions for the line. This is exported to Access where I
have a report to re-sort and group so I can finally get a report to give
each rep showing only their share of sales from invoices to each customer
and their commission $. So yes, it is reporting at a line level grouping
and also fairly complicated with conditional printing of lines depending on
if there are (and how many) splits. Thanks for checking.

BTW - If Epicor subtotaled the standard commissions report at the end of
each customer none of this would be necessary. Just one little simple
sub-total. Arrrgh!
-Todd

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, December 13, 2001 8:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd,
Have you considered doing the export as a progress program which can be
run from an icon or run on a schedule? If the report is fairly simple (ie.
no major groupings or calulations) this can be done fairly easily. If the
report is more than a couple joins and exporting details, then you're on the
right track. Just thought I'd check.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Thursday, December 13, 2001 9:41 AM
Subject: RE: [Vantage] RB to Export to CSV file

Thank you that did the trick. I think I had been ignoring Export because
way back in my early days with RB it did not do what I had wanted and then
I
confused it with printing the report specs. It merged in my head as
'export
the specs". So yes, I had been trying to print to file. It now works
great. So how do I save this or put it on a Vantage menu so the users can
run it and have a file on their PC (in C:\vntgwork)? I can't find
anywhere
to tell RB or the menus this should run as an export. Worst case, since
this is a trusted person in accounting that would run it, I could give him
RB access but I would rather not.

Also, I had already stripped out commas from any of the source data
(customer name for instance) using string replacement so that has not been
a
problem.

Again, thank you very much.

-Todd

-----Original Message-----
From: Jim Stetter [mailto:jimstetter@...]
Sent: Wednesday, December 12, 2001 3:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB to Export to CSV file

Todd,
Are you using the RB Export feature or "printing" to a text file via the
Generic/Text print driver? Sounds to me you are printing. Try the Export
feature instead -->Report/Export) menu. You specify the path/filename.
Also select to perform Carriage Return "Once per band". All the other
suggestions you have tried in combination with Export should yield a file
that Excel likes. One other issue could be embedded commas in the data
you
export - they will be seen by Excel as field seperators unless you Quote
the
string fields - then you could have issues with the quoting character
existing in the data!
HTH
Jim Stetter
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, December 11, 2001 1:48 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB to Export to CSV file

Thanks for the suggestions (everyone else too). I had already had no
header/footers and margins have always been zero. I have already tried
Merge Left. Not sure what you are refering to about a quotation mark in
the
row. Nothing I am printing has a quote mark. Maybe I need to include
these
in the two strings I am printing (cust name and sales rep name) to help
Excel or Access know they are strings, although they seem to work OK as
is.
I have not figured out how to set font to other than Roman 10cpi when
printing to Generic/Text Only printer. It does not allow any other
choice.
I have tried other printer types but this inserts printer commands into
the
file being written to which Excel (and probably Access) chokes on.

I have another RB report writing to file which works great. It sets the
paper size to 'User Defined". But in this new export when set this way
it
print-previews fine but when writing to file it halts every time at
record
260 on page 1 and freezes. I have left it over lunch with no result
(print
preview takes 2 minutes altogether). I can fit everything in on a paper
size of 11x17 but this results in the funny breaks mentioned earlier,
every
66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches X 6 = 66).
And even then it prints the data for the next line immediately to the
right
of the last line printed before the blank line. The only time
everything
print previews on one very long page is with User Defined paper set.
Print
preview does not offer the option to print current page if printing to a
file.

If I set the Genreic/Text Only printer paper size to Custom and 11'W X
20'H
the breaks change to every 120 rows (20 X 6). I have experimented with
the
height settings and anything over 24" causes RB to hang. Various
settings
result in various records being selected before it hangs.

I have also tried setting the Generic/Text only printer to print to LPT1
(which RB print settings override to print to file) but with same
results
as
above.

I am beginning to think I have a faulty Generic/Text Only printer driver
(dated 1995, runnig on Win98se). At this point is sounds like everyone
else
can make this work and I am doing all the same settings so I am going to
assume it is something else specific to my PC. If someone has a flash
of
insight on this let me know otherwise I'll keep trying things and let
everyone know what eventually works, if anything. Thanks.

-Todd C.

-----Original Message-----
From: Russ Dover [mailto:rdover@...]
Sent: Tuesday, December 11, 2001 9:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB to Export to CSV file

Todd
I use the Report/Export for my CSV's. Everything merged left EXCEPT
the first quotation mark in the row. Remove page footers and headers.
Set all page margins to zero. If I have very long lines, I set the
font size to 4 and use a narrow font to fit in the 25 in maximum RB
has.

On 10 Dec 2001 at 13:15, Todd Caughey wrote:

> I have a report I have converted to print comma seperated fields for
> use by
> Access. Mostly it is working OK except that when viewed in Excel it
> insists
> on printing an almost blank row after every 66th row. On this blank
> row all
> the regular data is way out at the right. As far as I can tell this
> is
> related to the paper size (11") since a 15" page prints the blank rwo
> after
> 104 rows.
>
> I am printing to Generic/Text Only and have set the "printer's" paper
> to be
> Custom 5400X5300 and also set 'Continous Form / No Breaks". In RB if
> I set
> the paper size to be "User Defiend" the report (and PC) hangs and I
> have to
> end-task free my PC. If, in RB, I set the paper size to 11X17 (or
> whatever)
> I get the blank lines mentiond preivously.
>
> The column headings are in a "Title" band (not Page Header) so the
> headings
> should be generated just once, and indeed are. But something is
> happening
> every time it "thinks" it has reached the end of a page.
>
> I am trying to avoid having the users of this report need to manually
> "fix"
> the csv file before using it in Access. I know there are a few people
> exporting from RB to CSV and was wondering what settings they use for
> page/paper and/or if anyone knows what might be causing either the
> blank
> lines or the hang when using 'User Defined"?
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
>
83:HM/A=879173/R=0/* http://www.fastweb.com/ib/yahoo-76f
<http://www.fastweb.com/ib/yahoo-76f> >

<
http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
>
l/S=1705007183:HM/A=879173/rand=223037835>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
.

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

Yahoo! Groups Sponsor

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=215839.1778785.3296727.1261774/D=egroupweb/S=17050071
83:HM/A=868539/R=0/*http://zappos.zappos.com/bin/zapposset?ref=yahoogroups2>

<http://us.adserver.yahoo.com/l?M=215839.1778785.3296727.1261774/D=egroupmai
l/S=1705007183:HM/A=868539/rand=967108350>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

Yahoo! Groups Sponsor
ADVERTISEMENT

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 the Yahoo! Terms of Service.

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

system · December 13, 2001, 10:31am

Yes, the scheduler I wrote will export if needed. It's in the MISC
section. I'll be glad to answer questions regarding the program.

Lonnie

--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> Uh, I get the picture. I'm sure a Progress 4GL programmer could
make it all work, but that wouldn't be me.
>
> A P.S. on the scheduling part of this. I believe Mike Podlin's
Scheduler for Report Builder reports will also automatically export a
RB report at certain times of the day. Lonnie Drew also has a
program on the efiles to schedule reports. Don't know if it will work
for an export, but you may want to look into it.
> If you scheduled the export daily, then the file would just be
there daily (or hourly) for Access to work with, etc.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Todd Caughey
> To: 'vantage@y...'
> Sent: Thursday, December 13, 2001 10:12 AM
> Subject: RE: [Vantage] RB to Export to CSV file
>
>
> I join invoice detail to head and also to sales rep 5 times (with
aliases)
> to report invoice line up to five times (conditional bands) in
order to get
> all the split commissions for the line. This is exported to
Access where I
> have a report to re-sort and group so I can finally get a report
to give
> each rep showing only their share of sales from invoices to each
customer
> and their commission $. So yes, it is reporting at a line level
grouping
> and also fairly complicated with conditional printing of lines
depending on
> if there are (and how many) splits. Thanks for checking.
>
> BTW - If Epicor subtotaled the standard commissions report at the
end of
> each customer none of this would be necessary. Just one little
simple
> sub-total. Arrrgh!
> -Todd
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@e...]
> Sent: Thursday, December 13, 2001 8:49 AM
> To: vantage@y...
> Subject: Re: [Vantage] RB to Export to CSV file
>
>
> Todd,
> Have you considered doing the export as a progress program
which can be
> run from an icon or run on a schedule? If the report is fairly
simple (ie.
> no major groupings or calulations) this can be done fairly
easily. If the
> report is more than a couple joins and exporting details, then
you're on the
> right track. Just thought I'd check.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Todd Caughey
> To: 'vantage@y...'
> Sent: Thursday, December 13, 2001 9:41 AM
> Subject: RE: [Vantage] RB to Export to CSV file
>
>
> Thank you that did the trick. I think I had been ignoring
Export because
> way back in my early days with RB it did not do what I had
wanted and then
> I
> confused it with printing the report specs. It merged in my
head as
> 'export
> the specs". So yes, I had been trying to print to file. It
now works
> great. So how do I save this or put it on a Vantage menu so
the users can
> run it and have a file on their PC (in C:\vntgwork)? I can't
find
> anywhere
> to tell RB or the menus this should run as an export. Worst
case, since
> this is a trusted person in accounting that would run it, I
could give him
> RB access but I would rather not.
>
> Also, I had already stripped out commas from any of the source
data
> (customer name for instance) using string replacement so that
has not been
> a
> problem.
>
> Again, thank you very much.
>
> -Todd
>
> -----Original Message-----
> From: Jim Stetter [mailto:jimstetter@s...]
> Sent: Wednesday, December 12, 2001 3:13 PM
> To: vantage@y...
> Subject: RE: [Vantage] RB to Export to CSV file
>
>
> Todd,
> Are you using the RB Export feature or "printing" to a text
file via the
> Generic/Text print driver? Sounds to me you are printing. Try
the Export
> feature instead -->Report/Export) menu. You specify the
path/filename.
> Also select to perform Carriage Return "Once per band". All
the other
> suggestions you have tried in combination with Export should
yield a file
> that Excel likes. One other issue could be embedded commas in
the data
> you
> export - they will be seen by Excel as field seperators unless
you Quote
> the
> string fields - then you could have issues with the quoting
character
> existing in the data!
> HTH
> Jim Stetter
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Tuesday, December 11, 2001 1:48 PM
> To: 'vantage@y...'
> Subject: RE: [Vantage] RB to Export to CSV file
>
>
> Thanks for the suggestions (everyone else too). I had
already had no
> header/footers and margins have always been zero. I have
already tried
> Merge Left. Not sure what you are refering to about a
quotation mark in
> the
> row. Nothing I am printing has a quote mark. Maybe I need
to include
> these
> in the two strings I am printing (cust name and sales rep
name) to help
> Excel or Access know they are strings, although they seem to
work OK as
> is.
> I have not figured out how to set font to other than Roman
10cpi when
> printing to Generic/Text Only printer. It does not allow any
other
> choice.
> I have tried other printer types but this inserts printer
commands into
> the
> file being written to which Excel (and probably Access)
chokes on.
>
> I have another RB report writing to file which works great.
It sets the
> paper size to 'User Defined". But in this new export when
set this way
> it
> print-previews fine but when writing to file it halts every
time at
> record
> 260 on page 1 and freezes. I have left it over lunch with no
result
> (print
> preview takes 2 minutes altogether). I can fit everything in
on a paper
> size of 11x17 but this results in the funny breaks mentioned
earlier,
> every
> 66 lines (Roman 10cpi is 6 lines per inch high thus 11 inches
X 6 = 66).
> And even then it prints the data for the next line
immediately to the
> right
> of the last line printed before the blank line. The only time
> everything
> print previews on one very long page is with User Defined
paper set.
> Print
> preview does not offer the option to print current page if
printing to a
> file.
>
> If I set the Genreic/Text Only printer paper size to Custom
and 11'W X
> 20'H
> the breaks change to every 120 rows (20 X 6). I have
experimented with
> the
> height settings and anything over 24" causes RB to hang.
Various
> settings
> result in various records being selected before it hangs.
>
> I have also tried setting the Generic/Text only printer to
print to LPT1
> (which RB print settings override to print to file) but with
same
> results
> as
> above.
>
> I am beginning to think I have a faulty Generic/Text Only
printer driver
> (dated 1995, runnig on Win98se). At this point is sounds
like everyone
> else
> can make this work and I am doing all the same settings so I
am going to
> assume it is something else specific to my PC. If someone
has a flash
> of
> insight on this let me know otherwise I'll keep trying things
and let
> everyone know what eventually works, if anything. Thanks.
>
> -Todd C.
>
> -----Original Message-----
> From: Russ Dover [mailto:rdover@w...]
> Sent: Tuesday, December 11, 2001 9:49 AM
> To: vantage@y...
> Subject: Re: [Vantage] RB to Export to CSV file
>
>
> Todd
> I use the Report/Export for my CSV's. Everything merged left
EXCEPT
> the first quotation mark in the row. Remove page footers and
headers.
> Set all page margins to zero. If I have very long lines, I
set the
> font size to 4 and use a narrow font to fit in the 25 in
maximum RB
> has.
>
>
> On 10 Dec 2001 at 13:15, Todd Caughey wrote:
>
> > I have a report I have converted to print comma seperated
fields for
> > use by
> > Access. Mostly it is working OK except that when viewed in
Excel it
> > insists
> > on printing an almost blank row after every 66th row. On
this blank
> > row all
> > the regular data is way out at the right. As far as I can
tell this
> > is
> > related to the paper size (11") since a 15" page prints the
blank rwo
> > after
> > 104 rows.
> >
> > I am printing to Generic/Text Only and have set
the "printer's" paper
> > to be
> > Custom 5400X5300 and also set 'Continous Form / No Breaks".
In RB if
> > I set
> > the paper size to be "User Defiend" the report (and PC)
hangs and I
> > have to
> > end-task free my PC. If, in RB, I set the paper size to
11X17 (or
> > whatever)
> > I get the blank lines mentiond preivously.
> >
> > The column headings are in a "Title" band (not Page Header)
so the
> > headings
> > should be generated just once, and indeed are. But
something is
> > happening
> > every time it "thinks" it has reached the end of a page.
> >
> > I am trying to avoid having the users of this report need
to manually
> > "fix"
> > the csv file before using it in Access. I know there are a
few people
> > exporting from RB to CSV and was wondering what settings
they use for
> > page/paper and/or if anyone knows what might be causing
either the
> > blank
> > lines or the hang when using 'User Defined"?
> >
> > Thanks,
> > -Todd Caughey
> > Harvey Vogel Mfg. Co.
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> Russ Dover
> IS Manager
> Weaver Industries, Inc.
> 717 336 7507 phone
> 717 336 4182 fax
> rdover@w...
> www.weaverind.com
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <
>
http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=170
50071
>
<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17
050071
> >
> 83:HM/A=879173/R=0/* http://www.fastweb.com/ib/yahoo-76f
> <http://www.fastweb.com/ib/yahoo-76f> >
>
> <
> http://us.adserver.yahoo.com/l?
M=178320.1681224.3270152.1261774/D=egroupmai
> <http://us.adserver.yahoo.com/l?
M=178320.1681224.3270152.1261774/D=egroupmai
> >
> l/S=1705007183:HM/A=879173/rand=223037835>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> < http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.> >
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> < http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
> < http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links> >
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> < http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/> >
> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
>
<http://rd.yahoo.com/M=215839.1778785.3296727.1261774/D=egroupweb/S=17
050071
> 83:HM/A=868539/R=0/*http://zappos.zappos.com/bin/zapposset?
ref=yahoogroups2>
>
>
> <http://us.adserver.yahoo.com/l?
M=215839.1778785.3296727.1261774/D=egroupmai
> l/S=1705007183:HM/A=868539/rand=967108350>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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 the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]

system · December 13, 2001, 11:18am

It is run once, after month-end, on demand. So scheduling is not an issue
but if there is a command line interface to RB for firing off a report and a
switch to trigger export mode that would be really great. Or I suppose I
could try the scheduler to run only one time immediately if that interface
is easier. I suppose I should dig into the RB User Guide and learn how to
run reports other than from within Vantage of the RB editor. Any
suggestions would be greatly appreciated.
Thanks,
-Todd

-----Original Message-----
From: lonniedrew [mailto:lonniedrew@...]
Sent: Thursday, December 13, 2001 9:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: RB to Export to CSV file

Yes, the scheduler I wrote will export if needed. It's in the MISC
section. I'll be glad to answer questions regarding the program.

Lonnie

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

system · December 13, 2001, 11:22am

I think this would be a command line shortcut to a progress program. The
progress program would automate report builder to print to a file.

Haven't written code to do this yet, because I use 4GL for all my
exports....

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, December 13, 2001 8:18 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: RB to Export to CSV file

It is run once, after month-end, on demand. So scheduling is not an issue
but if there is a command line interface to RB for firing off a report and a
switch to trigger export mode that would be really great. Or I suppose I
could try the scheduler to run only one time immediately if that interface
is easier. I suppose I should dig into the RB User Guide and learn how to
run reports other than from within Vantage of the RB editor. Any
suggestions would be greatly appreciated.
Thanks,
-Todd

-----Original Message-----
From: lonniedrew [mailto:lonniedrew@...]
Sent: Thursday, December 13, 2001 9:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: RB to Export to CSV file

Yes, the scheduler I wrote will export if needed. It's in the MISC
section. I'll be glad to answer questions regarding the program.

Lonnie

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

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/

Topic		Replies	Views
Report Builder Exporting Yahoo Archive	16	408	August 22, 2001
Progress Exports (was Sales and Commission Splitting) Yahoo Archive	4	433	November 26, 2001
Print Report Builder Report from VB Form Yahoo Archive	5	344	June 12, 2002
Report Export Yahoo Archive	2	312	February 6, 2002
Progress stuck open after Export from a shortcut (was: 4GL Big Yahoo Archive	6	377	March 1, 2002

RB to Export to CSV file

Related Topics