Hello, I have a problem with subreports in SSRS. I have a main report "Training" (which contains CC (Competency Center) and duration of training) that I want to add a subreport "Project" (which contains CC and a number of projects) which I drag from my project, in the list of parameters I find CCProjets that I give the value =First(Fields!Nom_CC.Value, "DataSet2") and CCFormation that I give the value =First(Fields!Nom_CC.Value, "DataSet1") But I in the preview I have instead of subreport an error that says it can not be displayed in the report. In the list of errors I have 0 errors and 2 warnings that say there are parameters required to run the report that I have not specified. I don't know what's those parameters required that I have not specified. I work in SSRS 2008. And thank you in advance

How about making them drill-through reports instead of subreports? Related article: How to: Add a Drillthrough Action on a Report (Reporting Services) A report can contain links to other reports. The report that opens when you click the link in the main report is known as a drillthrough report. Drillthrough reports must exist on the same report server as the main report, but they can be in different folders. You can add a drillthrough link to any item that has an Action property, such as a text box, an image, or data points on a chart. For more information, see the Action page topics in Report Designer F1 Help. Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM

Hi, As the warning message shows, all parameters need to be specified for the subreport. So, please first check the parameters of the report which you referred as subreport, and then ensure that all non-nullable parameters are specified in the subreport. For more information about Adding Subreports, please refer to http://msdn.microsoft.com/en-us/library/ms159837.aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.