I am trying to create a report with a subreport. I have the same parameters set for both the main report and the subreport. I have been trying to figure this out for about 5 hours and have not been able to resolve the situation. I recieve the following error when I try to run the report (main and sub) and sometimes when I run the subreport by itself: "Warning 1 [rsErrorExecutingSubreport] An error occurred while executing the subreport 'Weekly_Hours' (Instance: 64iS0): Data retrieval failed for the subreport, 'Weekly_Hours', located at: /Weekly_Hours. Please check the log files for more information." All connections work and I have the same parameters set in each report.

Now that I have continued to mess with it I now get this error instead: "[rsWarningExecutingSubreport] Warnings occurred while executing the subreport Weekly_Hours. [rsNone] The value provided for the report parameter 'StartDate' is not valid for its type." "Error: Subreport could not be shown" My report is showing employee projects and how many hours they have worked on each of them (main). The subreport shows the dates worked and how many hours worked per date. The common parameters are lastname, startdate, and enddate. Both of the date parameters for each report is type date and lastname is text. I'm not sure why I am getting this error. Parameters of the main and subreport.

can you tell us, how you are passing the parameters to the sub report? you can check http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD http://msdn.microsoft.com/en-us/library/ms160348(v=sql.100).aspx regards joon

Hi Joon. Thank you for your response. I am not sure what you are asking, can you be more specific? I am not very experienced with SSRS. I basically just have the main report with the subreport below it. I have gone into the properties of the subreport and have the same parameters set. That's basically all that I have done in regards to the similar parameters.

Stupid me...... needed these to be the subreport values.