-
-
-
-
-
- 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
Geo Point Map
- Main
- DBxtra Dashboard Designer
- Dashboard Items
- Dashboard Maps
- Geo Point Map
The Choropleth Map dashboard item allows to colorize the required areas in proportion to the provided values.
Geo Point Map Types
- The Geo Point Map allows you to place callouts on the map using geographical coordinates.
- The Bubble Map allows you to place bubbles on the map. Each bubble can represent data via its weight and color.
- The Pie Map allows you to display pies on the map. Each pie visualizes the contribution of each value to the total.
- To create the required Geo Point Map dashboard item, use the Geo Point Maps button in the Home ribbon tab.
Providing Maps
Default Maps
Default maps showing various parts of the world.
- World Countries – a world map.
- Europe – a map of Europe.
- Asia – a map of Asia.
- North America – a map of North America.
- South America – a map of South America.
- Africa – a map of Africa.
- USA – a map of the USA.
- Canada – a map of Canada.
Select a default map
- To select a default map click on the Default Map button on the Design – Open menu.
Custom Maps
You can use shape-file (.shp ) vector format to provide custom maps.
- Either load a shape-file or import a shape-file map by clicking the button on the Design – Open menu.
Data Binding
A Geo Point map must have the Lattitude and Longitude data sections, which accept dimensions used to provide geographic latitude and longitude, respectively.
Geo Point Map
The Geo Point Map dashboard item provides the Value data section, which accepts values related to geographic points. These values are displayed within map callouts.
Bubble Map
The Bubble Map dashboard item provides the Weight and Color data sections, which provide measures used to evaluate each bubble’s weight and color, respectively.
The Bubble Map dashboard item automatically selects palette and scale settings used to color bubbles.
- Click the Options button next to the Color placeholder to customize it.
This invokes the Color Scale Options dialog, which allows you to specify the palette and scale options.
Pie Map
The Pie Map dashboard item provides the Values and Argument data sections. The Values section accepts measures used to calculate pie values. The Argument section allows you to provide data for pie arguments.
Pie Options
The Pie Map dashboard item allows you to take into account the weight of pies. In this case, the relative sizes of the pies depend on the corresponding summary values. To enable this capability, use the Weighted Pies button in the Design ribbon tab. (Click the button if you are using the toolbar menu.)
If you added a data item to the Argument section and several data items to the Values section, you can use the Values drop-down menu to switch between the provided values.
- To invoke the Values menu, click the icon in the map’s caption or use the map’s context menu.
Tooltip
- To add a tooltip drag and drop the required dimensions or measures to provide additional data.
Clustering
When a Geo Point map contains a large number of objects (callouts, bubbles or pies), showing each object individually on the map might not be useful.
- Click the Enable Clustering button on the Data menu to enable this feature.
Legend
A legend is the element of a map that shows values corresponding to each color.
- Click the Show Color Legend button in the Color Legend – Design menu.
- Specify the legend’s position and orientation
Weighted Legend
The weighted legend allows end-users to identify values corresponding to specific bubble/pie sizes.
- Select an option on the Show Weighted Legend on the Data menu.
Interactivity
When Interactivity is enabled, an end-user can click a grid row to make other dashboard items only display data related to the selected record.