The Column Functions Menu contains all of the functions and properties that can be set on Column Headers in the grid. Some of these functions and properties can be set by right clicking on the column header, others are only in this menu.
To begin click the round red button on the lower right of the grid. The red button will turn green and the Grid Functions Toolbar will appear. Click the Grid Functions menu and the Column Functions Menu at the very top of the pop-up menu.
We will exam each of these functions below and explain what they do and why you would want to use them.
Modify Column Header Captions
Although you can modify the column headers simply by right clicking on them and typing in a new caption, this function allows you to change them by choosing the column header from the drop down and changing the text in the text box.
Scroll Tip Column
The Scroll Tip column causes the grid to show a tool tip of the column data if you click the scroll bar and hold it and move up or down the grid. Although you can set the Scroll Tip Column by right clicking on the column header, this Menu item will give you a drop down list box of all of the column headers and you can choose which one to use for scroll tips.
Preview Column Settings
The Preview column is like the Microsoft Outlook e-mail preview. When you select this for a column, the text shows under each row and is immune from the scrolling left and right. Although you can set the Preview Column by right clicking on the column header, this Menu item will give you a drop down list box of all of the column headers and you can choose which one to use for the Preview Column. You can also set the maximum number of lines that can be taken up by the preview row, so your rows don't become too big to scroll through.
Summary Values
Summary Values are a way to sum, count, average and min or max the values of any column. Depending on what type of data is in the column, only the appropriate choices will be available. Turn summary values on or off by clicking the Allow Summaries of Numeric Data. If you turn this function on, you will notice that each column now has an "E" in the header to allow you to set or take away the summary type for each column. When you press the "E" you will see your options for summarizing data. When working with currency, you want to make sure and format the column as currency (see Data Type / Formatting) before you summarize the data, or it will not be currency in the summary row.