Unplanned
Last Updated: 03 May 2023 12:25 by Softwiz
Softwiz
Created on: 03 May 2023 12:25
Type: Bug Report
1
Operator TOP N with DateTime value for the filtering Expression sorts the dataset but returns all data records instead of top N only

I apply the operator TOP N (=5) to get only the first 5 records of a dataset sorted by a DateTime field. It sorts the data correctly as seen in the previewed report, but still returns all data records rather than the first 5 of them.

If I apply the TOP % operator, the dataset seems filtered as expected.

The workaround I have found is to apply second TOP N filtering with an empty expression as seen in the linked screenshot.

I have attached also a sample report demonstrating the issue and the workaround.

Attached Files:
0 comments