-
-
-
-
-
- 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
Dashboard Coloring
- Main
- DBxtra Dashboard Designer
- Design Dashboard
- Dashboard Coloring
The Dashboard Designer allows you to assign coloring of dashboard item elements
You can select if to use a global color scheme with consistent colors for identical values across the dashboard or a local color scheme that provides an independent set of colors for each dashboard item.
You can also edit colors automatically assigned from the default palette.
Color Schemes
The dashboard offers two ways for coloring dashboard items.
- Using a global color scheme that provides consistent colors for identical values across the dashboard.
- To apply global colors for coloring a dashboard item, click the Coloring button in the Design menu.
- Applying a local color scheme that provides an independent set of colors for each dashboard item.
- To apply local colors for coloring dashboard item elements, click the Local Colors button in the Design menu.
Dashboard Coloring Dimensions and Measures
Dashboard items permits you to manage coloring individual dimensions or all dashboard item measures using predefined coloring styles.
Coloring Mode | Description |
Default | Dimension values / measures are colored by default. |
Hue | Dimension values / measures are colored by hue. If coloring by hue is enabled, a data item indicates this using the indicator. |
None | Dimension values / measures are colored with the same color. |
Coloring Dimension Values
- To apply the coloring mode for a required dimension, click the Dimension menu button and select the Color by.
Coloring Measures
- To apply the coloring mode for dashboard item measures, click the button of any Measure and select Color by.
Default Coloring
- A Chart item colors different measures and series dimensions by hue.
- A Pie item colors different measures or argument dimensions by hue.
Customizing a Color Scheme
The Dashboard Designer provides the capability to edit colors contained in global and local color schemes. You can select the required color from the default dashboard palette or specify a custom color.
Edit Color Scheme
To edit colors, use the Color Scheme dialog.
- To edit colors in a global color scheme, use the Edit Colors button in the Home menu.
- Or the Edit Colors button in the dashboard item’s Design tab.
In this dialog, you can perform the following actions.
- Edit automatically assigned colors or specify new colors.
- Add new values to a color table.
- Add new color tables containing values whose colors are not yet assigned.
Edit Colors
- Click a roe and select a color to apply.
- Specify a custom color, by selecting More Colors… and select any color using the RGB or HSB color model in the invoked Select Color dialog.
- Reset the customized color for the selected value using the Reset menu item.
Add a New Value
The Color Scheme dialog allows adding new values with the specified color to the selected color table.
- To add a new value, click the New Value… button.
- Specify the dimension values, add the required measures and click OK.
This will create a new value which color can be edited. - To remove an added value manually use the Remove context menu item.
Add a New Color table
The Color Scheme dialog allows you to add a new color table containing values which colors are not yet assigned.
- To add a new color table this, click the New Color Table… button.
- In the dialog window, select the Data source, add the required dimensions and enable the Measure Names Dimension check-box if you need to add measures to a color table.
- Click OK to add the color table to a color scheme. Now you can add values to this table and specify their colors.
Note! If you apply coloring by hue for several dimensions / measures, all combinations of dimension values / measures will be automatically colored using different colors from the default palette.