Hi All,
I have a question about using subreports in SQL Server Reporting Services (SSRS) in Thinkwise.
Currently for testing I am using Microsoft Visual Studio (using Report Server Project) to make a simple main report with a subreport.
What I did was I made 2 reports (see Figure 1). First the MainReport.rdl and second the SubReport.rdl Then in the MainReport insert subreport item then right-click on subreport item then Subreport properties then under "Use this report as a subreport:" I select the subreport file I made earlier named SubReport.
In Software Factory in Reports I'm using for Report type "SSRS (Local)" then in File I select the MainReport.rdl. When I'm opening the report in application I get an error (see Figure 2) saying that subreport could not be found at specified location....
What I did I moved the subreport to the specified location given in the error and renamed the file from .rdl to .rdlc and got the expected result information on the subreport.
My questions:
Is that the way to work with subreports by moving reports to the specified location an renaming them to .rdlc ?
What does Thinkwise recommend is the best way to work with subreports using SSRS ?
Can the option Report Type "SSRS (Local)" in Software Factory be used when using reports containing subreports ?
What is the option Report Type SSRS (Server). Is this used when setting a SQL Reportng Services Server in native mode ? Can this option may be used for working with subreports ?
Looking for some answers. Thank you.
Kind regards,
Timothy
Figure 1 - Main report and subreport in VS
![](https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/76522388-920d-477b-87eb-762d819f5e19.png)
Figure 2 - Subreport error
![](https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/3026e8ad-7e7d-4b6d-879f-eac09f8c1e5f.png)
Best answer by Mark Jongeling
View original