>Anyone,
>
>I originally had 7 output fields in the report footer band that were a combination of counts and sums defined using field calculation settings and each field's format is set for numeric and has a specific masking like (99,999 or 999,999,999 or 99,999,999.99) which are produced normal and correct output.
>
>Later I needed to exclude some of the records from the report totals so I introduced 7 report variables where I applied a IIF statement to only calculate the counts and sums for the records I want. I changed the original 7 output fields to (1) reference the corresponding report variable and (2) set each field's calculation setting to NONE because the values are already calculated..
>
>Now 4 of the 7 output fields show asterisks as if the values have exceeded the field sizes or mask settings. If I enlarge all of the fields (which I don't really have room for) the values all display and are well within the masking set for each field (and the values are actually smaller than before when the fields produced normal and correct output.) I tried introducing INT() and ROUND() and everything else to try to get them to fit in the original field sizes. All 7 fields are set as numerics and only have a format mask setting.
>
>Why does mapping a report field to a view field give correct display and when mapped to a variable (containing the same or smaller value) behave as if the field size/mask is exceeded?
>
>Gary.

Can you try casting the variable to the needed range, say, cast(myVar as N(10,3)) ?