Spreadsheet Report Designer

Features: Reliable Spreadsheet Reporting Paradigm

e.Spreadsheet Designer automates spreadsheet data access and supports the reuse of Excel models. As result, it can take a manual spreadsheet creation process and make it repeatable and reliable.

Automated Data Refreshes

e.Spreadsheet Designer provides wizards and other tools to quickly and easily define data connections, queries and formats that the spreadsheet report will use every time it is run.

• Data Connection Wizard - displays the accessible data sources and guides the creation of new data source connections.
• Visual Query Wizard - guides the building of a query.
• Data Preview - verifies that the data connections are defined correctly and helps determine that the correct tables where chosen for display.
• Data Formatting Wizard - guides the placing of query data into a spreadsheet format and dynamic cell references for Excel-syntax formulas, calculations and totals.

Multiple Data Source Support

An Excel spreadsheet developed with the e.Spreadsheet Designer can access a variety of databases to automate manual spreadsheet creation processes.

• Out-of-the-Box - provides access to databases supporting JDBC and flat file data sources.
• Custom - provides the ability to add custom data sources when using the Information Object metadata layer product with the iServer Express report server's Open Data Access framework.
• Multiple Data Source Access - incorporates data from multiple data sources into one spreadsheet report.
• Query against Queries - allow a query against the results of other queries and perform joins between them.

Reusable Excel Models

e.Spreadsheet Designer can read Excel files to leverage existing Excel models and provides facilities for report developers and Excel experts to use existing designs for new reports.

• Reusable Models - reads existing Excel files and uses them as a starting point for new designs.
• Design Abstraction - separates the design from the generated reports to better support repeated reuse, and allow what-if modification by end-users without introducing errors in the source design.
• Data Explorer - provides a quick overview of a report infrastructure including data sources, data sets, parameters and security settings, and scripting definitions.

Features Overview Next: True Excel Authoring