SSRS Custom Code Case Statement

Question

Hi,
Tried to create a custom code with case statement and its not working. Maybe if else statement is better

Public Function Cur(ByVal as Value As String) As String
Select Case Value
Case "" Return "$ "
Case "AUD" Return "$ "
Case "USD" Return "US$ "
End Select

End Function

Answer 1

Hi @Anita75 ,
Try the follow function:

 Public Function Cur(ByVal Value As String) As String  
     Select Case Value  
        Case is ""  
            Return "$ "  
        Case is "AUD"  
            Return "$ "  
        Case is "USD"  
            Return "US$ "  
        Case Else  
            Return Nothing   
     End Select     
 End Function  

Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Check this function:

Public Function Cur(ByVal Value As String) As String

    Select Case Value
        Case "", "AUD"
            Return "$ "
        Case "USD"
            Return "US$ "
        Case Else
            Return "???" ' TODO: throw some error?
    End Select

End Function