Article Details

Id:	15890
Product:	finPOWER Connect
Type:	NEW
Version:	3.01.11
Opened:	31/01/2019
Closed:	01/04/2019
Released:	03/04/2019
Job:	J021820

Breaking Change

Business Layer; ISQuery; better handling of Captions for dynamic currency columns

Certain reports such as Loan Cash Flow have dynamically captioned columns, e.g., to display the date that the column applies to.

When exported, these columns had generic names such as Column0, Column1 etc.

The main query using this dynamically caption columns (Account List) has been updated to provide captions to the exporter, i.e., the ISDateSetExporter object.

In turn, the ISDataSetExporter.Export methods now have an optional "useColumnCaptions" parameter which is False by default. This maintains compatibility for any Scripts that may use this functionality.

All calls to the ISDataSetExporter.Export methods from within finPOWER Connect have been updated to "useColumnCaptions" hence this is flagged as a breaking change.

The following code sample uses the new functionality to output a DataSet returned from a Query:

DataSetExporter = finBL.CreateDataSetExporter()
With DataSetExporter
  .ExportType = iseDataSetExportType.MSExcelWorkbook
  .FileName = "C:\Test.xls"

  If Query.GetExportDataSet(ds) Then
    Main = .Export(ds,, True)        
  Else
    Main = False
  End If
End With

NOTE: You must use the Query.GetExportDataSet() method rather than just using the Query.DataSet property directly since this method updates the column captions.

WARNING: This functionality is not applied if exporting to the "DataSet XML" format since this is designed to export a .NET compatible version of the DataSet object only.

Print this Article