SaveToDB Reports Tab

The SaveToDB add-in lets you configure the Reports tab effectively.

You can set up:

• Save menu
• Reload menu
• Actions menu
• Excel context menu
• Row and column filter sets
• Ribbon parameters

With these features, you can create interactive reports without needing macros.

To experiment with the controls, create a test workbook using the Create Report Sample button in the Developer Tools menu.

The add-in reads the Reports tab configuration from special worksheets that you can easily create and customize.

Data Group

Save Menu

This menu includes elements configured with the save and merge types.
Use these elements to save or merge data into databases.

Reload Menu

This menu contains elements configured with the reload type.
Use these elements to reload data on other sheets from data sources.

Actions Menu

This menu features elements configured with the actions type.
Use these elements to perform various actions, such as executing stored procedures, opening URLs, or exporting reports to Excel or PDF.

Configuration Group

Show

This button unhides all rows and columns hidden by filters.

Apply Menu

This menu contains elements configured with the filter type.
Each filter element defines a row and a column with empty, 0, or 1 cell values, typically calculated by formulas.
The add-in hides rows and columns for 0 and unhides them for 1.
Since filter cells can contain formulas that use parameter values, you can create dynamic reports using only Excel formulas.

Parameters Group

This group displays parameters configured with the parameter type.
The add-in applies the current filter configuration when parameter values change.

Use the group dialog box launcher to open the Reports tab configuration worksheet.