Product Features

See how well ActiveSheets delivers value to its users

spreadsheets-organize-trave

Fully featured Spreadsheet

Core of ActiveSheets is the fully functioning spreadsheet, most professionals are familiar with. It allows users to write cell formulas, formula chaining, presentation level formatting as easy as 1 2 3. The best part is, it doesn’t depend on Excel or any other 3rd party tools that tend to create version conflicts and other dependency issues. Everything is included within ActiveSheets package that makes its installation and upgrades simple and robust.

Drag and drop designing

Most of the reports can be designed only by drag and dropping contents. Connect ActiveSheets with data source, create data source by drag and dropping tables in visual query editor or drag data table directly on the sheet and let ActiveSheets create data source for you. You may customize a few properties, if you like. That’s it. Report preview is ready to run on single click of a button.

drag-n-drop

audit

End-to-End Audit Log

Built in change tracking and data log makes ActiveSheets report fully auditable both at design and play levels. Reports designers and players can be assigned full access knowing that every change and addition they make in design or data is fully being tracked.

Collaborative

ActiveSheets makes enterprise-wide reporting and analytics sharing process easier and enables more efficient decision making among team members who may have been working to reach conclusions on an individual basis.

collaboration

dbvendors1

Works with multiple Datasources

ActiveSheets is not limited to work with only some kind of RDBMS or prefer one over the other. You are free to connect with any kind of database engine through its powerful data linking technology.

Extensible

ActiveSheets interactive reports are not only easy to design but also highly extensible. Developers can write report/book extensions in C# or VB.Net using ActiveSheets API or .Net framework. This allows developers to write full-blown applications on the top of spreadsheet user interface.

coding

desktop-laptop-tablet

Windows desktop and Web

ActiveSheets Designer, Player and Viewer are available as desktop application running on MS Windows or as web application running in any first class browser. It will soon be available as mobile app as well.

Data input option at runtime

One of the most distinctive feature of ActiveSheets is its ability to allow end users to input part of the data while running the reports. Data is processed live to show results and saved automatically in host database without affecting actual data coming from ERP. This data can not only be retrieved automatically with the owner reports or periodicals but also could be reused in other reports.

dataentry

ActiveSheets got more features…

Dynamic parameter editors

ActiveSheets features powerful visually created extensible parameter forms to get user input at run time and uses input values in cell formulas and data queries.

Sheet level data filters

ActiveSheets supports dynamically created Data Filters for individual sheets. It enables users to create and play multiple sheets and filter values managed on run time for what if analysis.

Supports Excel functions

You can use almost all of the excel’s built-in functions like VLOOKUP, SUM, IF and SUMIF etc., to write powerful business reports and dashboards

Create your own Custom functions

If there is no built-in function available for a particular requirement or need to encapsulate some processing in one function, you can write you own custom functions and use them in formulas.

Advance Visual Query builder

ActiveSheets has built in visual query editor to write new or edit existing data queries by dragging and dropping tables and queries from database

Live Reporting Data

You can play ActiveSheets books every time with live data coming from your ERP or reuse pre-saved user input and calculations to build rolling reports and periodicals.

Import existing Excel Worksheets

ActiveSheets supports to import existing Excel workbook or sheets and make selected cells or areas dynamic by associating them with data. It makes transition from Excel to ActiveSheets quick and easy.

Built in Revision Control System

Revision Control System allows designers pull a report in workspace, make changes and push back to the server. ActiveSheets keeps track of all changes and allows users to rollback anytime.