Subreports data is coming blank after giving date condition in main Report

[Former Member]

Hi,

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)?

Thanks,

Poonam

[abhilash_kumar]

Hi Poonam,

When you run for a date range, do the 'Order Id' and 'Store Id' fields have any data in them?

-Abhilash

[Former Member]

Yes.