Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Bar chart label change Post Reply Post New Topic
Author Message
Vaneeth
Newbie
Newbie


Joined: 13 Sep 2007
Location: United Kingdom
Online Status: Offline
Posts: 6
Quote Vaneeth Replybullet Topic: Bar chart label change
    Posted: 13 Sep 2007 at 6:26am
I have created a bar chart depicting the sum of conversion values  grouping on contact Id/ContactId . I want the Contact name to be displayed on the x axes rather thaan the Contact Id. I cannot group on Contact Name as they r not unique. Can someone throw light on how to display ContactName on the x axes rather than the Contact Id

Many thanks in Advance,
Vaneeth
IP IP Logged
p&ccrystal
Newbie
Newbie
Avatar

Joined: 06 Sep 2007
Location: United States
Online Status: Offline
Posts: 18
Quote p&ccrystal Replybullet Posted: 13 Sep 2007 at 3:06pm
This solution will help in more ways than just the bar chart labels. If you use Crystal's option to Customize the group name, it will not only make them appear on the bar chart label but the new group name will appear in the group tree.
 
Here's the solution:
1) Select Group Expert under the Report Menu (you can also right-click the Group if in design mode and scroll down to Change Group)
2) Click the Options... button
3) Go to the second tab labelled Options
4) Click in the box labelled "Customize Group Name Field"
5) Then either select the top radio button "Choose from Existing Field" or the second radio button "Use Formula..." in which you can combine fields using formulas to show what you want.
 
This works great in Crystal so reply if you have problems.
10 year user of Crystal Reports - recently implemented Crystal Server 11.5
IP IP Logged
Vaneeth
Newbie
Newbie


Joined: 13 Sep 2007
Location: United Kingdom
Online Status: Offline
Posts: 6
Quote Vaneeth Replybullet Posted: 18 Sep 2007 at 6:50am
Hi ,

 Many thanks. It worked.

Regards,
Vaneeth
Vaneeth
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.