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).
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/