So,

One of the tricks was to see the difference between

When you create a clustered or nonclustered index, the IGNORE_DUP_KEY option must be set to ON (the default setting).

AND

When you...

To be able to store every possible character in this variable it definitely has to be a nchar(1).

E.g. using 2-byte Unicode characters.

Leo

Made the obvious mistake myself.

My assumption:

1 Not correct

2 Not correct

So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to early!

Always check...

This setting at the end of the rdl code can be set with the Language Property of the report in the properties window.

To get there select Report from the dropdown...

Hello Paul

Create a textbox and set the following Control Source:

=Sum(IIf([Table]![paid],[Table]![Cost],0))

Adjust [Table] to the correct table name.

Succes