Article Details
Id:11906
Product:finPOWER Connect
Type:FIX
Version:2.01.00
Opened:22/05/2014
Closed:27/05/2014
Released:27/06/2014
Job: J013310

Report Templates; Hiding columns in "ColumnsUpdate" Script event not working correctly

Hiding columns in a Report Template's "ColumnsUpdate" event was not working correctly. The hidden columns were still included on the report.

The following code demonstrates how to hide columns using the Report Template's Script:

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

  Dim Columns As ISReportColumns

  ' Assume Success
  Main = True

  ' Handle Events
  Select Case eventId
    Case "ColumnsUpdate"
      Columns = DirectCast(source, ISReportColumns)
      Columns("AccountId").Visible = False
  End Select
  
End Function

NOTE: This event is only occurs if the Source Type is 'Query' or 'Ad-Hoc Query' or if the Report is 'Generic Columnar Report'.