using operators and functions for sql report charts (visual studio 2010)
- by user1682566
I want to create some charts using sql reporting services. But i am unable to use a lot of functions and operators in combination with my data-fields
the following work(Stroke-data type is decimal):
> =Fields!Stroke.Value
> =Sum(Fields!Stroke.Value)
> =First(Fields!Stroke.Value)
> =Last(Fields!Stroke.Value)
> =2+2394.12
the following dont work:
> =Fields!Stroke.Value + 2
> =CStr(Fields!Stroke.Value)
> =CDbl(Fields!Stroke.Value)
> =Fields!Stroke.Value / Fields!Stroke.Value
> =Sum(Fields!Stroke.Value) * 2
all other operators and functions(using Fields!Stroke.Value) dont work too