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, "\"))

Answer 1

Hi,

Add Param2 as a hidden and use an expression to specify the default value below:

=Split(Parameters!ServerName.Value,"/")(0)

Then use Param2 value to pass to the report.

---

Hope this helps!

k r o o t z