How Can I compare date of main report with a date of subreport to get data?

Question

I have a main report in of visual studio 2010.

It is group RecipeDate and inside its header there is a subreport. In subreport there is a IssueDate. I want to s all the issuance in the subreport issued right after/on RecipeDate but before the RecipeDate.

For Example:

If I have a Recipe prepared on 18/11/2013

and started issuing from the day i.e 19/11/2013

and the next Recipe is prepared on 25/11/2013.

so I want to show all the issuance between 18/11/2013 till 25/11/2013

is it possible?

Answer 1

Link the RecipeDateof main report with the IssueDate of the sub report using main report links and in subreport Record Selection formula add a condition like

?RecipeDate=?IssueDate