时间戳

首页 > 解决方案 > 数据集包含字段的定义，返回的结果中缺少该字段

sql - 数据集包含字段的定义，返回的结果中缺少该字段

问题描述

当我运行 SSRS 以查看表格时，一个字段缺少数据且为空白，我看到以下消息：

警告 [rsMissingFieldInDataSet] 数据集“ds_GLDetail”包含字段“Associated_Invoice_Description”的定义。数据源返回的结果集中缺少该字段。

警告 [rsErrorReadingDataSetField] 数据集“ds_GLDetail”包含字段“Associated_Invoice_Description”的定义。数据扩展在读取字段期间返回错误。位置 10 的字段没有数据。

我正在使用 Visual Studio 来编辑 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

标签： sqlvisual-studioreporting-servicesdataset

解决方案

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

推荐阅读