One of the most requested enhancements for the Project Listing Report was to be actually able to filter at the top of each of the columns – like excel and the native transaction drilldown.

We are not keen to use bespoke functionality which makes it more difficult for us to support.

Our review of existing Calumo functionality is this is not possible even with our recent cube redesign. If we want to replicate the Excel functionality that is not possible. Calumo does not have the formulas to find unique values and turn it into dropdown. In the reports, that have the select from a list functionality they have a query behind each one. And that is then fed to a query as in the purchase order report. That is a lot of querying. We can move the member selections to the columns but that is cosmetic and not really the same as they can select parents and also select members not in the report. If we want Excel functionality, Gary prepared a sample report that has an export table button. This is a Calumo function, but doesn’t use the cube. It is only for SQL reports as in the transaction report.