Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

How to limit numbers of records in report

Avatar

Level 1
I'm working on a report to show the top 5 projects from a risk / value persective. I cannot seem to find a way to limit the number of records returne by WF. This would be similar the TOP qualified for a SQL SELECT statement. Any ideas? Thanks! Brian
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10
Hi Brian, There is no TOP equivalent available, so instead, I suggest you either hardcode a filter to your report (eg where Risk Calc > 95) to limit it to the top few-or-so-if-any and adjust the "95" as needed when real data changes, and/or add a prompt to the report so users can choose the range dynamically. Neither is quite what you want, but perhaps one will be Close Enough. Regards, Doug