Prev: Request to IIS hangs when accessing SQL Reports
Next: Column Alias
From: Jack Bender on 8 Apr 2010 08:49
I need to show/hide a line in a report depending on if more than one value is
chosen in a multi-select parameter.

I know how to determine if that is possible. I just look for a comma in the
following formula…

="Provider Type: " & Join(Parameters!ProviderType.Value, ", ")

My only issue is within SRS Expression Syntax, how do I look for the comma
within an SRS expression? What is the formula to look for a value in a
string?

Any assistance is extremely appreciated.


From: Jack Bender on 8 Apr 2010 10:51
I figured it out using the InStr expression.

The final formula was

=iif(InStr(Join(Parameters!Territory.Value, ", "),",") > 0, False, True)

With regards to understanding, the zero above relates to where it expects to
find the comma in the sting, so if no comma exists, it returns a zero, but if
a comma exists, it returns the numeric location of the comma. Hence for the
example of “North America, Western Europe”, it would return the numeric
placement of 14.

"Jack Bender" wrote:

> I need to show/hide a line in a report depending on if more than one value is
> chosen in a multi-select parameter.
>
> I know how to determine if that is possible. I just look for a comma in the
> following formula…
>
> ="Provider Type: " & Join(Parameters!ProviderType.Value, ", ")
>
> My only issue is within SRS Expression Syntax, how do I look for the comma
> within an SRS expression? What is the formula to look for a value in a
> string?
>
> Any assistance is extremely appreciated.
>
>
 | 
Pages: 1
Prev: Request to IIS hangs when accessing SQL Reports
Next: Column Alias