Tuesday, December 29, 2009

Crystal Reports : Converting Numerical Values to Currency Values

In any aging or "invoice" report, you will undoubtedly need to sum up some dollar amounts.
This can be tricky, depending on how the back end database is storing the data.

In a perfect world, you are using SQL server and the dollar amount field is declared as CURRENCY.

In the real world, however, the value may be stored at plaintext, which as we all know, cannot be summarized as a numerical value.

Now, we can convert the plaintext INVOICES.AMOUNT into a number by using TONUMBER(INVOICES.AMOUNT).

A better solution might be to use the TOCURRENCY() function, which will not only convert our plaintext to a numerical value, it will also provide the expected number of decimal places, and also display itself with the currency symbol ($).

Just a quick shortcut. You could do the same thing with a combination of the TONUMBER() function and field formatting. I've found that when dealing with dollar amounts, CURRENCY is always preferable to NUMERIC.

9 comments:

Kimberly McNeeley said...

as a coach and when you are giving out any school assignments to the learners essay writing service reallyprofessionalessays.com guarantee you have adaptability and simplicity of perception by the learner.

Jenny Hunt said...

Report writing is, nowadays, considered very important to earn a name or for getting a product or service. Whatever its purpose is, it should be effective, professional and engaging. writing a business report

Zheng junxai5 said...

zhengjx20160623
louis vuitton bags
retro 11
coach outlet
montblanc pens
asics shoes for men
louis vuitton outlet stores
louis vuitton handbags
celine outlet
louis vuitton purses
timberlands
coach factory outlet online
tory burch shoes
nike sb janoski
oakley outlet
kate spade handbags
coach factory outlet
cheap jerseys
coach outlet store online clearances
true religion outlet
michael kors outlet online sale
coach outlet
louis vuitton handbags
ray ban sunglasses
air jordan shoes
michael kors outlet clearance
nfl jerseys
coach outlet online
ray ban sunglasses
ralph lauren outlet
louboutin femme
toms shoes outlet online
coach factory outlet
juicy couture
toms wedges
oakley outlet
cheap louis vuitton handbags
timberland boots
christian louboutin shoes
coach outlet online
nike free 5.0

Hua Cai said...

louis vuitton sunglasses for women
coach outlet online
mont blanc pens
coach outlet store
nfl jersey wholesale
mulberry bags
fitflops outlet
thomas sabo uk
swarovski outlet
cheap oakley sunglasses
coach outlet store
puma shoes
nike air max 90
ralph lauren shirts
true religion uk outlet
michael kors outlet
michael kors handbags outlet
true religion jeans
tiffany and co
gucci sunglasses
toms outlet store
coach outlet
ralph lauren outlet
michael kors outlet uk
nfl jerseys wholesale
ralph lauren outlet
michael kors bags
michael kors factory store
ralph lauren outlet
calvin klein underwear
ferragamo shoes
air max 90
juicy couture tracksuit
beats headphones
michael kors handbags outlet
20160716caihuali

Fangyaya said...

red bottom shoes
louis vuitton purses
polo ralph lauren
louis vuitton
ray bans
louis vuitton handbags
cheap pandora jewelry
jordans for sale
coach outlet
coach outlet
ray ban sunglasses
ugg boots
coach outlet online
cheap basketball shoes
adidas originals store
moncler pas cher
retro 11
ray ban outlet
ugg boots
ugg boots
lebron 12
coach outlet canada
louis vuitton bags
nike roshe run
tommy hilfiger outlet
celine bags
ugg boots
oakley outlet
air max 95
michael kors outlet clearance
insanity workout
uggs for women
coach outlet store online
toms wedges
coach factory outlet online
jordan 6s
nike roshe flyknit
michael kors outlet online
coach factory outlet
cheap toms
20168.13chenjinyan

Paulo said...

Look for a compelling obligation installment procedure Once you have assembled the essential data, this is the ideal opportunity to make a move by investigating conceivable installment alternatives. Of every one of those choices accessible today, understudy credit obligation union stays as the top decision. Cash Advance

Thomas pedro said...

Run with a non-benefit moneylender if conceivable. In the event that you have a decision, run with a non-benefit understudy advance combination firm, for example, Student Lending Works (SLW) who will offer a greater number of advantages and adaptability than standard revenue driven loaning offices. Cash Advance Chicago

marko said...

In any case, this shouldn't imply that matters can't be enhanced ahead of time of presenting an application. The correct moves can fortify the home advance application generally speaking, expanding incredibly the odds of accomplishment. check cashing corona

marko said...

Additionally looking to the financing costs they organization or the bank would offer can likewise help you in choosing which bank you will get your credit. Additionally ask them what expenses they would charge you if there are any. Additionally when you have gotten the advance make certain to peruse and comprehend the strategy. payday loans chula-vista