[Reports] Select top 50 Rows

[RH_9982091]

Hello,

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?

Greetings!

[MikeLockwood]

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.

[HelesicPetr · Accepted solution]

@RH_9982091 

I haven't found any solution to do so in query builder. 

The SQL option TOP is missed from the builder UI in a select. 

as @MikeLockwood mentioned. you can only set the limit of tables

PetrH