-
-
-
-
-
- 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
How to Simplify a Map
- Main
- KB + Tips
- KB - Dashboard Designer
- How to Simplify a Map
If you’re using custom maps in the Dashboard and they take a long while to load or process filters, this may be due the maps being in very high resolution, very high resolution maps take longer to process because they have too much detail on them; most of the time, you can discard part of that detail and still have a high resolution map that will load and process faster.
This process is called simplify and you can do it using the open source tool QGIS (available here: http://qgis.org/), and following these steps:
1.- Download and install the latest version QGIS.
2.- Open the QGIS Desktop application (you can do it from the Start Menu).
3.- On the Browser Panel (at the left) navigate to the shapefile you want to modify and add it to your project (double click it).
4.- Go to Vector->Geometry Tools->Simplify Geometries.
5.- There verify that the layer selected is the one with the map you want to simplify.
6.- Under Simplify Tolerance put how much you’d like to simplify the map (0.0010 is the recommended value as the default value will do very little simplification).
7.- Select the option Save to New File and click on browse and select a name for your simplified map.
8.- If you want to see the result in QGIS, leave the Add Result to Canvas option enabled otherwise disable it.
9.- Clik Ok and wait for the process to end.
10.- Once it’s done review the map and if it’s fine, close QGIS and load the map in DBxtra.
As a rule of thumb any map bigger than 1MB will take a while to load, so you can play with the Simplify Tolerance option to make your map smaller than that, so you can be sure that the map respond quickly in DBxtra.