DBxtra .NET Version 3 - Last Updated: November 11, 2008
The Data Grid lets you arrange and view your data just the way you need it.
It allows to arrange columns, groups,and to sort and filter data.
You can also define nested Drill Downs.
DBxtra lets you save your favorite Data Grid Views so you can open them by selecting it.
You can open a Data Grid from any loaded Query or Report.
Create a new or load a saved Query or Report object.
Click Data Grid on the Show Data menu.
You can group data by dragging a column to the group header.
You can create unlimited nested groups.
Click Clear Groups on the Group By menu.
To expand or collapse a group click the Expand / Collapse button on the Expand menu.
To expand or collapse a all groups click the Expand All / Collapse All button on the Expand All menu.
When the Data Grid loads it will inherit its sort order from the underlying Query.
To change the sort order click the column header.
You can also select any column field and click Ascending or Descending from the Sort menu.
To clear all sort orders click Clear Sorting on the Sort menu.
When the Data Grid loads it will show all columns from the underlying Query.
To remove a column select its column header and drag it away.
To add columns click Columns on the Columns menu.
Note: Only columns from the underlying Query which are not in the Data Grid will show.
Select a column and drag it to the position where you want it to appear.
Select the column header and drag and drop it to a new position.
To select the best fit for all selected columns click the Best Fit button and to fit all columns in the window click the Fit All button.
To reset all columns to its original state (just like when you opened it the first time) click Reset on the Column menu.
Click on the Search button on the Filter menu.
Enter the string to search for and optional search options and click Find.
DBxtra will place the cursor on the first record found.
Click Find to search for the next record with the same criteria.
Select a value and right click. Select Filter By.
Or click the Filter By button on the Filter menu.
DBxtra will filter the data accordingly.
You can add a nested filer by selecting another Filter By.
Once a filter is applied you can see the filter condition on the bottom of the Data Grid.
All previously applied filters are accessible on the bottom of the Data Grid.
Click the drop-down box to navigate between filters.
Note: If you save the Data Grid View then all filters will be available in the view.
Once a filter is applied you can edit it by clicking the 
button on the right
bottom.
Apply any criteria and click Apply.
Click on the 
button
below the Data Grid.
Click the Clear Filter on the Filter menu.
Select fields and click the Copy
button on the Copy menu.
This will place the selected data on the clipboard.
You can now paste the selected data to any other application like MS Excel or MS Word.
Click the Copy All button on the Copy menu.
This will place all data from the Data Grid onto the clipboard.
You can now paste the selected data to any other application like MS Excel or MS Word.
Note! If your Data Grid has filters then only the filtered data will be copied and pasted.
Click Summaries on the Columns manu bar.
View Columns: Select the Column to summarize on.
Group Summaries: Select a summary function.
This will enter a summary function on each group level.
Total Summaries: Select a summary function.
This will enter a total summary for all records.
To edit a Summary select it and right click it.
Change the Summary function or select None to remove it.
In order the get the latest data set without closing and re-opening
the Data Grid you can click the 
button.
This will refresh the data in the Data Grid.
You can also set a time value to refresh it automatically.
Select a value in seconds and click Start.
To stop the auto refresh dis select the Start check box.
Caution! If the underlying Query is a large data the auto refresh mode might be system resource hungry.
Related
QUICK MENU