I am trying to set a Reporting Services Report that will prompt user for the language use to on the report. Based on the language selected i will like to use the currency for that language.

I created a function but it errors in the reporting services code

Function SetLanguage(ByVal value AS Object) As Object

    If value = "EUR"
        Return "French"
    ElseIf value = "GBP"
        Return ""French"
    Else
         Return "French"
    End If

End Function


and this is the error I get
Build complete -- 0 errors, 0 warnings
[rsInvalidLanguage] The value of the Language property for the textbox ‘AllocableAmount’ is “French”, which is not a valid Language.
Preview complete -- 0 errors, 1 warnings

The server default language is English and its collation is case sensitive

Thanks






Jaime E. Maccou

__________________
Jaime E. Maccou