Geek Answers Handbook

Using a shared dataset in a subtitle

Hello!

I am using SSRS with MS SQL Server 2008 R2, which has a new feature for supporting shared datasets.

First, I created my common dataset and made sure that it works correctly and has a good connection. It did a great job.

Secondly, I created a new report (let's call it "ReportSub"), and I used it with a shared dataset. The report works great.

Thirdly, I created another report (let the call be “ReportMain”), and I placed the report object in the report and linked it to “ReportSub”. Does not work. Instead, I get this error:

Could not find data for the ReportSub subreport located at: / ReportSub. Please check the log files for more information.

Any ideas on what could be the problem? It will work if I use the built-in dataset, but I really need to use a common dataset.

Thanks,

+7
ssrs-2008
source share
4 answers

It is currently not possible to view a preliminary report with a common data source / dataset in BIDS.

Link: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/74e51434-1d14-4fb1-9b1c-1a394c187b2f

+7
source share

I had this problem only for "preview". As soon as I deploy it to the Reporting Service server, it starts working fine.

+5
source share

I had the same problem while viewing my MainReport. The SubReport preview works fine, but in the MainReport preview the error “Failed to get data for sub-report” appears.

The solution does not use a common dataset in SubReport, but the built-in daaset!

I also noticed that some changes in SubReport are not propagated to MainReport. So I had to close the project again and again.

+1
source share

I ran into this problem even after deployment. I found that I am requesting credentials for data sources in the subtitle, but not in the main report.

After I made them the same (request for credentials or set them to use the provided credentials), the problem disappeared and I was able to view.

0
source share

More articles:


All Articles