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, "\"))
Add Param2 as a hidden and use an expression to specify the default value below:
Then use Param2 value to pass to the report.
Hope this helps!
k r o o t z
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?