dataset包含字段的定义,返回的结果中缺少该字段

4dc9hkyq  于 2021-08-13  发布在  Java
关注(0)|答案(1)|浏览(474)

当我运行ssrs时,要查看表,一个字段缺少数据并且为空,我会看到以下消息:
警告[rsmissingfieldindataset]数据集“ds\u gldetail”包含字段“associated\u invoice\u description”的定义。数据源返回的结果集中缺少此字段。
警告[rserroradingdatasetfield]数据集“ds\u gldetail”包含字段“associated\u invoice\u description”的定义。数据扩展在读取字段时返回错误。位置10处的字段没有数据。
我正在使用visualstudio编辑ssrs报告。
我插入了两个新字段,
一是客户名称
一是发票说明。
我的sql查询在sql server中正确运行。查询可以显示整个数据。
有人能告诉我该怎么做吗?

SELECT
GLD.PA_gldetailId AS 'GL Detail Transaction GUID',
GLD.PA_transactiondate AS 'GL Detail Transaction Date',
GLD.PA_batchnumber AS 'GL Detail Transaction Batch Number',
GLDCoA.PA_AccountNumber As 'GL Detail Transaction Target GL',
GLD.PA_amountdebit AS 'GL Detail Transaction Debit',
GLD.PA_amountcredit AS 'GL Detail Transaction Credit',
I.InvoiceNumber AS 'Associated Invoice Number',
I.PA_InvoiceDate AS 'Associated Invoice Date',
I.CustomeridName AS 'Assocoated Invoice Customer',
Invde.Description AS 'Asscoiated Invoice Description',
I.TotalLineItemAmount 'Associated Invoice Current Net',
I.TotalTax AS 'Associated Invoice Current Tax',
I.TotalAmount AS 'Associated Invoice Current Gross'
FROM
PA_gldetail AS GLD
LEFT OUTER JOIN Invoice AS I ON I.InvoiceId = GLD.pa_invoiceid
LEFT OUTER JOIN PA_ChartofAccounts AS GLDCoA ON GLD.pa_glaccountid = GLDCoA.PA_ChartofAccountsId
LEFT OUTER JOIN InvoiceDetail AS Invde ON Invde.InvoiceId = GLD.pa_invoiceid
WHERE
YEAR(GLD.PA_transactiondate) = @param_Year
AND MONTH(GLD.PA_transactiondate) = @param_Month
ORDER BY
3 ASC, 2 ASC, 4 ASC
SELECT
DISTINCT YEAR(pa_transactiondate) AS Year
FROM
PA_GLDetail
WHERE
StateCode = 0
ORDER BY
1 ASC
SELECT
DISTINCT MONTH(pa_transactiondate) AS MonthValue,
CASE
WHEN MONTH(pa_transactiondate) = 1 THEN 'January'
WHEN MONTH(pa_transactiondate)= 2 THEN 'February'
WHEN MONTH(pa_transactiondate)= 3 THEN 'March'
WHEN MONTH(pa_transactiondate)= 4 THEN 'April'
WHEN MONTH(pa_transactiondate)= 5 THEN 'May'
WHEN MONTH(pa_transactiondate)= 6 THEN 'June'
WHEN MONTH(pa_transactiondate)= 7 THEN 'July'
WHEN MONTH(pa_transactiondate)= 8 THEN 'August'
WHEN MONTH(pa_transactiondate)= 9 THEN 'September'
WHEN MONTH(pa_transactiondate)= 10 THEN 'October'
WHEN MONTH(pa_transactiondate)= 11 THEN 'November'
WHEN MONTH(pa_transactiondate)= 12 THEN 'December'
ELSE 'ERROR'
END AS MonthLabel
FROM
PA_GLDetail
WHERE
StateCode = 0
AND YEAR(pa_transactiondate) = @param_Year
ORDER BY
1 ASC
svujldwt

svujldwt1#

双击“报表数据”面板中的数据集,然后单击刷新字段。听起来像是数据集查询已更新,但字段尚未刷新以显示更改。

相关问题