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.
|
One answer
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. |