Data Grid Drill Down

DBxtra allows to add unlimited drill downs to a Data Grid.

Note: Drill Downs are supported only for the DBxtra Designer and Desktop Viewer. The Web Report Service does not support drill downs for the moment.

Add a new Drill Down

To add a new drill down click Add Drilldown on the Drilldown menu.

Select the Query or Reports underlying Query form the Data Sources window.

From Fields drop down box select the fields to relate the Drilldown to the main Data grid.

Important! These field must be of the same field type.

Click Add Key to create the relationship.

Click Add Relationship to insert the Drilldown.

Click on the button to display the related Drilldown.

You can add a nested Drilldown to an existing Drilldown.

Select the existing Drilldown.

To add a new drill down click Add Drilldown on the Drilldown menu.

Select the Query or Reports underlying Query form the Data Sources window.

From Fields drop down box select the fields to relate the Drilldown to the main Data grid.

Important! These field must be of the same field type.

Click Add Key to create the relationship.

Click Add Relationship to insert the Drilldown.

Example

The example above shows a Data Grid with customer information.

The first Drilldown shows all invoices for each customer.

The second nested Drilldown shows Invoice line item details for each invoice.

You can use all functionality of the Data Grid like sorting, filtering, etc. inside Drilldown.

Select the Drilldown and click Remove Drilldown on the Drilldown menu.

Important! When removing a Drilldown which has one or more nested drill downs, those will also be removed.

When you open a Data Grid with Drill Downs you will be asked if you want to load them.

If you click Yes then all Drill Downs for this Data Grid will be loaded.

You can also load Drill Downs by clicking on the Drilldown menu.