How to use a formula in chart legend

[KH75]

Hi
I am using CR-XI
I have a crystal report chart which displays the field name in the Legend. Is it possible to change the legend


Legend is showing
@YearSale

I want

Sale of 2009

I want to concatenate with parameter value like "Sale of" & @formula1
Please help me
Thanks

Haqqani

 

[lbass]

Please don't start multiple threads on the same topic.

Are you sure you mean the legend? How is your chart set up --what is the "on change of" field, and what is the summary? If you are using formulas, what are the contents? What other values are showing in the legend?

-LB

 

[KH75]

Hi

Nobody answer my first thread that's why I have to start new thread. anyway thanks for reply. I have sale comparision. I want that If user select 2008 & 2009 so Legend should be Sale of 2009 or sale of 2008. I tried "Edit Axis Label" but it wan't work. any idea about it

Thanks again

 

[lbass]

You should not start a new thread even if no one answers--you could simply add another response of your own.

You didn't answer my questions.

-LB

 

[KH75]

Hi

The value is comming from a Stored proceduer. on Chage event value is Cities, Shows value has 1st values is CurrYAmt 2nd is PrevYAmt, Store Procedure has 2
parameters @paraCurrY and @ParaPrevY. I want to show the ledgend is like "Sale of " & @paraCurrY.

 

[lbass]

You can right click on each legend label->edit axis label, but there is no option of add a condition to this via formula. You could make the axis label text transparent (format axis label) and then overlay a formula to replace the text. You might want to also format the chart (format chart->common tab) to lock position and size.

-LB