|
DBxtra ver. 7.0.0 |
To view the DBxtra version 6 Helpfile click here. |
DBxtra offers several ways to export data.
Export data from the DBxtra Designer interface | Export to a static Excel sheet | Export to a Live Connected Excel sheet | Export to a Live linked Excel pivot table | Export a Report from the Report preview window | Export data from the Data Grid | Export data from the Pivot Grid | Export Matrix
Click "Export To" on the "Export" menu.
Select a output format.
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 a Reports Object's underlying Query will only send the data without formatting.
Click "Export To Excel" on the Excel menu.
This will export all data contained by your Query or Report.
This will create a new Excel file and open it.
Excel File: select the path of the Excel file.
Sheet: leave blank or enter a name for it.
If the 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.
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.
This will create a new Excel file and open it.
Excel File: select the path of the Excel file.
Sheet: leave blank or enter a name for it.
If the 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 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.
This will create a new Excel file and open it.
Excel File: select the path of the Excel file.
Sheet: leave blank or enter a name for it.
If the 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.
See also: Learn how to export data from Report preview window
See also: Learn how to export data from the Data Grid
See also: Learn how to export data from the Pivot Grid
This matrix shows all Report Export options
