do you have YesterdayDate in your form?
how do you compute the value, like:
=DateDiff("d", -1, [tbl_TodaysDate])
you can also SetParameter you variables before Opening the Report:
With Docmd
.SetParameter "[Form]![frm_Report]!YesterdaysDate", me!YesterdayDate
.SetParameter "[Form]![frm_Report]!tbl_TodaysDate", me!tbl_TodaysDate
.OpenReport "yourReportName"
End With
As I said if I open the report directly and enter the dates manually it's shows fine, also I use the same form to open another report which doesn't have any problem opening and showing data. I checked, they are almost identical.