Report Builder

banguero

New Member
Does any one knows how could I export the data from a report (Done in Rep. Builder) into a text file, but I want the data to be comma delimeted.

I know that this statement:
RUN aderb\\_prntrb2(
\"C:\\send\\print-text\\test.prl\", /* RB-REPORT-LIBRARY */
\"report\", /* RB-REPORT-NAME */
\"-db e:\\capsdb\\dev\\caps\\caps -1\", /* RB-DB-CONNECTION */
\"O\", /* RB-INCLUDE-RECORDS - letter O */
\"\", /* RB-FILTER */
\"\", /* RB-MEMO-FILE */
\"A\", /* RB-PRINT-DESTINATION */
session:printer-name, /* RB-PRINTER-NAME */
\"\", /* RB-PRINTER-PORT */
\"C:\\send\\print-text\\test.TXT\", /* RB-OUTPUT-FILE */
0, /* RB-NUMBER-COPIES - zero */
0, /* RB-BEGIN-PAGE - zero */
0, /* RB-END-PAGE - zero */
no, /* RB-TEST-PATTERN */
\"Testing export to file\", /* RB-WINDOW-TITLE */
yes, /* RB-DISPLAY-ERRORS */
yes, /* RB-DISPLAY-STATUS */
no, /* RB-NO-WAIT */
\"\", /* RB-OTHER-PARAMETERS */
\"\").

Will output the contents of that report into \"test.TXT\":
WP PD 1554 45656 no
CC SO 4674 78971 yes
WP PD 4894 25484 no

Is there any way to output to a file but I want the data \"comma delimeted\" instead of in columns.
Like this:

WP,PD,1554,45656,no
CC,SO,4674,78971,yes
WP,PD,4894,25484,no


Thanks,
Edgar Banguero
 
Top