I'm having an issue when running my union report. Basically I'm using two data containers - 1 for customer sales, 1 for vendor purchases. I wanted to capture a start/end date upon running the report and use those values to filter the Invoice date on the sales side, and the receipt date on the purchases side.
I added pass through variables to each of the data containers (for both start/end date) and assigned them the variable names @STARTDATE@ and @ENDDATE@.
I added start/end date parameters to the bottom most union sub report, then set filters on both union sub reports for:
Sales
Invoice Date >= @STARTDATE@
Invoice Date <= @ENDDATE@
Purchases
Receipt Date >= @STARTDATE@
Receipt Date <= @ENDDATE@
When running the union report, I'm prompted for the start/end dates as expected, but upon clicking 'OK', I'm getting the below error. Anyone know where I went wrong with this?
Description : Invalid sql query near 2020-01-01'}
AND "AR_InvoiceHistoryHeader"."InvoiceDate" <= @ENDDATE@
)
Number : -2146233088
Source :
Driver Error : Unknown
SQL State : Unknown