Ben Langhinrichs

Photograph of Ben Langhinrichs

E-mail address - Ben Langhinrichs







Recent posts

Wed 18 Sep 2019

Perils of PDF 5: Data Confusion



Mon 16 Sep 2019

About that email in Notes



Mon 9 Sep 2019

Perils of PDF 4: Missing and obscured data


November, 2019
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

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