The new Reporting solution does not support some combinations of filter operator and filter column data type. If a report has a filter that uses an incompatible combination, the report will not be migrated to the new Reporting solution.
The following combinations are incompatible:
|Filter Operator||Filter Column Data Types|
|Less Than (<)||Text, Picklist|
|Greater Than (>)||Text, Picklist|
|Less Than or Equal (<=)||Text, Picklist|
|Greater Than or Equal (>=)||Text, Picklist|
|Is Not Between||Text, Picklist|
|Does Not Contain||Picklist|
|Does Not Begin With||Picklist|
|Does Not End With||Picklist|
Prior to migration, it is recommended to ensure that each filter uses a compatible combination of filter operation and filter column data type.
If the filter column is of type picklist, you should use the Equals (=) operator to specify the picklist values that you want the filter to match. For example, replace:
AccountingCode.Type Ends With Revenue
AccountingCode.Type Equals (=) DeferredRevenue, SalesRevenue, OtherRevenue
The corresponding filter in the new Reporting solution is: