Custom Progress Procedure

Yahoo Archive
1
I am trying to write a custom procedure that prints out a report builder report using a date range that the user inputs.

The report needs to filter by a date range. I can't seem to figure out how to write the correct statement for it to work. This is the statement that I'm using:


rb-filter-value = "IN-RANGE(ORDERREL.REQDATE, 11/18/03,11/20/03)" +
" And ORDERREL.COMPANY = " + "'" + company + "'" +
" And ORDERREL.OPENRELEASE = " + "'" + openrelease + "'".

run aderb\_printrb(
"V:\Vantage\ud\Jasper.prl", /* RB-REPORT-LIBRARY */
"Sales Backlog w/shipper", /* RB-REPORT-NAME */
"", /* RB-DB-CONNECTION */
"O", /* RB-INCLUDE-RECORDS */
rb-filter-value, /* RB-FILTER */
"", /* RB-MEMO-FILE */
"D", /* RB-PRINT-DESTINATION */
"", /* RB-PRINTER-NAME */
"", /* RB-PRINTER-PORT */
"", /* RB-OUTPUT-FILE */
0, /* RB-NUMBER-COPIES - zero */
0, /* RB-BEGIN-PAGE - zero */
0, /* RB-END-PAGE - zero */
no, /* RB-TEST-PATTERN */
"", /* RB-WINDOW-TITLE */
yes, /* RB-DISPLAY-ERRORS */
yes, /* RB-DISPLAY-STATUS */
no, /* RB-NO-WAIT */
""). /* RB-OTHER-PARAMETERS */


Any ideas?

Thanks,

Jasper




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