Share or export your work

Contents[Hide]

1. Overview

You can share and export a dashboard, report, or other view: share as a link to send or save, or export it to file formats such as CSV, Excel, an image, PDF, or PowerPoint.

When viewing or editing the view you want to share, find the Share option in the toolbar if displayed. You can also right-click or long-tap an empty part of the view to find it in the context menu.

Access Share options from the toolbar
Access Share options from the toolbar

Tip
If you are editing a file in a project that other people can access, you can also just check it in for them to see it when they next look at the project contents.

Related video: Sharing and Exporting

2. Share options

The Link option gives you a URL for viewing your current dashboard, report, or other view. You can bookmark it in your browser, or send it to someone else. Changes you've made while viewing such as filtering and sorting will also be included in this link (also known as a 'short link').

In the Share dialog, the Link field holds the web address or URL. If you click the copy button next to it and paste the link elsewhere, you can then close the dialog if not using the remaining options.

Choose a viewer configuration option
Choose a viewer configuration option

Under View Options, an option is selected initially so that the view is opened by itself full-screen, without Dundas BI's menu, toolbar, or taskbar (they may still be available from the right-click context menu). Choose a different option if preferred.

If people you're sharing with don't already have access to this view, and you created it or have the Full Control privilege for it, click Give others access and select them. For example, files you create in My Project are only accessible to you by default.

Select users to receive viewing access
Select users to receive viewing access

Important
If you just created this item, be sure you also check it in so that others can access it.

2.2. Image

The Image option uses the PNG format and lets you export the entire view, such as a dashboard or scorecard, or you can select a specific visualization.

The Export dialog will open with the Format set to Image.

Export entire view as an image
Export entire view as an image

The initial settings export the entire view to an image. For dashboards, you can export a specific visualization by setting Selection to Single Item and then choosing the visualization from the next dropdown list.

Export a single visualization as an image
Export a single visualization as an image

The view will be exported as you currently see it, taking into account content that can be shown and hidden, for example. Reports in version 11 and higher export a ZIP file containing an image for each page, and slideshows in version 23.3 and higher do the same for each slide.

2.3. Excel

You can export the all the view's data or data from selected visualizations (including those in embedded views) to the Microsoft Excel format (XLSX) by choosing the Excel share option.

The initial settings export data from all visualizations, with each one in its own sheet or tab. In reports, scorecards, and small multiples, there may be multiple visualizations such as data labels sharing data from a single metric set, which will be combined together in one sheet.

Exporting to Excel
Exporting to Excel

For some view types, the Export dialog has a Selection option you can change: the All Visible option takes into account visualizations that can be shown and hidden while viewing, or choose Selected Items and click to select one or more individual visualizations to export their data, using the Ctrl, ⌘, or Shift keys on your keyboard to select multiple.

Export selected visualizations to Excel format
Export selected visualizations to Excel format

Under Settings, if you do not want to sort date and time columns in the exported Excel file and want to ensure the display format remains the same, clear the Sortable Dates checkbox.

Select Include Parameter Values if you want filter/parameter settings included in the resulting Excel file.

Optionally, select the Include Images checkbox if you want an image of each visualization to be added to the resulting Excel file, or Include Dashboard As Image for an image of the entire dashboard on a separate sheet.

Include Parameter Values in the Excel file
Include Parameter Values in the Excel file

By default, the resulting Excel file will include various customizations and styling applied to text cells in table visualizations such as font colors, background colors, column order, custom header text, etc., as well as include only the data displayed by data points in charts. To exclude this formatting, you can expand the Advanced section and select the Exclude Styles option. Image columns from a table can be included if possible by enabling Add Data Images To File.

Note
Table visualizations are exported with values represented as text (or images), with most styling preserved but without border styling and with other limitations that may be related to technical limitations in Excel. See the Views section of the product notes for details.

2.4. CSV

After choosing Excel or another option from the Share menu, you can change the Format setting to CSV if available. This exports the data displayed by a visualization to a CSV (comma separated values) file.

In this case, only a single visualization within a view can be exported, chosen by setting Selection. (Like for Excel, other visualizations in reports, scorecards or small multiples may be included and combined if they were sharing a metric set.)

Export to CSV format
Export to CSV format

2.5. PDF

The PDF option can be useful for sharing, saving for offline reading, or for printing. Dundas BI reports are also specially designed to be exported to PDF and can include page headers and footers.

In the Export dialog, you can change page options such as the Paper Size and page Orientation:

Export a dashboard to PDF format
Export a dashboard to PDF format

The view will be exported as you currently see it, taking into account content that can be shown and hidden, for example. Dashboards designed in Responsive mode will be exported in Scale mode to better fit the selected page size.

