Table Footer

 Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

 

bullet01 Table Footer is the bottom area of the Table. You can add a column in the Footer area, as similar to Table Header.

 

For Example: If you want to display column for Quantity in the Grid Table but its Total, in the Footer Area, Follow the steps mentioned below:

 

Toggle Icon Minus 17Create an Expression: You can add a simple expression in your bound table by following steps:

   

 

    table footer expression.zoom25

                                Fig 1. Expression

 

Click on Table Header> Options>Item Details.

 

Then, select column for sale quantity and double click on it. Expression will be automatically added in your Expression Window.

 

 

table footer expression 1.zoom25

                        Fig 2. Add Column

 

Add Condition using 'where' and add column from Bound column Tab. See the Window.

 

Press Execute Query or F5and See the Results.

   

    table footer expression 2.zoom25

                           Fig 3. Expression Creation

 

To get the Total Quantity add, sum before Sl_Total-Quantity.

 

Press Execute Query or F5and See the Results.

 

Click on Save Expression and give it a unique name. Press ok, a message will pop on your screen and select yes to Save.

 

  table footer expression 3.zoom25

                              Fig 4. Insert Field

 

Click on Connection(s)> Expression.

 

Select your expression and Right Click to to Insert Field.

bullet01 Your expression will be added. You can change the style and size of 'Font' from the option available at the top. See the window below:

 

table footer font.zoom25

                  Fig 5. Font Settings

 

bullet01  Click on 'Save' to save your settings.

 

notes

You can See your Design by clicking on the Print Preview Option on Toolbar.

Table Footer Preview:

 

table footer preview.zoom50

Fig 6. Table Footer Preview