It's all about the answers!

Ask a question

Report Builder - Limiting query to return a certain number of results, how?

Olivier Béghain (1081933) | asked Nov 24 '17, 7:24 a.m.


I'm actually using RTC/RDNG/RQM with their Safe configuration and using the Report Builder, I would like to produce some reports where the returned information is limited to a certain numbers of (work items. For example, listing the risks sorted on their (magnitude/)exposure and show only the top-3.

I was thinking of adding in the SQL statement things like LIMIT or playing with ROWNUM but it does not work. So how can I proceed to limit a list of for example 10 risks to display only 3 in report Builder?Thanks

One answer

permanent link
Rafik Jaouani (5.0k16) | answered Nov 24 '17, 10:17 a.m.

Olivier, I could not do it either. This looks like a good a idea for a new feature request that would let you make the choice in either the report or the dynamic filter. I guess for now you would have to show a minimum of 10.

Your answer

Register or to post your answer.