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.
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.
Figure 1 - Main report and subreport in VS
Best answer by Mark JongelingView original