Article Details
Id:10486
Product:finPOWER Connect
Type:FIX
Version:1.06.03
Opened:26/07/2012
Closed:07/09/2012
Released:17/09/2012
Job: J010096

Report Templates; Columns exposed for export via the 'UpdateExportableColumns' Script event are not shown on the Data Export page

Columns exposed for export via a Report Template's 'UpdateExportableColumns' Script event are not shown on the Data Export page when running a report. The columns are however exported if the 'Include all columns in their original order' box is checked.

The only exception to this is the Branch List report which did have the functionality implemented to include the Scripted columns.

Scripts expose the List of columns as per the following example:

Public Function Main(ByVal reports As ISfinReports, _
                     ByVal reportTemplateId As String, _
                     ByVal eventId As String, _
                     ByRef source As Object, _
                     ByVal parameters As ISParameters) As Boolean

  Dim List As ISList

  ' Assume Success
  Main = True

  ' Handle Events
  Select Case eventId
    Case "UpdateExportableColumns"
      ' Add any new columns to the list of exportable columns that is supplied
      List = DirectCast(source, ISList)

      List.Add("Interest")
      List.Add("InterestEarned")
      List.Add("InterestUnearned")
  End Select

End Function