We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

How to change the text of Legends for  Crystal Reports?

Pralad
Pralad asked
on
Medium Priority
7,108 Views
Last Modified: 2010-05-18
Hi

We have crystal report of type line graph and displaying the information  on change of the date but the x axis legend is displaying as " sum of xxxxxxxx" where as I would wish to display the information as xxxxxxxx. I tried by best to make those changes but was unsucessful.

Please suggest

Thanks
Comment
Watch Question

Commented:
Right-click on the chart and select Chart Options -> Titles.  This will open a window where you can edit all of the titles and legends.

frodoman

Author

Commented:
Hi Frodoman,

I did so but there is no provision for change of data labels or legend text. This option shows only

Title, subtitle,Foot Note, group title and data title.

It is not possible this way, if there is any other way please suggest.

Commented:
Sorry, I misundertsood the question.  No, there is no way to change these - they are autolabeled.  There is 3rd party software available that allows you to do it if that's an option for you.  Otherwise, what I commonly do is don't show the legend on the chart and I just create my own text objects to make up my own legend and place it under the chart manually.

frodoman

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
What version you are using? Right click on the axis label and click edit axis label and type in your text. This works in XI.

Gary

Commented:
Gary - I think what he wants to change is the legend / data labels.  I made the same suggestion earlier using the "titles" option to change the axis title. - frodoman

Author

Commented:
I am working with Crystal XI but I am not able to have access to change axis labels.
I tried but that isnt working.
Charlie CollinsManaging Director

Commented:
Actually this works in XI:


Display the report in preview mode in the Crystal XI Designer
Click on the legend
Select the legend you want to edit
    When selected you will have a box around it
Right click the field
Click EDIT AXIS LABEL
Enter the text you want
Hi guys,
I am also running in the same problem. Is this not possible even in full version of Crystal Reports 2008??

I don't want to draw custom legend as my report is very complex and there are multiple charts on a single report.

Regards,
Ashu
sorry! I didn't see last comment by Ayrmer! It works!

Thanks a lot guys!
It's possible, at least in Crystal v8.5.  To change the legend titles, you'll need to first run your report, as you need to see the initial legend title values in order to change them.  In the Preview window, select one of the legend titles and right-click it.  Select "Edit Axis Label...".  A pop-up titled, "Label Aliasing" will appear.  It has two text boxes.  The top box shows the initial label.  The bottom box lets you change the value to whatever you want.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.