Crosstab drillthrough breaks on total column

[lawrencebenson]

Hello Everyone,

I have a report with a crosstab in it.  The columns are Organization, Department, and Empoyee.  The row across the top is Date.  The drillthrough report displays the data in detail in a list view.

I would like to be able to click on the "total" column on my crosstab (fact intersection) however when I do I think the report is passing an empty or null value to the receiving report and no rows are displayed. 

This is my initial date filter:
[ACS_DATE] in (?P_DATE?)

I tried adding the following Date filter:
[ACS_SCHED] in (?P_SCHED?)
AND ParamDisplayValue('P_SCHED') <> ''

The new filter completely breaks the report.

Please help me out.