Control the Excel Presentation
Once you present your data in Excel, DAS displays the 
Presentation menu option on the Quick menu above the grid. You
can use this menu to control how DAS presents your data in Excel. To access these options, click on the Presentation menu:
| To | Do this |
|---|---|
| Adjust the Excel width automatically after each query | Check the Best fit after query button. Uncheck this button to keep Excel column widths intact. |
| Best fit the current visible sheet now | Click Best fit sheet. |
| Auto fit the sheet width to the width of the printer | Check the Auto-fit to printer. Note: If you want to add page breaks to your presentation, make sure to uncheck Auto-fit to printer. |
| Hide/show spacer rows used in Manual Presentation groups | Check the Filter sheet to hide the spacer rows (as defined by the Presentation > Advanced edit > Map group values to Excel > Row padding). Uncheck to show the spacer rows. Note: Show the spacer rows if you want to apply Excel Format Cells. |
| Format the cells of Manual Presentation | Uncheck the Filter sheet button, to make all spacer rows visible. Select the cells and spacer cells and apply the desired Excel Cell Formatting to the cells (E.g. numeric format, bolding, etc.). Re-check the Filter sheet button when you are done to once again hide spacer rows. |
| Show a "clean" look for your report | Click Report look. |
| Show a "spreadsheet" look so you can edit your report | Click Spreadsheet look. |
| Hide/show Excel menus | Click Toggle > Menus. |
| Hide/show grid column and row headings | Click Toggle > Headings. |
| Hide/show grid lines | Click Toggle > Lines. |
| Hide/show worksheet tabs | Click Toggle > Worksheet tabs. |
| Hide/show status bar | Click Toggle > Status bar. |
| Wipe out the visible sheet (i.e. start with a "clean slate") | Click Clear active sheet. |
| Present visible grid columns in Excel | Click Map visible columns to Excel. Once you click, DAS will present the dialog to present columns in Excel Add Charts and Advanced Formatting. |
| Manually edit and refine previous mappings | Click Advanced Edit. With this option, you can append new maps at the end. Use this option if it is important to maintain the order and columns of a previous mapping. You may also add additional mapping such as Report Parameter mapping with this editor. |
| Remove the Excel Presentation | Click Un-embed Excel. DAS will remove the Excel presentation and show the grid showing your query data. |
Utilize DAS Variables in the Excel Presentation
The presentation layer provides a dynamic set of referenceable variables within your reports, including report metadata such as report name and last select time, along with any report parameters and system variables. These variables can be referenced directly within the presentation layer by typing in =DAS with the name of the variable.
| Variable | Definition | Example |
|---|---|---|
| =DAS_ReportName | Returns the full name of the report. | =DAS_ReportName resolves to Supplier Metrics by Business Unit. |
| =DAS_ReportType | Returns either Private or Public based on the report. | =DAS_ReportType resolves to Private. |
| =DAS_LastFetchTime | Returns the date and time when all records run for the report have been loaded. | =DAS_LastSelectTime resolves to 46073.66 OR 3/2/26 3:46 PM (after formatting adjustments) |
| =DAS_LastModifiedTime | Returns the date and time of the last save of the opened report. | =DAS_LastModifiedTime resolves to 46083.63 OR 3/2/26 3:03 PM (after formatting adjustment) |
| =DAS_LastSelectTime | Returns the date and time of the last time data was pulled from the database (or external data source) for the report. | =DAS_LastSelectTime resolves to 46073.66 OR 3/2/26 3:44 PM (after formatting adjustments) |
| =DAS_[ParameterName] | Any parameter created in this report will be available to return in the presentation layer. | =DAS_Business_Unit resolves to 10;20;30;30M. |
| =DAS_[SystemVariableName] | Review the list of available system variables. | =DAS_SYS_USER_ID resolves to the logged in user. |
Note
Any time-based DAS variables will display in the general Excel format by default. Adjust the number format to return the variable in a date, time, or date and time format instead.
