The width and height of the table columns and rows can be adjusted by using the “OnCalcWidth” and “OnCalcHeight:” event handlers. Let's see how to increase the width of the column holding the 11th month of 1999 with the following example. Create an “OnCalcWidth” event handler:
Pascal script:
procedure Cross1OnCalcWidth(ColumnIndex: Integer; ColumnValues: Variant; var Width: Extended); begin if (VarToStr(ColumnValues[0]) = '1999') and (VarToStr(ColumnValues[1]) = '11') then Width := 100; end;
C++ Script:
void Cross1OnCalcWidth( int ColumnIndex, variant ColumnValues, Extended &Width) { if ((VarToStr(ColumnValues[0]) == "1999") && (VarToStr(ColumnValues[1]) = "11")) { Width = 100; } }
And the report becomes:
To hide a column in our example just set the Width to zero. Note that the totals are not recalculated as the table is already filled with values at this point.
|
