Export Reports and Data

DBxtra offers several ways to export data.

Export Matrix

This matrix shows all Report Export options

Export Data from the DBxtra Designer interface

• Click Export To on the Export menu.

• Select a output format.

Exporting Reports

• Exporting to PDF, HMTL, MHT, RTF and Images will maintain formatting of the Report.
• Exporting to text, CSV and XML will only send the unformatted data of the Report.

Exporting Data Grids and Pivot Grids

Exporting a Reports Object’s underlying Query will only send the data without formatting.

Export to a static Excel sheet

• Click Export To Excel on the Excel menu.

This will export all data contained by your Query or Report.

• New File: This will create a new Excel file.

• Existing File:This will overwrite an existing Excel file.

• Excel File: select the path of the Excel file.
• Sheet: leave blank or enter a name for it.

Note! If the Excel sheet name does not exist it will be created, if the sheet name exists it will be overwritten.

• Initial Cell: leave blank or enter a cell destination (like C3).
• Add Headers: select to add report headers.
• Open File: click to open the Excel file after the export was successful.

Export to a Live Connected Excel sheet

The Excel file will always be live connected to your databases.

• Once saved, you can deploy the Excel sheet and when you open it click the Refresh button in Excel and your data will be refreshed.
• Click Excel Linked Sheet on the Export menu.

• New File: This will create a new Excel file.
• Existing File:This will overwrite an existing Excel file.

• Excel File: select the path of the Excel file.
• Sheet: leave blank or enter a name for it.

Note! If the Excel sheet name does not exist it will be created, if the sheet name exists it will be overwritten.

• Initial Cell: leave blank or enter a cell destination (like C3).
• Add Headers: select to add Report headers.
• Open File: click to open the Excel file after the export was successful.

Export to a live linked Excel pivot table

The Excel Pivot Table & Chart file will always be live connected to your databases.

• Once saved, deploy the Excel sheet and when you open it click the Refresh button Excel and your data will be refreshed.
• Click Excel Linked Pivot on the Export menu.

New File

: This will create a new Excel file.

• Existing File: This will overwrite an existing Excel file.

• Excel File: select the path of the Excel file.
• Sheet: leave blank or enter a name for it.

Note! If the Excel sheet name does not exist it will be created, if the sheet name exists it will be overwritten.

• Initial Cell: leave blank or enter a cell destination (like C3).
• Add Headers: select to add Report headers.
• Open File: click to open the Excel file after the export was successful.

The Excel file will always be live connected to your databases.

Export a Report from the Report Preview window

 See also: Report Exporting.

Export Data from the Data Grid

See also: Export Data Grid Data.

Export Data from the Pivot Grid

See also: Export Data from the Pivot Grid.