A simple function for embedding in SSRS Reports that allows you to check and see if an item exists in a array of items (in either a case sensitive or insensitive way).Here is the function;Function ExistsInArray(ByVal SearchTerm As String, ByVal MultiValueParam As Parameter, optional ByVal CaseInsensitive as Boolean = False) As Boolean For i As Integer = 0 To MultiValueParam.Count - 1 If CaseInsensitive = True Then If CStr(LCase(MultiValueParam.Value(i))) = LCase(SearchTerm) Then Return True ...
Monday, May 9, 2011
Oracle PL/SQL: Creating A Database Link
Posted on 2:49 AM by Unknown
This Knol is a quick developers guide to creating a link between two Oracle databases using TNS Information but not editing the TNSNames.ora file on the server.It is quite often the case that it is better to link two databases together and report from one of them rather than draw together information from multiple data sources - usually because the link can be re-used more easily and as you have a requirement to re-use it then it stands to reason other people might.The problem is that DBA's don't generally like developers making changes to the...
Subscribe to:
Posts (Atom)
