Ben Langhinrichs

Photograph of Ben Langhinrichs

E-mail address - Ben Langhinrichs







Recent posts

Mon 21 Jun 2021

Custom Domino Extensions presentation



Thu 10 Jun 2021

Notes 12 without all the blue



Wed 5 May 2021

Pull public data into Notes on the fly


December, 2021
SMTWTFS
   01 02 03 04
05 06 07 08 09 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31

Search the weblog





























Genii Weblog

"Top five" style reports with Midas

Thu 28 Jul 2005, 03:20 PM



by Ben Langhinrichs
I had a long time customer contact me because the screenshot I posted (slightly larger version below) reminded him of a question:
I know Midas is flexible and makes these nested reports, but I need a Top Five style report sorted by the total sales posted by each sales person.  Do I have to pre-process all the sales, sort them and then create a report or can Midas do this somehow?
It took me a few minutes to be sure.  I remember that this used to be one of the (very few) popular features of ReportLogic, our ill fated report writer, but ReportLogic used custom API code to do it.  Then it struck me.  I just need to put the total in the tab label, sort the table tab label, which Midas can do, remove all but the first five rows, then clean up the tab labels.  I added this to the Report It! sample db to be sure I was right.

This added a bit of code, although it took away some code too, as it never creates the nested tabbed table.  It simply creates a tab for each city/state combination, adds totals to their tabs, sorts by tab value, removes extra rows (all 63 of them) and then cleans up the remaining tab labels.  You could do the same thing with collapsed sections, and I might add that as well to the Report It! sample.

Report It! sample db - Create nested tabbed tables before Top 5 processing




Report It! sample db - Create Top Five Performing Cities


Copyright 2005 Genii Software Ltd.

What has been said:

No documents found