Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Percent symbol not showing up in charts Post Reply Post New Topic
Author Message
judylynn
Newbie
Newbie
Avatar

Joined: 17 Nov 2008
Location: United States
Online Status: Offline
Posts: 22
Quote judylynn Replybullet Topic: Percent symbol not showing up in charts
    Posted: 18 Nov 2008 at 8:16am
I have a problem with getting the "%" symbol to show up on the value in charts. I know about the format options on the "Options" tab of the Chart Expert, as well as the "Set Summary Operation" on the Data tab of the Chart Expert. When I use these, I get the symbol but the decimal places are all wrong. For example "12.0%" shows up as "1200.0%". The only other alternative is to show 12.0 with no % sign, which makes it look like it's a number and not a percent.
Can anyone help with this problem?
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 19 Nov 2008 at 1:31am
Hi
 
What Chart Type are you using......
 
Cheers
Rahul
IP IP Logged
judylynn
Newbie
Newbie
Avatar

Joined: 17 Nov 2008
Location: United States
Online Status: Offline
Posts: 22
Quote judylynn Replybullet Posted: 19 Nov 2008 at 5:41am
It is a vertical side by side bar chart.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 19 Nov 2008 at 8:07am
Hi
 
Do this here is the trick
 
I have created a formula to calculate % and divided by 100
 
{Financials.Net Sales} % {Financials.Cash}/100
 
then simply create your chart display data label values in bar
 
then format data lablel select percent and 2 decimal places 
 
 you have the correct figure with % symbol.
 
you have to divide the original value with 100 as the percent option in format datalabel is dividing the datavalues by 100 do wrong results so basically you are dividing the original values by 100 to get 0.12
 
and then in chart labels you are showing them as % with 2 decimal places converting to 12%
 
 
 
Cheers
Rahul
 
 
IP IP Logged
judylynn
Newbie
Newbie
Avatar

Joined: 17 Nov 2008
Location: United States
Online Status: Offline
Posts: 22
Quote judylynn Replybullet Posted: 24 Nov 2008 at 7:20am

This works great- thanks!

IP IP Logged
jlb1
Newbie
Newbie
Avatar

Joined: 10 Dec 2008
Location: Canada
Online Status: Offline
Posts: 5
Quote jlb1 Replybullet Posted: 10 Dec 2008 at 2:51pm
hi judy try the following:
{number 1}/{number 2}*100&"%"
This should add the % sign to the result ie 12%.
Take care,
take care
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.031 seconds.