Takes a populated DataTable and returns a Tabular-Data style Summary Table.

Decimal columns will default to currency (no currency symbol will be displayed). To display more than 2 decimal places, use a 'Double' column and specify decimal places using the 'doubleDecimalPlaces' Parameter.

Syntax

finUtilities.DataTableToSummaryTable(dt, [showCrossForBoolean], [longDateFormat], [longTimeFormat], [doubleDecimalPlaces], [displayDoubleAsPercent], [showTotalForColumns])

Parameters

NameTypeOptionalByRefDescription
dt DataTable The DataTable.
showCrossForBoolean Boolean Optional Indicates whether to show a cross to represent 'False' where a Boolean column is present. If omitted, a value of False is assumed.
longDateFormat Boolean Optional Indicates whether dates should be displayed in long format. If omitted, a value of True is assumed.
longTimeFormat Boolean Optional Indicates whether times should be displayed in long format. If omitted, a value of False is assumed.
doubleDecimalPlaces Integer Optional For 'Double' type columns, how many decimal places should be displayed. If omitted, a value of 2 is assumed.
displayDoubleAsPercent Boolean Optional Where a 'Double' column has been specified, set to True to display column as a percentage. If omitted, a value of False is assumed.
showTotalForColumns String Optional A CSV list of Column Names which should have totals displayed.

Return Value

ISSummaryTable

A ISSummaryTable Object.

Member of:
finUtilities
Namespace:
Intersoft.finSupport6
Assembly:
finSupport6, Version=6.0.3
Target Framework:
.NET 9.0