收到错误“子报表的数据检索失败，'Subreport1'"尝试从 Business Intelligence Studio 预览报表时 [英] Getting the error "Data retrieval failed for the subreport, 'Subreport1'" while trying to preview a report from Business Intelligence Studio

问题描述

我知道以前有人问过这个问题，但所有问题都是针对使用 C# 或 VB.NET 代码访问的报告.我的问题是我正在使用商业智能工作室构建和访问报表，我基本上是在尝试为报表添加子报表，并且我从参数中确定它们是可以的.但是，当我尝试访问包含子报表的报表时，出现错误

I know this question has been asked before, but all questions were for reports being accessed using C# or VB.NET code. My problem is that I am building and accessing the report using Business Intelligence studio, I am basically trying to add a sub report for a report, and I made sure from the parameters and they are OK. However when I try to access the report containing the subreport, I get the error

子报表Subreport1"的数据检索失败.

Data retrieval failed for the subreport, 'Subreport1'.

我也尝试删除 .data 文件，但同样的问题仍然存在.

I also tried deleting the .data files but the same problem persisted.

推荐答案

我过去也遇到过类似的问题，在我的例子中是罪魁祸首

I faced similar issue in past and in my case below were the culprit's

1. 主报表参数正在向子报表发送空值.

1. Parameter from main report is sending null value to sub report.

参数的数据类型与实际数据类型不同.

Data type of parameter were different than actual data type.

这篇关于收到错误“子报表的数据检索失败，'Subreport1'"尝试从 Business Intelligence Studio 预览报表时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！