Do you wish you could edit an existing EnergyCAP report to get it just the way you want it? Need to create a custom energy report for an upcoming meeting or for monthly distribution? Now, with EnergyCAP’s new Report Designer ad hoc reporting module, you can do both by tapping into your in-house Excel experience and expertise.
Report Designer is an Excel® Add-in that works by importing data right from your EnergyCAP database into Excel via the power of our evolving Application Programming Interfaces, or APIs. In EnergyCAP Online Version 4 releases, APIs form the basis of all application functionality. A one-time Report Designer setup sequence installs the new Excel ribbon feature that provides a direct link to your EnergyCAP database.
Report Designer retrieves your EnergyCAP data – recognizing EnergyCAP user rights – and creates a sophisticated data model utilizing Excel’s powerful built-in functionality. Once the data has been retrieved and the data model has been created, you can use existing Excel functionality, such as PivotTables and PivotCharts, to build your own reports.
If you are an Excel power user, you will especially enjoy using PowerPivot to browse and extend the data model to incorporate your own custom data. Or, if you prefer not to get too deep, you can use or tweak a library of provided Report Designer templates to get the data and presentation you want.
EnergyCAP-hosted customers using EnergyCAP Online can begin using EnergyCAP Report Designer now with an ECMA update! Those customers hosting their own database and/or using only the EnergyCAP Enterprise installed client or EnergyCAP Pro Desktop will have to wait a bit longer, but report help is on the way!