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.

[Grover]

Hello
I got around this by making the the ?P_DATE? parameter optional.  That way, when Null is passed to the drill through all the rows are returned.  You just have to make sure that the queries for your two reports have the same result sets.  You may have to pass more parameters to get the right information  ie.  If your source report is just for 2009 but your drill through is for all years, you could either add a filter to the drill through so that it only returns 2009 data or pass the year from the source report.
Hope this helps.