I have create a report to track our purchase orders delivery performance (see the code below). The only issue is that I cannot add a filtration by vendor name into selection criteria. SELECT
PurchaseOrder."DocNum" AS "Purchase Order Number",
...
/**SELECT FROM [OPDN] T0 **/
DECLARE @DocDateFrom AS DATETIME
/* WHERE */
SET @DocDateFrom = /* T0."DocDate" */ '[%0]'
/**SELECT FROM [OPDN] T1 **/
DECLARE @DocDateTo AS DATETIME
/* WHERE */
SET @DocDateTo = /* T1."DocDate" */ '[%1]'
/**SELECT FROM...
Hi Johan,I did as you suggested and got the following error after selecting any option from Drop Down field:1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "DECLARE": line 2 col 1 'Us...
Hi LoHa,This seems to help a little. I have changed the whole query to use T0, T1, T2, T3 and started using declarations at the top. The selection criteria window started showing a Customer/Vendor Drop Down field but after I do the selection I get th...
