Hello all,

Thanks for your input in the matter.

I have found a workaround in using a different formatting for the numeric values. Instead of 'g' or N0 or N2 I used...

Any VS 2003 version will do, I believe. Enterprise Architect must certainly! I use Professional, also works fine.

Hello,

Your server side installation sounds OK.

On your local machine you should first install Visual Studio and after that Reporting services, choosing only the designer component.

You should then have a new...

Hello,

You could first check for null with ISDBNull:

Your're expression

=IIf(Fields!New_Old_CC.Value = 1, SUM(Fields!PDC.Value),0)

should be changed to something like this:

=IIf(IIF(ISDBNull(Fields!New_Old_CC.Value),0,Fields!New_Old_CC.Value) = 1, SUM(Fields!PDC.Value),0)

Haven't tested it , but...

Hello all,

The #Error behaviour is by design as far as I know, because in an IIF function, both statements false/true get evaluated regardless of the outcome of the if statement....

There are interesting sample reports available at http://www.msbicentral.com.

Look especially at the CondtionalColumnPlacement.RDL sample. This will probably get you up and running.

Regards.

Jos Janssen