Devart Forums

Is it possible to somehow limit the number of rows returned?
I have cases where the user is trying to design reports, so only needs 25 records to do the report design, but needs all records when the report is actually run, so am wondering how to place a limit on the number of records returned from a dynamic query (so I don't know ahead of time which fields or tables are being returned), without requiring them to modify the query manually to select top x records.(error prone, because they may end up leaving it in there)

automatically generate query like

select top 25 * from (
<< your original query>>
) a

?

At present SDAC does not support this functionality. You can suggest this feature at our UserVoice ( http://devart.uservoice.com/forums/1046 ... components ). If the suggestion gets a lot of votes, we will consider the possibility to implement it.