Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display 2 decimal places.

Status
Not open for further replies.
bslaast

bslaast

MIS
Oct 22, 2009
46
0
0
US
I want to display 2 decmial places

I currently have:
LPAD(t.full_curr_amount,10,'0')

t.full_curr_amount is a number.


 
Sort by date Sort by votes
Have you tried formatting the display field with N.
 
Upvote 0 Downvote
Format as #,##0.00

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tarikqazza
  • Locked
  • Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
141
tarikqazza
tarikqazza
Jim_P
  • Locked
  • Question
SQL Server Reporting Services(SSRS) preview displays value properly but not rendered in PDF properly
Replies
1
Views
85
kray4660
kray4660
rrvveerriissssii
  • Locked
  • Question
Display string when field value duplicates
Replies
1
Views
26
DaveInIowa
DaveInIowa
Lara Braghetti
  • Locked
  • Question
SSRS 2016 - Issue with labels in pie chart
Replies
0
Views
42
Lara Braghetti
Lara Braghetti
carrach
  • Locked
  • Question
SSRS 2008 r2 - Present user with fields to amend and use amended values in report
Replies
0
Views
35
carrach
carrach

Part and Inventory Search

Sponsor

Back
Top