深圳智汇创想科技有限公司

原因：原本报表设计没有设计预览功能，需重新配置自定义报表配置。

重新配置SQL如下：

SELECT
 *
FROM
  (
    SELECT
      A.FinancialEventGroupId AS '报告ID',
      C.ID  AS '渠道ID',
      C.OrderSourceName AS '渠道名称',
      A.OriginalTotalAmount AS '划款金额',
      A.OriginalTotaCurrency AS '划款币种',
      B.CurrencyAmount AS '明细金额合计',
      (ABS(A.OriginalTotalAmount) - ABS(B.CurrencyAmount)) * D.ExchangeRMB AS '差值',
  'RMB' AS '差值币种',
      A.FinancialEventGroupStart AS '报告周期开始时间',
      A.FinancialEventGroupEnd AS '报告周期结束时间'
    FROM (
SELECT * 
FROM
  RB_Amazon_ListFinancialEventGroups(NOLOCK)
WHERE
  FinancialEventGroupStart <= @EndTime
  AND FinancialEventGroupEnd >= @StartTime
  AND CustomerID = @CustomerID
  AND FundTransferStatus = 'Succeeded'
) A LEFT JOIN (
    SELECT
      A.CustomerID,
      A.FinancesReportID,
      SUM(ISNULL(A.CurrencyAmount, 0)) AS CurrencyAmount
    FROM
      RB_Amazon_ListFinancialEvents A WITH (
        NOLOCK,
        INDEX = IX_RB_Amazon_ListFinancialEvents_CustomerID_FinancesReportID_EventDetailType
      )
      INNER JOIN (
SELECT * 
FROM
  RB_Amazon_ListFinancialEventGroups(NOLOCK)
WHERE
  FinancialEventGroupStart <= @EndTime
  AND FinancialEventGroupEnd >= @StartTime
  AND CustomerID = @CustomerID
  AND FundTransferStatus = 'Succeeded'
  ) B ON A.FinancesReportID=B.FinancialEventGroupId
    WHERE
      A.CustomerID = 1
  AND CONCAT(A.FinancialEventType,'_',A.EventItemType)<>'DebtRecoveryEvents_DebtPayment'
  AND A.EventItemType<>'TotalAmount'
    GROUP BY
      A.CustomerID,
      A.FinancesReportID
  ) B ON A.CustomerID = B.CustomerID
  AND A.FinancialEventGroupId = B.FinancesReportID
  LEFT JOIN RB_OrderSource C(NOLOCK) ON C.ID = ISNULL(A.OrderSourceID, A.AddOrderSourceID)
  LEFT JOIN dbo.E_Currency D(NOLOCK) ON A.OriginalTotaCurrency=D.Currency
WHERE
  A.OriginalTotalAmount <> B.CurrencyAmount
  AND (ABS(A.OriginalTotalAmount - B.CurrencyAmount)*D.ExchangeRMB) > @SholdValue
) T

已验证