Subreports data is coming blank after giving date condition in main Report
I am facing a strange issue i.e. Subreports' data is coming blank after giving date condition in main Report
There is a main Report (showing Order detail) and 2 sub reports (showing Items in that order)
and the linking parameters are 'Order Id' and 'Store Id'
It's working correctly until I add 'Order Date' parameter in main report (please note Order date is not present in sub report, thus I can't link with 'orderdate' as a parameter) to show particular week's order, after adding 'date' criteria in main report filter, its showing correct data as per date range selected in main report, but the sub reports are coming blank. If I remove this criteria, subreport showing correct data.
Please suggest, how to fix this issue (I am using SAP Crystal Reports for Enterprise Version 14.0.7)?