i need to create a report that selects only the top 50 rows of a report.
I couldn´t find a statement equals to the "SELECT TOP" SQL.
Could anyone explain how i an do that in the query builder?
Solved! Go to Solution.
This is a good question.
Query builder returns 2000 values by default, then waits for the user to select Next if desired.
That's due to this preference - which every user can set to desired value.
Don't see a way to override this preference for a specific report, but possibly others will know how to do so using a custom input.
Or, possibly there is a way to programmatically change this preference value every time the report is run, then change it back.
Or... possibly the report can be save, then a data monitor set up and that data monitor run daily but as a dummy user who has this preference set to 50.