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.