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


  1. Go to /

  2. 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.

  3. Set the condition to [Created] [on] [This year].
  4. Run the report and drill down to Total/Total.

Notice that the resulting filter is broken and shows all records from the table 'All>%5esys_created_onONThis+year%40javascript: gs.beginningOfThisYear()%40javascript:gs.endOfThisYear()'.


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

Seen In

Geneva Patch 7
Helsinki Patch 1
Helsinki Patch 2
Helsinki Patch 5

Fixed In

Istanbul Patch 8

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-11-16 15:06:56