Thursday, March 7, 2013

Use VB Code Into RDLC Report


Right Click into Report And Go to Report Properties and Select Code and Copy And Paste into the below code into Code.

Public Function IsCollumExist(ByVal paramsValue As String, ByVal columnName As String) As Boolean
        Dim flag As Boolean = True
        Dim arrayList As String() = paramsValue.Split(","c)
        For Each obj As String In arrayList
            If obj = columnName Then
                flag = False
            End If
        Next
        Return flag
    End Function

Expression
=Code.IsCollumExist( Parameters!ColumnsContainer.Value.ToString(),"CurrencyName")

No comments:

Post a Comment