I'm having an issue with my Drilldown Report showing no records when my Parent Summary Report contains a Calculated Column. The Parent Summary Report indicates a qty of items exist for a particular row/column, but when the link is clicked the embedded drilldown report shows no records.
I believe the problem is related to the Calculated Column in the Parent Report. The Calculated Column in the Parent Report is used as a filter and that filter is passed down to the Drilldown Report. However, the Calculated Column formula is NOT passed down to the embedded Drilldown Report, so Calculated Column is undefined in the filter.
Has anyone else seen this issue and is there a fix?