Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Display of negative amounts Post Reply Post New Topic
Author Message
brainsoup
Newbie
Newbie
Avatar

Joined: 30 Jul 2009
Location: India
Online Status: Offline
Posts: 17
Quote brainsoup Replybullet Topic: Display of negative amounts
    Posted: 20 May 2010 at 12:08am
Hi,
 
I am having a crystal report to which I pass all the parameters as string. A few of these parameters are amount values to be displayed. If the amount is a negative value like -23.04, it is being displayed in the report as "23.04-"
 
The minus sign is getting suffixed instead of being prefixed.
The report has Unicode Characters and the font I am using is 'Arial Unicode MS'. I have tried different font combinations such as Arial, Times new roman etc.., but doesn't seem to work.
 
Is there any workaround/solution to solve this problem?
 
TIA
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 22 May 2010 at 7:32pm

I think it's not about the font. But it's the properties for the field in CR.

Try this:
- right click the field
- click on 'Format Field'
- (make sure Tab 'Number' is selected)
- click 'Customize...'
- change the 'Negatives:' sign / format
- done...
 
 
hope it help
Emir W
IP IP Logged
brainsoup
Newbie
Newbie
Avatar

Joined: 30 Jul 2009
Location: India
Online Status: Offline
Posts: 17
Quote brainsoup Replybullet Posted: 22 May 2010 at 9:36pm
Hi Emir,
I don't have the number Tab displayed since I am passing the amount field as a string parameter.
 
The field displays properly when all the controls in the page are English. The same report with the literals in Arabic, it is having this problem
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 22 May 2010 at 10:45pm
oops..
 
i've created a test report with 1 parameter (string).
and i create a formula (xx) as follow:
tonumber({parameter_var})
 
and follow my previous post.
 
in this stage you'll find Number tab.
 
 
hope it help.
 
Emir W
IP IP Logged
brainsoup
Newbie
Newbie
Avatar

Joined: 30 Jul 2009
Location: India
Online Status: Offline
Posts: 17
Quote brainsoup Replybullet Posted: 22 May 2010 at 11:05pm
Thanks Emir, That worked Smile
IP IP Logged
Ronne
Newbie
Newbie
Avatar

Joined: 20 Jan 2011
Online Status: Offline
Posts: 1
Quote Ronne Replybullet Posted: 20 Jan 2011 at 7:00pm
great work dude,..
i appreciate it,..
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.033 seconds.