Cross Tab Drill Through works on not-aggregated, but not work on aggregated

[franky1241]

Hi, users

I have a cross tab report. I changed "Define Contents" to "Yes" and was able to create drill-through to a detailed report. The data only has two one values: 1 and 0. If I reply on default "Aggregate Function" to be "Total" and "Rollup Aggregate Function" to be "Automatic", the drill-through return no result. If I change "Aggregate Function" and "Rollup Aggregate Function" to be "None", the drill-through return correct result.

However, I do need to show the aggregated number on the parent report. Any ideas, tips? Thanks a lot for your help in advance.

Franky