Hi Jeff,

Thank you so much for your reply.

The fields that selected for the report are from SQL server BD,

define as (Float, null). When I set the Currency format in RS as C

it give me 2 decimals. If I set C0, it will remove the decimal but round it up automatically.

I tried to use your suggestion but somehow I am having problem with Charindex for those number greater than 7 digits...No clue why.

Finally, I used FLOOR function and it works fine.

Select Floor(floatNumberColumn)

from Table1

That give me the number without decimal without round it. Then I use the C0 format for report.

Now I have another problem. Yesterday, I set up Visual Studio Team Foundation Server and now I can not print my report in Color any more

Report only come black and white. Do you hear this problem before?

Thank you very much for your help,

Yumi