获取错误“数据检索失败子报表，'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屋！