Cross Table View Main Properties

General Cross Table Properties

If no specific item is selected, the Main Cross Table Properties dialog box is opened in order to specify the following parameters by clicking on the command <View> <Properties> or on the corresponding icon $image\iconproi.gif$ :

$image\propcros.gif$

In the above dialog box you can see the Data Source Query name and define the following parameters:

Total: - the default value is None, as in the following example:

$image\totalno.gif$

- You can ask for a total for each row displayed on the right of the cross table, example:

$image\totalrow.gif$

- You can ask for a total for each column displayed on the bottom of the cross table, example:

$image\totalcol.gif$

- You can ask for a total for both row and column displayed on the right and bottom of the cross table, example:

$image\totalbot.gif$

Save Data: the default value is Yes. When running the cross table to display the result, the data will be stored in a local file having the same ClicknDECiDE Builder project name with the extension VPD. That file will contain the latest result data in a compressed mode to save space on your disk. The benefit will be to avoid to run again the cross table against the host database when you will open it later if it has been closed or when you run the Reverse Table, Hide Detail or Show Detail commands. Nevertheless you can refresh the data using the command <Refresh Data> in the <Layout> menu.

If you set that option to No, the VPD file will not be created. It will be then necessary to refresh yourself the cross table worksheet each time you will modify the cross table presentation (pivot the table, hide or display the detail etc.)

HTML Export as a table: is that option is set to YES, the cross-table result exported as an HTML format will be done using a table format without any layout (color etc.) (HTML2 instead of HTML4).