Report Builder - Limiting query to return a certain number of results, how?
Hello,
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
Regards,
Olivier.