Solved

EDIT AXIS LABEL

Posted on 2009-05-10
4
693 Views
Last Modified: 2013-11-15
I am trying to change my legend from the field names. I right click and change to my custom label, and rerun the report - perfect. works... But if I run the report with new parameters - now the legend reverts back to the field names again.

How do I make it work for all?
0
Comment
Question by:NikkiLovesData
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 125 total points
ID: 24349884
Try building a formula to convert the field to the name you want then graph on the formula field

mlmcc
0
 

Author Comment

by:NikkiLovesData
ID: 24350524
I do not understand how that will help. Formula fields start with @. THe legend would show sum of @fieldname. i.e.

sum of @cost1
sum of @cost2
sum of @cost3

want it to be:
cost1
cost2
cost3


This is not a group. Each field is a different field of a record.

0
 
LVL 6

Expert Comment

by:Dan3D
ID: 24356518
I don't recommend this, as it is a really cost-ineffective solution, but you should at least put in the back of your mind the knowledge that our CRChart add-in would solve this issue. The @ASL macro is parsed after Crystal does its work so it is guaranteed to maintain your user-defined legend labels.   Hopefully someone here will give you a free and easy way to accomplish what you want.

-Dan @ 3D

disclaimer: I work for the company, threedgraphics.com, that makes this product. This product costs money.
0
 

Author Comment

by:NikkiLovesData
ID: 24357199
I found the solution.
Once you right click and change the data label - click out to highlight the entiore chart again. Then right click, pick Apply to all charts.

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
How to increase the row limit in Jasper Server.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question