Link to home
Start Free TrialLog in
Avatar of thayduck
thayduckFlag for United States of America

asked on

SSRS Format Dollar Amount in text box

What shows in text box:

    $  23.45
   $ 100.50
$ 1,000.75
       $ 1.00

What user wants:

$      23.45
$    100.50
$ 1,000.75
$         1.00

User wants $ symbol to show in same fixed position and not float in the text box.
Is there a way to do that  without creating  a separate text box just for $ sign ?
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thayduck

ASKER

Do not want to create a text box just for a $.  There has to be a better way.
due to different values can have a different "character length", for example "W" is wider than "I". It's really difficult and inefficient to set the space to align those characters to have a good look.

the best I can think of is to using different textboxes to achieve that. Of course, you can format the currency textbox so that it just look like a Label control.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My solution works while in report builder.