Top N Talkers

[JensH]

Hi folks,
I'm looking for a solution to show a list of Top 5 Talkers. I will use the tables from the DataWarehouse in OV NNM. Unfortunately the function topN in CR is only applicable for group results. But I don't want to create group results and show only the topN of these results. I will see only the topN of the data itselfs. Does anybody have enough skill in SQL to tell me, whether it is possible to change the SQL query. The SQL query should show only the top5 in descending order.

I hope my explanation was not that confusing and somebody knows how to solve this "small" challenge.

Thanks a lot in advance !!!
Jens

 

[dgillz]

JensH:

Create a parameter field to prompt you on how many "N" should be. Then create a running total field, evaluate on every record, never to be reset. Then use the sort expert to sort the data in descending order. Finally, right click on the details section of the report and conditionally format the section to suppress if {#count} > {?N-Number} Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine
Cell/VM: 714-348-0964