Spreadsheet Report Designer

Features: Data-driven Layout

e.Spreadsheet Designer dynamically generates the final Excel file, its worksheets and their layout at run-time based on the latest data and user input.

Run-time Data Refreshes

When e.Spreadsheet-designed Excel reports are run, they read the data sources, automatically update the report and use any parameters specified by the requester.

• Data Refresh - saves the query and data connection definitions for each data source with the report design so that the report can be updated with the most recent data at run time.
• Cascading Parameters - sets up dynamic cascading prompts for users to enter data values and ranges to filter the data and affect the spreadsheet structure.
• Multiple Data Source Reads - reads multiple data sources at run-time, the data from which can be integrated into a single spreadsheet report.

Run-time Layout Generation

Based on the data available when generating a spreadsheet report, e.Spreadsheet Designer will automatically expand, contract, burst and group columns, rows, worksheets and data.

• Automatic Expand and Contract - expands and contracts reports as dictated by the data; for example, columns and rows may expand across the page with outlining.
• Worksheet Bursting - bursts data down rows, across columns and across worksheets within a report.
• Date Groupings - automatically groups data into dates; for example, days, weeks, months and quarters.

Features Overview