Users are unable to create multilevel pivot reports on the Tag field


Description

Users cannot group multilevel pivot reports on tags.

Steps to Reproduce

  1. Create a new multilevel pivot report.
    • Set Table to Task [task].
    • In the Available column, move Tags and Assigned to to the Selected column.
  2. Click Run.
    Note the error message: Syntax Error or Access Rule Violation detected by database (Unknown column 'task0.sys_tags' in 'field list').

 

Workaround

It is not possible to group reports on tags. Tags are stored in separate tables that are not part of the reporting platform. This restriction applies to the Columns, Rows, Group by, and Additional group by fields. The error displays either when you run the report or when you select Tags from the Additional group by control in a saved report.


Related Problem: PRB717670