all groups > sql server reporting services > may 2006 >
You're in the

sql server reporting services

group:

Formatting cents


Formatting cents Scott
5/19/2006 12:49:02 PM
sql server reporting services:
I am using RS 2000 and I am trying to format a total amount. I want the
total amount to be separted into two separate text boxes, one with dollars
and one with cents. I am able to get the dollars portion but unable to get
the cents portion.
For example: If I have 123.05 I want 123 in box A and 05 in box B. The
problem I have is that instead of 05 I get 5.
This is the expression I am currently using and not getting what I want :
= Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
Any help would be greatly appreciated.
RE: Formatting cents Amarnath
5/20/2006 1:33:01 AM
Try this way

= (Fields!Amount.Value) - INT(Fields!Amount.Value)

Amarnath


[quoted text, click to view]
AddThis Social Bookmark Button