'"Data retrieval failed for the subreport" report created in VS 2017
I have created Main report and sub-report in Visual Studio 2017.
Sub-report "preview" works fine with dataset based on stored procedure.
Main report has a stored procedure that brings all "project numbers" which are the parameters for sub-reports. Both stored datasets are based on the same(shared) datasource which has specific credentials for the database. Both datasets have the same name. Preview of Main report brings the correct number of sub-reports, but instead of data, displays "Data retrieval failed for the subreport" for both of them.
Now the worst part: I'm running windows 11 and there is NO Log files for ReportServices in the directory everybody is pointing to. The path looks like this "C:\Program Files\Microsoft SQL Server\80 or 90 or 110 or 120 or 130 or 150 or ClientSDK" There is no ReportingServices Folder on my hard drive. So I do not know WHAT causes the error.
Thank you.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|