By the end of this exercise you will be able to:

• Understand the components of a view
• Create a grid view

Finding Tables and Table Data

1. Open the Insert excerpt_analysisModel_analysisModelnopaneltrue listClick Analysis in the header to show the list of Analysis Models.
2. Find and open the model Screens and Forms 01-08: Views, filters and screens.
3. In the model place your mouse over the table Overall Debt Levels.
4. A hover menu will appear, press 

   Insert excerpt
   _view_show _view_show nopanel true

    and select Default View.
5. The data contained in the table will appear.

Create New View

You will create a new grid view to show the data in the table in a table format:

1. Create Screen:
   
   1. Click on Screen on the Header bar.
   2. Click 

      Insert excerpt
      _add _add nopanel true

      .
   3. Set the screen name to Overall Debt Levels.
   4. Select a Template e.g. Tile No Buttons.
   5. Click the Create Screen button.
   6. A new screen will appear.
2. Now create a new view on the screen:
   1. Use the tabs to navigate back to the analysis model Screens and Forms 01-08: Views, filters and screens.
   2. Double click on the table Overall debt levels.

   3. Insert excerpt
      _pin _pin nopanel true

       this table's properties settings tab.
   4. Using the tabs, select the screen you just created (Overall Debt Levels) to bring this back to the front.
   5. Drag the table icon 

      Insert excerpt
      _tables _tables nopanel true

       in  from the top left hand corner ( of the table config form you pinnedsettings (see below) onto the screen.
      1. 
   6. Choose A popup box will ask you how you would like to display the data as a attributes - choose 

      Insert excerpt
      _grid _grid nopanel true

       view.
   7. This creates a view on the screen, and the properties opens on the right.
   8. From the attributes popup that appears An Available Attributes box will appear - drag the attributes you want (in this case, all of them) from the list onto the view.
   9. Close the Available Attributes box.

You can also see your new view in the list of views for the table:

1. Hover over the table Overall Debt Levels in the Screens and Forms 01-08: Views, filters and screens model.
2. From the hover menu press 

   Insert excerpt
   _view_show _view_show nopanel true

    and select Overall Debt Levels.
   

Editing a View

1. Click on the tab for the screen Overall Debt Levels.
2. Right click on the grid in the screen, select 

   Insert excerpt
   _view_show _view_show nopanel true

    configuration
3. You can edit details of the view in the settings on the right, but there are a number of changes you can make directly to the view in the screen:

Re-order Columns

To re-order columns:

1. Grab a column heading
2. Drag it, drop it in a new position.

Freeze Rows

You can freeze a number of columns.

First prepare some data:

1. Open the analysis model Screens and Forms 11-13. Actions to update, insert, delete.
2. Run analysis on the table Wisteria Books Inventory - this will load data into the table.
3. Create a new view:
   1. Create a new screen: Wisteria Books Inventory
   2. Template: Blank
   3. Drag the table Wisteria Books Inventory onto the screen
   4. Select Grid view
   5. Add all of the attributes
4. Widen the columns so that you can see all (or most) of the text in each column - eventually you will see a horizontal scroll bar appear at the bottom of the view.
5. Image Added

Freeze a column:

1. Freeze the second column (this should be Subject): right-click on the column heading and select Freeze column.
2. Slide the horizontal scroll bar - you will see the first 2 columns are frozen.

Set Width

You can fix the width of a column. By default, columns are flex, which means they will consume the available space. To fix a column width:

1. Grab the right hand edge of a column heading and move it to set the width.
2. Click on 

   Insert excerpt
   _lock _lock nopanel true

    in the toolbar.
3. Maximise the view - you will see that the set column stays the same size, while the remaining columns flex.
4. Right click on your screen and select 

   Insert excerpt
   _unlock _unlock nopanel true

    to continue editing your screen.

Set Flex

If you fix the width of a column, you can return it to being a flex column:

1. Right-click on a column heading.
2. Select Set flex column.

Column Filtering

As well as building permanent filters (you will do this in the next exercise), column filters (sometimes called quick filters) are available to you and the users you are creating this view for. To use a column filter:

1. Hover over a column heading
2. A 

   Insert excerpt
   _filter _filter nopanel true

   .
3. You can select operators and enter value values to filter on the values in that column.
4. You can add clauses to this filter.
5. You can additionally filter on other columns, and these filter will apply together to further filter the data.

Column Sorting

As well as building permanent sort orders (you will do this in a future exercise), you can apply a column sort:

1. Right click on a column heading in the table view
2. Select Sort Ascending or Sort Descending