2.6. PowerPoint

The PowerPoint option exports the current view as one or more image slides in a PowerPoint file (PPTX). You can present this file, or copy or combine its slides with others.

Export a dashboard to PowerPoint format
Export a dashboard to PowerPoint format

Most types of views export a single slide, while a report exports a separate slide for each of its pages in version 11 or higher, and a slideshow exports a slide for each of its own slides in version 23.3 and higher.

The slide size in the resulting file is based on the size of the view you are exporting by default, but this can be changed using the Slide Size setting.

3. Downloading exported files

To export to a file immediately from the Export dialog, click Export at the bottom of the dialog to begin the export process. Once it finishes, click the Download the created export button that appears.

Download the export file when ready
Download the export file when ready

You can click the Close button before the export completes, for example when waiting for a long report to export. From your profile, you can then manage the export process or download the file once it finishes, as well as download other recent exports from the last 7 days or the length of time set by your administrator (using the Export Result File Lifetime configuration setting).

4. Delivery settings

You can optionally share your link or exported file directly via e-mail or another available delivery method if you are using version 23.2 or higher. This is similar to a notification but sends the link or file just once on-demand.

Click the Email or Delivery settings button, then choose your recipients and set a message, or set other options – for details, see the similar delivery settings for notifications.

Click the Save button when finished with the delivery options, then click the Save or Export button in the first dialog to share or export via your selected delivery settings.

5. Options when editing

When editing a view such as a dashboard, there are options available to determine what's exported when it's viewed by others.

5.1. Prevent data export

If you do not want viewers to be able to export certain data to Excel or CSV formats, there are options on each metric set and each of its elements. (These do not affect exporting to image, PDF or PowerPoint.)

Important
This should not be relied on for data security, since all metric set data other than for Hidden measures is downloaded by client browsers and can be accessed when viewing.

To prevent the data export for the whole metric set, click the Edit icon in the Data Analysis Panel, then select the Prevent Data Export checkbox in the dialog that appears.

Edit the metric set settings
Edit the metric set settings

Similarly, you can prevent data export for each measure or hierarchy listed for the metric set. Click to edit the element from the Data Analysis Panel, then check the Exclude From Data Export checkbox

Exclude an element from exporting in its settings
Exclude an element from exporting in its settings

5.2. Export timeout

If you expect or find that a particular dashboard, report, or other view will take significantly longer to export to a file than is currently allowed, you can adjust its Export Timeout property.

When editing the view, open the Properties window with nothing selected (click an empty area if you have selected an element), and find this property in the Main tab. Set this in the hh:mm:ss format (where hh is hours, mm is minutes, and ss is seconds), or set to 00:00:00 to use the Export Render Timeout setting in administration.

5.3. The Before Export event

It's possible to add actions such as a Show/Hide action or script that will run only when a user exports to PDF, image or PowerPoint, without affecting general viewing. (Data export to Excel or CSV is not affected.)

To add one of these actions, open the Properties window with nothing selected on the canvas, and find the Before Export actions.

The 'Before Export' event of a dashboard
The 'Before Export' event of a dashboard

For example, you might want to exclude certain content such as buttons when exporting. You can add a Change Layer action from the menu - see this article for similar steps.

Or, the following script would change a dashboard's background color only when exporting:

this.background = new dundas.controls.SolidColorBrush(dundas.controls.Color.fromString("AliceBlue"));

If you write script that performs asynchronous operations such as a data retrieval call during this event, you should make the export process wait for it to finish before it produces its image:

e.isAsync = true;
//...
asynchronousMethod.done(function (result) {
  //...
  // resolve the deferred
  e.deferred.resolve();
});

6. Notes

Some additional general notes not included above:

  • Legends are separate from visualizations in Dundas BI, but can be included in exported images for individual visualizations if they are placed within the boundaries of the visualization (including its padding).
  • Exporting of images, PDFs, and PowerPoint is performed on the server where Dundas BI was installed, so only fonts that have been installed on that server or included in Dundas BI's CSS or HTML can be used to render. If you specify a Font Family not available on the server or use the default font in Dundas BI v11 or earlier running on Linux, a different font may be used than the one in your own browser. (The Source Sans Pro font is included in Dundas BI by default.)
  • If you choose the Append Date To Filename option when exporting, the configuration setting File Name Date Time Format is available for administrators to customize the date's format.
  • You can modify the Company and Creator that appear in exported Excel and PowerPoint files with the Company Meta Data Text and Creator Meta Data Text settings in the configuration settings in the Export category.

7. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri