Ad hoc view report contains less data than the view displayed in the ad hoc designer web UI

Problem

A user has an ad hoc view with a certain number of rows. When exporting it to PDF or Excel files, only one or two rows are returned. Even after rebuilding the view, the report is still not showing full data.

Cause

After reviewing the ad hoc view and its report, it was discovered that the ad hoc view and report are using different filtered values. It appears that someone has changed the ad hoc view filter selection criteria after creating the ad hoc view report with those filters.

Users can either compare the filtered values between the ad hoc view and its report, or review the ad hoc cache to figure out the discrepancy from the parameter listed values in the ad hoc view and report queries.

Resolution

By using the exact filtered values, the user is able to generate report content the same as shown in the ad hoc view.

=============================================

TTC-20220222- 2087109