-
-
-
-
-
- Data Grid
- Data Grid Columns
- Open a Data Grid
- Sort Data Grid Columns
- Filter Data Grid
- Data Grid Grouping
- Merge Cells in Data Grid
- Data Grid Formatting
- Data Grid - Conditional Formatting
- Data Grid - Calculated Fields
- Data Grid Drill Down
- Data Grid Views
- Generate Report from Data Grid
- Refresh Data Grid
- Copy Data Grid Records
- Export Data Grid Data
- Show all articles ( 1 ) Collapse Articles
-
- Pivot Grid
- Pivot Grid Areas
- Pivot Grid Fields
- Pivot Grid Summarize
- Format Pivot Grid Fields
- Expand - Collapse Pivot Grid Columns
- Sort Pivot Grid
- Pivot Grid - Calculated Fields
- Pivot Grid Filters
- Pivot Grid Drill Down
- Pivot Grid Charts
- Pivot Grid Maps
- Pivot Grid Views
- Refresh Pivot Grid
- Export Data from the Pivot Grid
- Embed Pivot Grid into Report
- Show all articles ( 1 ) Collapse Articles
-
-
-
- Dashboard Items
- Dashboard Chart Item
- Dashboard Pie Item
- Dashboard Data Grid Item
- Dashboard Pivot Table Item
- Dashboard Gauge Item
- Dashboard Card Item
- Dashboard Scatter Chart Item
- Dashboard Treemap
- Dashboard Range Filter Item
- Dashboard Filter Elements Item
- Dashboard Text Item
- Dashboard Image Item
- Dashboard Group Item
-
-
-
-
- Schedule Server Jobs
- Add a Schedule Job - Simple Email
- Add Schedule Job - Merged Email
- Add Schedule Server Job - Merged Report
- Add Schedule Job - Alert DBxtra Users
- Add Schedule Server - Export Report Objects
- Add Schedule Job - FTP Upload
- Add Schedule Job - Print Report
- Add Schedule Job – Google Drive Upload
- Add Schedule Job – Dropbox Upload
- Add Schedule Job – Data Dump
- Edit - Delete Schedule Server Jobs
-
-
-
- DBxtra - Excel Reporting Service
- Install the XL Reporting Service
- XL Reporting Service - Driver Requirements
- XL Reporting Service Interface
- Connect Excel Reporting Service to DBxtra Report Repository and Login
- Insert the Report Object's Data into Excel
- Refresh Your Data
- Open DBxtra Reports and Dashboard from within Excel
- XL Reporting Service Security
-
- Articles coming soon
-
-
- Migrating the Report Web Service from legacy (DBxtra version 8.2.3 and prior) to responsive (DBxtra version 9.0.0 +)
- DBxtra version 7.1.0 on Internet Information Server – IIS 6
- DBxtra 7.1.0 on Internet Information Server – IIS 7
- DBxtra version 7.1 – Upgrade DBxtra Report Repository to SQL Server Express.
- How to configure DBxtra to use Internet Information Services on Windows Server 2012
- Open DBxtra reports in web browser on a new tab
- DBxtra 7 – Migrate the DBxtra Repository from a Network Share to Report Web Service
- Report Web Service: How to retain the minimalist menu look on custom styles (Legacy Report Web Service DBxtra ver. 8.2.3 amd prior)
- The Report Web Service shows empty reports or dashboards
- Pass login information from an external application to the DBxtra Report Web Service
- Pass login information from an external application to the DBxtra Report Web Service (DBxtra version 9+ - Responsive)
- Deploying the Report Web Service to Azure (Web Sites)
- What happens to report objects style customizations when I change interfaces in the Report Web Service
DBxtra connects to all popular databases like MS Access, MS SQL Server, Oracle, MySQL, Informix, DB2, DBase, Firebird, FoxPro, Excel; text files and almost any other database through ODBC and OLEDB.
Create a New Data Connection
- Select the type of database you want to connect to.
- If the database type is not listed select OLEDB or ODBC .
Edit a Data Connection
- To edit a Data Connection select the Data Connection and right-click it and select the Edit Connection button.
Data Connection Properties
- To edit Connection Properties right-click the Data Connection and select Properties .
General
- Connection name : You can rename the Data Connection.
- Connection Data : Show information about your Data Connection.
Privileges
- Assign User Group privileges by selecting user groups with privileges to view objects of the selected Data Connection.
Dependencies
- Shows a list of all object dependencies of the selected Data Connection.
Refresh Data Connection
Sometimes you will need to refresh a Data connection; for example if new data base objects like tables and views were created or edited in the database.
- To refresh a Data Connection right-click the Data Connection and select Refresh Connection .
This procedure will retrieve the most current database schema.
Delete Data Connection
- To delete a Data connection right click the Data Connection and click Delete Connection .
Important! If you delete a Data Connection all dependent objects will also be deleted and placed into the Recycle Bin.
Data Connection Offline mode
Offline mode enabled
DBxtra will load Query definitions after the Data Connection is established or when you click the Refresh Connection option.
Advantage : Takes less time loading the object tree view.
Disadvantage : This will take longer loading the object tree for the first time or by refreshing the connection.
You also need to use the refresh option in order to view changes in your database.
Offline mode disabled
DBxtra will load definitions every time you load a Report Object.
Advantage : You always have access to the database object structure and don’t need to refresh the connection to view database object changes.
Disadvantage : Might take longer when loading the Query.