cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

[Reports] Select top 50 Rows

RH_9982091
6-Contributor

[Reports] Select top 50 Rows

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!

1 ACCEPTED SOLUTION

Accepted Solutions

@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 

View solution in original post

2 REPLIES 2

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.

MikeLockwood_0-1661790010739.png

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.

 

 

@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 

Top Tags