none
How to pass trim servername as parameter ?

    Question

  • Hello, I wanted to see if there is a way to pass a trimmed parameter to the report being generated. Example

    In the report the User inputs server name as:  SERVER989\SQL2008

    The only portion that needs to be passed from their input is the SERVER989

    I have the VB but Im not sure where to put it. 

    Any help would be greatly appreciated.

     

     =Left(Parameters!ServerName.Value, Len(Parameters!ServerName.Value) - InStr(Parameters!ServerName.Value, "\"))

    • Edited by MSSQLRahzel Monday, January 07, 2013 4:25 PM
    Monday, January 07, 2013 4:24 PM

Answers