Expression switch facility

Hello, I would ask about the possibility of implementing a switch algorithm via expressions in Reporting services to . For example, Can I test on the dataset field a

if a= null -->display none

if a= 1 -->display "string1"

if a= 2 -->display "string2"

some help about this topic

thanks in advance

= Switch(Fields!a.Value = 1, "string1", Fields!a.Value = 2, "string2", Not(Fields!a.Value), "", true, "else string here")

Exporting to Excel - OmitFormulas

Hi,
I want to prevent formulas to be exported to Excel. I know it can be done by
Implementing a Rendering Extension for EXCEL but don't know how.
How can it be done for the all reports in the solution?
Thanks.Are you sure that you are exporting the formulas? Because I though I was not
possible to export the formulas. I am typing =sum(Fields!Value.Value) how do
I have to introduce the formula in order to export it?
"dpbobrock" wrote:
> Hi,
> I want to prevent formulas to be exported to Excel. I know it can be done by
> Implementing a Rendering Extension for EXCEL but don't know how.
> How can it be done for the all reports in the solution?
> Thanks.
>