When a pivot report is made with Other selected, drilling into the Other column does not pull up the right data set and in some cases the query is truncated.
Steps to Reproduce
Go to /incident_list.do.
Create a pivot report on the incident table with the following values:
- Row: Incident state
- Column: Caller
- No. groups: 10
- Show other: true
For more information, see the product documentation topic Create a pivot table report in the Report Builder.
- Set the condition to [Created] [on] [This year].
- Run the report and drill down to Total/Total.
Uncheck the Show Other check box and set Max number of groups to Show all so the Other column does not display.
Related Problem: PRB706658