Working with Data Types in Expressions (Reporting Services) Data
types represent different kinds of data so that it can be stored
and processed efficiently. Typical data types include text (also
known as strings), numbers with and without decimal places,
dates and times, and images. Data can be stored using one data
type for efficiency but formatted according to your preference
when the data is displayed in the report. For example, a field
that represents currency can be stored as a floating point
number, but can be displayed in a variety of formats depending
on the format property you choose. For more information about
display formats, see Formatting Reports and Report Items. It is
important to understand data types when you write expressions to
compare or combine values, for example, when you define group or
filter expressions, or calculate aggregates. Comparisons and
calculations are valid only between items of the same data type.
If the data types do not match, you must explicitly convert the
data type in