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.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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment