Hello,
I have an SSRS report that calls a simple query. The query is trying to sum line items for A.INVC_ID which is does properly. My goal is to show, on the report, the sum of these per distinct A.CHK_NO.
Right now A.CHK_NO is repeating. What is the best way to accomplish this? The query is below. Your help is always appreciated
SELECT DISTINCT A.CHK_NO
,A.PAY_VEND_ID
,A.VCHR_NO
,A.INVC_ID
,SUM(LN_CHG_CST_AMT) AS INVC_AMT
,A.CHK_DT
,A.INVC_DT
,V.VEND_ID
,V.VEND_NAME
FROM ACH_TEMP_VENDORPAYMENTS A
INNER JOIN WEBAPP_CP.DELTEK.V_VEND V
ON V.VEND_ID = A.PAY_VEND_ID
WHERE A.PAY_VEND_ID = '1020020'
GROUP BY A.PAY_VEND_ID
,A.VCHR_NO
,A.INVC_ID
,A.CHK_NO
,A.CHK_DT
,A.CHK_AMT
,A.INVC_DT
,V.VEND_ID
,V.VEND_NAME