changing legend text

[prankur]

I am using Crystal report XI. How to change the text in the legend if the report is generated at runtime? It shows the whole text as " Sum of SP_Get_Details.Target" whereas i only want "Target". The option is available as Edit Axis option but that is only present in preview mode whereas i am generating the report at runtime,so legend does not appear in preview mode. The chart is Bar Chart.

[FaFa]

Hi,
A simple way is to do this is add a Formula named E.g Totals (wht ever u want) then in side the formula use the Sum Function to do the required summation, if u r showing the chart group wise then put the formula
under that group, use proper summation

e.g Sum (<Summing field here>, <the group field here>)

then use the formula to the chart to display

even then the chart legend will show as

@Total (@ sign to state that it is a formula)

any way this better than showing the Table name +field name to the user

If u find a solution to the @ sign let me know

FaFa