Grid and Tree Features

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Grid and Tree Features

Features

1.Pin Columns

2.Hide Columns/Bands

3.Sorting

4.Grouping

 

 

 

 

Hidden columns

There are 2 commonly hidden columns, Name and schema Name in the customization window. These are hidden as Full Name column is visible.(table name eg dbo.A_Table). If you want to group by schema and table name without the schema add these columns to the grid and optionally hide the full name.

 

clip0013

 

Grouping by Schema Name

clip0014

 

 

The Following Ribbon Buttons are common across grids and tree.

 

clip0007

 

 

 

 

Ribbon Button

Example

Autosize columns

Before- Notice  Database column to Index Name Column have trimmed text.

clip0008

After

clip0009

 

Show Grouped Columns

Before

clip0012

After

clip0011

Expand All Groups


Collapse All groups


Export to Excel