Yes, this is VERY confusing! I have my Subreport Parameters, located under Properties, and then there are the Report Parameters, which have both the Main and Subreport Parameters listed.
I have two stored procedures. The main one has BeginDate, EndDate, County and Region for query parameters. The sub has SubBeginDate, SubEndDate, SubCounty, SubRegion and WorkerID as query parameters....these are the values that need to be passed from the Main to the SubReport.
First, do I specify the Subreport Parameters as Fields or Parameters on the Parameters Tab of the Subreport Properties? I have SubBeginDate, SubEndDate, SubCounty, SubRegion and WorkerID specified here.
Second, for the Report Parameters, I've got all of the above listed. For the SubBeginDate and SubEndDate, I have the Available Values and Default Values listed as Nonqueried...with that I get this error message "The report parameter (SubBeginDate and SubEndDate) has a default value that has both or neither of the following: Values and DataSetReference. DefaultValue must have exactly one of these elements."
I'm so frustrated, because it seems like I've been trying everything. Let me know if I need to clarify any part of this!