Nested Subreport with Control Parameters

[Sinfathisar]

I have a report with a nested Subreport. Main Report>Subreport1>Subreport2, for simplicity.

I have master/child set up for both Subreports, but I would also like to filter the Subreport2 records with a date range parameter.

Is there a way to get the Subreport2 where clause to recognize the Subreport1 control I want to use for the date range?

So far I have tried:

Between Int([Reports]![Processing_Performance_Req_Dataset]![report]![QC_Static_Processing_Subreport]![Collection_Date]) And (Int([Reports]![Processing_Performance_Req_Dataset]![report]![QC_Static_Processing_Subreport]![Collection_Date])+0.9)

Between Int([Reports]![Processing_Performance_Req_Dataset]![QC_Static_Processing_Subreport]![Collection_Date]) And (Int([Reports]![Processing_Performance_Req_Dataset]![QC_Static_Processing_Subreport]![Collection_Date])+0.9)

and

Between Int([Reports]![Processing_Performance_Req_Dataset]![QC_Static_Processing_Subreport].[Report]![Collection_Date]) And (Int([Reports]![Processing_Performance_Req_Dataset]![QC_Static_Processing_Subreport].[Report]![Collection_Date])+0.9)

where Processing_Performance_Req_Dataset = Main Report
QC_Static_Processing_Subreport = Subreport1
and Collection_Date = textbox control on Subreport2.

Is there a syntax error? I have other, single level, Subreports on the main report with a similar data range parameter that work just fine. Or does this type of parameter input not work on second level Subreports? Every time I run the main report it asks me for a parameter but doesn't accept my input, and Subreport2 doesn't load any records.

Thanks for any input.

 

[GinaWhipp]

Hmm, okay, so I *think* they only to do this is to out hidden fields in the main report that pull the dates from Subreport 1 and then using that as the parameter on the main report in the second Subreport.

Hopefully, you got that...

 

[Sinfathisar]

It worked! Thank you so much - and it was super easy as I already had the needed hidden field on the main report

 

[Sinfathisar]

Now to see if I can make Subreport2 a chart with the same, correct data on it

 

[GinaWhipp]

You're welcome... Glad to help!