Solved

EDIT AXIS LABEL

Posted on 2009-05-10
4
687 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
  • 2
4 Comments
 
LVL 100

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

760 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now